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

kishore

• Nov 15th, 2011

How to find the instance name?


>select instance_name from v$instance;

nattuduraip

 Profile Answers by nattuduraip Questions by nattuduraip

• Dec 29th, 2010

Instance Name Is DATABASE NAME Default

Answer Question  Select Best Answer

sandeep

• Apr 26th, 2013

Ps -ef | grep oracle

chittu.kotian

 Profile Answers by chittu.kotian Questions by chittu.kotian

• May 16th, 2012

On Unix the command is ps -aef | grep -i pmon

Answer Question  Select Best Answer