First page Back Continue Last page Graphics

Continuation of Notes


Notes:

Common dynamic performance views, continued from the previous page:
V$LOCK – Contains one row for every lock held and locks waited on.
V$TRANSACTION – Contains a rows for every active transaction.
V$LOGFILE – Contains the names, locations of the online redo logs and groups to which they belong.
V$LOG – Contains the size, archive status and other information about the online redo log files.
V$ARCHIVED_LOG – Complete list of archived logs. Contains log name and many details.
Refer to the Oracle9i Database Reference for a description of all documented data dictionary views. (Remember, http://technet.oracle.com has all the Oracle manuals online; membership is free!)