Oracle v$ View List
These views are owned by SYS. The V$ views are actually public synonyms for corresponding SYS.V_$ views
To list all the V$ views on your system look in V$FIXED_VIEW_DEFINITION, or Select name from V$FIXED_TABLEwhere name like 'V$%';
To use these views, ensure that timed_statistics is set in the init.ora file (TIMED_STATISTICS=TRUE). This has minimal effect on performance.
GV$ views are dynamic performance views in a parallel server environment. There is a GV$ view for almost every V$ view. These have an additional column INST_ID (instance number)
V$ACCESS
This view displays objects in the database that are currently locked and the sessions that are accessing them.
V$ACTIVE_INSTANCES
This view maps instance names to instance numbers for all instances that have the database currently mounted.
V$BGPROCESS
This view describes the background processes.
V$CONTROLFILE
This view lists the names of the control files.
V$DATABASE
This view contains database information from the control file.
V$DATAFILE
This view contains datafile information from the control file. See also the "V$DATAFILE_HEADER" view which displays information from datafile headers.
V$DBFILE
This view lists all datafiles making up the database. This view is retained for historical compatibility. Use of V$DATAFILE is recommended instead. For more information, see "V$DATAFILE"
V$INSTANCE
This view displays the state of the current instance. This version of V$INSTANCE is not compatible with earlier versions of V$INSTANCE.
V$LIBRARYCACHE
This view contains statistics about library cache performance and activity.
V$LOADTSTAT
SQL*Loader statistics compiled during the execution of a direct load. These statistics apply to the current table. Any SELECT against this table results in "no rows returned" since you cannot load data and do a query at the same time.
V$LOCK
This view lists the locks currently held by the Oracle Server and outstanding requests for a lock or latch.
V$LOG
This view contains log file information from the control files.
V$MYSTAT
This view contains statistics on the current session.
V$NLS_PARAMETERS
This view contains current values of NLS parameters.
V$PARAMETER
This view lists information about initialization parameters.
V$PQ_SESSTAT
This view lists session statistics for parallel queries.
V$PROCESS
This view contains information about the currently active processes. While the LATCHWAIT column indicates what latch a process is waiting for, the LATCHSPIN column indicates what latch a process is spinning on. On multi-processor machines, Oracle processes will spin on a latch before waiting on it.
V$SESSION
This view lists session information for each current session.
V$SGA
This view contains summary information on the System Global Area.
V$SGASTAT
This view contains detailed information on the System Global Area.
V$SQL
This view lists statistics on shared SQL area without the GROUP BY clause and contains one row for each child of the original SQL text entered.
V$SQL_SHARED_MEMORY
This view displays information about the cursor shared memory snapshot. Each SQL statement stored in the shared pool has one or more child objects associated with it. Each child object has a number of parts, one of which is the context heap, which holds, among other things, the query plan.
V$SQLTEXT
This view contains the text of SQL statements belonging to shared SQL cursors in the SGA.
V$SYSTEM_PARAMETER
This view contains information on system parameters.
V$TABLESPACE
This view displays tablespace information from the controlfile.
V$VERSION
Version numbers of core library components in the Oracle Server. There is one row for each component.
V$WAITSTAT
This view lists block contention statistics. This table is only updated when timed statistics are enabled.
These views are owned by SYS. The V$ views are actually public synonyms for corresponding SYS.V_$ views
To list all the V$ views on your system look in V$FIXED_VIEW_DEFINITION, or Select name from V$FIXED_TABLEwhere name like 'V$%';
To use these views, ensure that timed_statistics is set in the init.ora file (TIMED_STATISTICS=TRUE). This has minimal effect on performance.
GV$ views are dynamic performance views in a parallel server environment. There is a GV$ view for almost every V$ view. These have an additional column INST_ID (instance number)
V$ACCESS
This view displays objects in the database that are currently locked and the sessions that are accessing them.
V$ACTIVE_INSTANCES
This view maps instance names to instance numbers for all instances that have the database currently mounted.
V$BGPROCESS
This view describes the background processes.
V$CONTROLFILE
This view lists the names of the control files.
V$DATABASE
This view contains database information from the control file.
V$DATAFILE
This view contains datafile information from the control file. See also the "V$DATAFILE_HEADER" view which displays information from datafile headers.
V$DBFILE
This view lists all datafiles making up the database. This view is retained for historical compatibility. Use of V$DATAFILE is recommended instead. For more information, see "V$DATAFILE"
V$INSTANCE
This view displays the state of the current instance. This version of V$INSTANCE is not compatible with earlier versions of V$INSTANCE.
V$LIBRARYCACHE
This view contains statistics about library cache performance and activity.
V$LOADTSTAT
SQL*Loader statistics compiled during the execution of a direct load. These statistics apply to the current table. Any SELECT against this table results in "no rows returned" since you cannot load data and do a query at the same time.
V$LOCK
This view lists the locks currently held by the Oracle Server and outstanding requests for a lock or latch.
V$LOG
This view contains log file information from the control files.
V$MYSTAT
This view contains statistics on the current session.
V$NLS_PARAMETERS
This view contains current values of NLS parameters.
V$PARAMETER
This view lists information about initialization parameters.
V$PQ_SESSTAT
This view lists session statistics for parallel queries.
V$PROCESS
This view contains information about the currently active processes. While the LATCHWAIT column indicates what latch a process is waiting for, the LATCHSPIN column indicates what latch a process is spinning on. On multi-processor machines, Oracle processes will spin on a latch before waiting on it.
V$SESSION
This view lists session information for each current session.
V$SGA
This view contains summary information on the System Global Area.
V$SGASTAT
This view contains detailed information on the System Global Area.
V$SQL
This view lists statistics on shared SQL area without the GROUP BY clause and contains one row for each child of the original SQL text entered.
V$SQL_SHARED_MEMORY
This view displays information about the cursor shared memory snapshot. Each SQL statement stored in the shared pool has one or more child objects associated with it. Each child object has a number of parts, one of which is the context heap, which holds, among other things, the query plan.
V$SQLTEXT
This view contains the text of SQL statements belonging to shared SQL cursors in the SGA.
V$SYSTEM_PARAMETER
This view contains information on system parameters.
V$TABLESPACE
This view displays tablespace information from the controlfile.
V$VERSION
Version numbers of core library components in the Oracle Server. There is one row for each component.
V$WAITSTAT
This view lists block contention statistics. This table is only updated when timed statistics are enabled.
No comments:
Post a Comment