Oracle Dynamic Performance Views
Oracle dynamic performance views (v$) are built on the virtual tables ($x). The views (v$) are much more useful than the virtual tables ($x). To get a listing of all them use the following query:
select
NAME
from
V$FIXED_TABLE
where
TYPE = 'VIEW';
Some of the most useful views include:
-
v$databaseDetails about the nature and state of the database -
v$transactionWhat transactions are currently uncommitted -
v$sessionWhat users have logged on -
v$controlfileNames and locations of all control files -
v$logfileNames and locations of all online redo logs -
v$datafileNames and locations of all data files -
v$instanceDetails about the nature and state of the instance -
v$sqltextWhat queries are users issuing -
v$processWhat background and server processes are running
Global dynamic performance views have the prefix gv$. They are viewing across all instances when using a real application cluster (RAC) configuration.
No Comments