Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What are some useful v$ views?

Tips and Tricks

What are some useful v$ views?

by  Michael42  Posted    (Edited  )
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.
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top