Identify Instance Name

How we identify instance name, free space, used space in database & datafile that makes up the system tablespace?

Questions by mojidra   answers by mojidra

Showing Answers 1 - 9 of 9 Answers

chaitra murthy

  • Jan 9th, 2009
 

To check for instance name:-
SQL> show parameter instance_name

To check for free space in tablespace:-
SQL> desc dba_free_space

To check datafile size:-
SQL> desc v$datafile

  Was this answer useful?  Yes

kishore

  • Nov 15th, 2011
 

how to find the instance name?


>select instance_name from v$instance;

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions