Get basic info about Oracle DB

Find out instance info.

select * from v$instance;

Find out database info.

select * from v$database;

Get controlfile info.

select * from v$controlfile

Get DB File info.

select * from v$DBFILE

Get parameter info.

select * from v$parameter

Get session info.

select * from v$session

Get process info.

select * from v$process

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>