Useful v$ Views
Version information of Oracle:
select * from v$version;
Database Name\Log Mode:
select name, log_mode from v$database;
DataFiles in Database:
select name from v$datafile;
Control Files:
select name from v$controlfile;
Redo Log Groups:
select group#, sequence#, members from v$log;
Redo Log Members:
select group#,status,member from v$logfile;
Archive Log Info:
archive log list;
OTHERS
V$SGA - Shows SGA Information
V$INSTANCE - Shows instance information.
V$PROCESS - Shows process information.
V$BGPROCESS- Shows background process information.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.