Oracle7 Server Reference Manual

Contents Index Home Previous Next

Table Descriptions

This section lists the columns and public synonyms for the dynamic performance tables.

FILEXT$

FILEXT$ is created the first time you turn on the AUTOEXTEND characteristic for a datafile.

This Column Datatype Represents This
FILE# NUMBER File identifier
MAXEXTEND NUMBER Value from the MAXSIZE parameter
INC NUMBER Value from the NEXT parameter
For more information, see the Oracle7 Server Administrator's Guide.

V$ACCESS

This view shows objects in the database that are currently locked and the sessions that are accessing them

This Column Datatype Represents This
SID NUMBER Session number that is accessing an object
OWNER VARCHAR2 Owner of the object
OBJECT VARCHAR2 Name of the object
OB_TYP NUMBER Type identifier for the object

V$ACTIVE_INSTANCES

This view maps instance names to instance numbers for all instances that have the database currently mounted.

This Column Datatype Represents This
INST_NUMBER NUMBER The instance number
INST_NAME VARCHAR2(60) The instance name

V$ARCHIVE

This view contains information on archive logs for each thread in the database system. Each row provides information for one thread.

This Column Datatype Represents This
GROUP# NUMBER Log file group number
THREAD# NUMBER Log file thread number
SEQUENCE# NUMBER Log file sequence number
CURRENT VARCHAR2 Archive log currently in use
FIRST_CHANGE# NUMBER First SCN stored in the current log

V$BACKUP

This view shows the backup status of all online datafiles.

This Column Datatype Represents This
FILE# NUMBER File identifier
STATUS VARCHAR2 File status: NOT ACTIVE, ACTIVE (backup in progress), OFFLINE NORMAL, or description of an error
CHANGE# NUMBER System change number when backup started
TIME VARCHAR2 Time the backup started

V$BGPROCESS

This view describes the background processes.

This Column Datatype Represents This
PADDR RAW(4) Address of the process state object
NAME VARCHAR2 Name of this background process
DESCRIPTION VARCHAR2 Description of the background process
ERROR NUMBER Error encountered

V$BH

This is a Parallel Server view.

This view gives the status and number of pings for every buffer in the SGA.

This Column Datatype Represents This
FILE# NUMBER Datafile identifier number (to find filename, query DBA_DATA_FILES or V$DBFILES)
BLOCK NUMBER Block number
STATUS VARCHAR2(1) FREE= not currently in use XCUR=exclusive SCUR=shared current CR=consistent read READ=being read from disk MREC=in media recovery mode IREC=in instance recovery mode
XNC NUMBER Number of PCM lock conversions due to contention with another instance
LOCK_ELEMENT_ ADDR RAW(4) The address of the lock element that contains the PCM lock that is covering the buffer. If more than one buffer has the same address, then these buffers are covered by the same PCM lock.
DIRTY VARCHAR2(1) Y = block modified.
TEMP VARCHAR2(1) Y = temporary block
PING VARCHAR2(1) Y = block pinged
STALE VARCHAR2(1) Y = block is stale
DIRECT VARCHAR2(1) Y = direct block
NEW VARCHAR2(1) Y = new block
For more information, see the Oracle7 Parallel Server Concepts & Administration.

V$CACHE

This is a Parallel Server view.

This view contains information from the block header of each block in the SGA of the current instance as related to particular database objects.

This Column Datatype Represents This
FILE# NUMBER Datafile identifier number (to find filename, query DBA_DATA_FILES or V$DBFILES)
BLOCK# NUMBER Block number
STATUS VARCHAR2(1) Status of block: FREE = not currently in use XCUR = exclusive SCUR = shared current CR = consistent read READ = being read from disk MREC = in media recovery mode IREC = in instance recovery mode
XNC NUMBER Number of PCM lock conversions due to contention with another instance
NAME VARCHAR2(30) Name of the database object containing the block
KIND VARCHAR2(12) Type of database object: TABLE CLUSTER INDEX UNDO = rollback segment
OWNER# NUMBER Owner number
LOCK_ELEMENT_ADDR RAW(4) The address of the lock element that contains the PCM lock that is covering the buffer. If more than one buffer has the same address, then these buffers are covered by the same PCM lock.
For more information, see the Oracle7 Parallel Server Concepts & Administration.

V$CACHE_LOCK

This is a Parallel Server view.

This Column Datatype Represents This
FILE# NUMBER Datafile identifier number (to find filename, query DBA_DATA_FILES or V$DBFILES)
BLOCK# NUMBER Block number
STATUS VARCHAR2(4) Status of block: FREE = not currently in use XCUR = exclusive SCUR = shared current CR = consistent read READ = being read from disk MREC = in media recovery mode IREC = in instance recovery mode
XNC NUMBER Number of parallel cache management (PCM) lock conversions due to contention with another instance
NAME VARCHAR2(30) Name of the database object containing the block
KIND VARCHAR2(12) Type of database object: TABLE CLUSTER INDEX UNDO = rollback segment
OWNER# NUMBER Owner number
LOCK_ELEMENT_ADDR RAW(4) The address of the lock element that contains the PCM lock that is covering the buffer. If more than one buffer has the same address, then these buffers are covered by the same PCM lock.
INDX NUMBER Platform specific lock manager identifier
CLASS NUMBER Platform specific lock manager identifier
V$CACHE_LOCK is similar to V$CACHE, except for the platform specific lock manager identifiers. This information may be useful if the platform specific lock manager provides tools for monitoring the PCM lock operations that are occurring. For example, first query to find the lock element address using INDX and CLASS, then query V$BH to find the buffers that are covered by the lock.

For more information, see Oracle7 Parallel Server Concepts & Administration.

V$CIRCUIT

This view contains information about virtual circuits, which are user connections to the database through dispatchers and servers.

This Column Datatype Represents This
CIRCUIT RAW(4) Circuit address
DISPATCHER RAW(4) Current dispatcher process address
SERVER RAW(4) Current server process address
WAITER RAW(4) Address of server process that is waiting for the (currently busy) circuit to become available
SADDR RAW(4) Address of session bound to the circuit
STATUS VARCHAR2 Status of the circuit: BREAK (currently interrupted), EOF (about to be removed), OUTBOUND (an outward link to aremote database), NORMAL (normal circuit into the local database)
QUEUE VARCHAR2 Queue the circuit is currently on: COMMON (on the common queue, waiting to be picked up by a server process), DISPATCHER (waiting for the dispatcher), SERVER (currently being serviced), OUTBOUND (waiting to establish an outbound connection), NONE (idle circuit)
MESSAGE0 NUMBER Size in bytes of the messages in the first message buffer
MESSAGE1 NUMBER Size in bytes of the messages in the second message buffer.
MESSAGES NUMBER Total number of messages that have gone through this circuit
BYTES NUMBER Total number of bytes that have gone through this circuit
BREAKS NUMBER Total number of breaks (interruptions) for this circuit

V$COMPATIBILITY

This view shows features in use by the database instance that may prevent downgrading to a previous release. This is the dynamic (SGA) version of this information, and may not reflect features that other instances have used, and may include temporary incompatibilities (like UNDO segments) that will not exist after the database is shut down cleanly.

This Column Datatype Represents This
TYPE_ID VARCHAR2(8 Internal feature identifier
RELEASE VARCHAR2(60) Release in which that feature appeared
DESCRIPTION VARCHAR2(64) Description of the feature

V$COMPATSEG

This view lists the permanent features in use by the database that will prevent moving back to an earlier release.

This Column Datatype Represents This
TYPE_ID VARCHAR2(8) Internal feature identifier
RELEASE VARCHAR2(60) Release in which that feature appeared. The software must be able to interpret data formats added in that release
UPDATED VARCHAR2(60) Release that first used the feature

V$CONTROLFILE

This view lists the names of the control files.

This Column Datatype Represents This
STATUS VARCHAR2(7) INVALID if the name cannot be determined, which should not occur. NULL if the name can be determined.
NAME VARCHAR2(257) The name of the control file.

V$DATABASE

This view contains database information from the control file.

This Column Datatype Represents This
NAME VARCHAR2 Name of the database
CREATED VARCHAR2 Creation date
LOG_MODE VARCHAR2 Archive log mode: NOARCHIVELOG or ARCHIVELOG
CHECKPOINT_ CHANGE# NUMBER Last SCN checkpointed
ARCHIVE_CHANGE# NUMBER Last SCN archived

V$DATAFILE

This view contains datafile information from the control file.

This Column Datatype Represents This
FILE# NUMBER File identification number
STATUS VARCHAR2 Type of file (system or user) and its status. Values: OFFLINE, ONLINE, SYSTEM, RECOVER, SYSOFF (an offline file from the SYSTEM tablespace).
ENABLED VARCHAR2(10) Describes how accessible the file is from SQL. It is one of the values in the following table.
CHECKPOINT_ CHANGE# NUMBER SCN at last checkpoint
BYTES NUMBER Size in bytes
CREATE_BYTES NUMBER Size when created, in bytes
NAME VARCHAR2 Name of the file
The following table describes values that can be entered in the V$DATAFILE ENABLED column.

ENABLED Column Value Description
DISABLED No SQL access allowed
READ ONLY No SQL updates allowed
READ WRITE Full access allowed
UNKNOWN Should not occur unless the control file is corrupted
Table 3 - 1. ENABLED Column Values

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.

This Column Datatype Represents This
FILE# NUMBER File identifier
NAME VARCHAR2 Name of file

V$DBLINK

This view describes all open database links (links with IN_TRANSACTION = YES). These database links must be committed or rolled back before being closed.

This Column Datatype Represents This
DB_LINK VARCHAR2(128) Name of the database link
OWNER_ID NUMBER Owner of the database link UID
LOGGED_ON VARCHAR2(3) Whether the database link is currently logged on
HETEROGENEOUS VARCHAR2(3) Whether the database link is heterogeneous
PROTOCOL VARCHAR2(6) Communication protocol for the database link
OPEN_CURSORS NUMBER Whether there are open cursors for the database link
IN_TRANSACTION VARCHAR2(3) Whether the database link is currently in a transaction
UPDATE_SENT VARCHAR2(3) Whether there has been an update on the database link
COMMIT_POINT_ STRENGTH NUMBER Commit point strength of the transactions on the database link

V$DB_OBJECT_CACHE

This view shows database objects that are cached in the library cache. Objects include tables, indexes, clusters, synonym definitions, PL/SQL procedures and packages, and triggers.

This Column Datatype Represents This
OWNER VARCHAR2 Owner of the object
NAME VARCHAR2 Name of the object
DB_LINK VARCHAR2 Database link name, if any
NAMESPACE VARCHAR2 Library cache namespace of the object: TABLE/PROCEDURE, BODY, TRIGGER, INDEX, CLUSTER, OBJECT
TYPE VARCHAR2 Type of the object: INDEX, TABLE, CLUSTER, VIEW, SET, SYNONYM, SEQUENCE, PROCEDURE, FUNCTION, PACKAGE, PACKAGE BODY, TRIGGER, CLASS, OBJECT, USER, DBLINK
SHARABLE_MEM NUMBER Amount of sharable memory in the shared pool consumed by the object
LOADS NUMBER Number of times the object has been loaded. This count also increases when an object has been invalidated
EXECUTIONS NUMBER Not used. To see actual execution counts, see V$SQL_AREA [*].
LOCKS NUMBER Number of users currently locking this object
PINS NUMBER Number of users currently pinning this object
KEPT VARCHAR2(3) YES or NO, depending on whether this object has been "kept" (permanently pinned in memory) with the PL/SQL procedure DBMS_SHARED_POOL.KEEP

V$DB_PIPES

This view shows the pipes that are currently in this database

This Column Datatype Represents This
OWNERID NUMBER The owner of the pipe if this is a private pipe; null otherwise.
NAME VARCHAR2 The name of the pipe; for example, scott.pipe
TYPE VARCHAR2 PUBLIC or PRIVATE
SIZE NUMBER The amount of memory the pipe uses

V$DISPATCHER

This view provides information on the dispatcher processes.

This Column Datatype Represents This
NAME VARCHAR2 Name of the dispatcher process
NETWORK VARCHAR2 Network protocol supported by this dispatcher. For example, TCP or DECNET.
PADDR RAW(4) Process address
STATUS VARCHAR2 Dispatcher status: WAIT (idle), SEND (sending a message connection), RECEIVE (receiving a message), CONNECT (establishing a connection), DISCONNECT (handling a disconnect request), BREAK (handling a break), OUTBOUND (establishing an outbound connection)
ACCEPT VARCHAR2 Whether this dispatcher is accepting new connections: YES, NO
MESSAGES NUMBER Number of messages processed by this dispatcher
BYTES NUMBER Size in bytes of messages processed by this dispatcher
BREAKS NUMBER Number of breaks occurring in this connection
OWNED NUMBER Number of circuits owned by this dispatcher
CREATED NUMBER Number of circuits created by this dispatcher
IDLE NUMBER Total idle time for this dispatcher in hundredths of a second
BUSY NUMBER Total busy time for this dispatcher in hundredths of a second
LISTENER NUMBER The most recent Oracle error number the dispatcher received from the listener

V$ENABLEDPRIVS

This view shows which privileges are enabled. These privileges can be found in the table SYS.SYSTEM_PRIVILEGES_MAP.

This Column Datatype Represents This
PRIV_NUMBER NUMBER Numeric identifier of enabled privileges

V$EVENT_NAME

This view contains information about wait events.

This Column Datatype Represents This
EVENT# NUMBER The number of the wait event
NAME VARCHAR2(64) The name of the wait event
PARAMETER1 VARCHAR2(64) The description of the first parameter for the wait event
PARAMETER2 VARCHAR2(64) The description of the second parameter for the wait event
PARAMETER3 VARCHAR2(64) The description of the third parameter for the wait event

V$FALSE_PING

This is a Parallel Server view.

This view shows buffers that may be getting false pings. That is, buffers pinged more than 100 times that are protected by the same lock as another buffer that pinged more than 100 times. Buffers identified as getting false pings can be remapped in GC_FILES_TO_LOCKS to reduce lock collisions.

This Column Datatype Represents This
FILE# NUMBER Datafile identifier number (to find filename, query DBA_DATA_FILES or V$DBFILES)
BLOCK# NUMBER Block number
STATUS VARCHAR2(1) Status of block: FREE = not currently in use XCUR = exclusive SCUR = shared current CR = consistent read READ = being read from disk MREC = in media recovery mode IREC = in instance recovery mode
XNC NUMBER Number of PCM lock conversions due to contention with another instance
NAME VARCHAR2(30) Name of the database object containing the block
KIND VARCHAR2(12) Type of database object: TABLE CLUSTER INDEX UNDO = rollback segment
OWNER# NUMBER Owner number
LOCK_ELEMENT_ADDR RAW(4) The address of the lock element that contains the PCM lock that is covering the buffer. If more than one buffer has the same address, then these buffers are covered by the same PCM lock.
For more information, see Oracle7 Parallel Server Concepts & Administration.

V$FILESTAT

This view contains information about file read/write statistics.

This Column Datatype Represents This
FILE# NUMBER Number of the file
PHYRDS NUMBER Number of physical reads done
PHYWRTS NUMBER Number of physical writes done
PHYBLKRD NUMBER Number of physical blocks read
PHYBLKWRT NUMBER Number of physical blocks written
READTIM NUMBER Time (in milliseconds) spent doing reads if the TIMED_STATISTICS parameter is TRUE; 0 if FALSE
WRITETIM NUMBER Time (in milliseconds) spent doing writes if the TIMED_STATISTICS parameter is TRUE; 0 if FALSE

V$FIXED_TABLE

This view shows all dynamic performance tables, views, and derived tables in the database.

This Column Datatype Represents This
NAME VARCHAR2 Name of the object
OBJECT_ID NUMBER Identifier of the fixed object
TYPE VARCHAR2 Object type: TABLE, VIEW
TABLE_NUM NUMBER Number that identifies the dynamic performance table if it is of type TABLE

V$FIXED_VIEW_DEFINITION

This view contains the definitions of all the fixed views (views beginning with V$). Use this table with caution. Oracle tries to keep the behavior of fixed views the same from release to release, but the definitions of the fixed views can change without notice. Use these definitions to optimize your queries by using indexed columns of the dynamic performance tables.

This Column Datatype Represents This
VIEW_NAME VARCHAR2(30) The name of the fixed view
VIEW_DEFINITION VARCHAR2(2000) The definition of the fixed view

V$INDEXED_FIXED_COLUMN

This view shows the columns in dynamic performance tables (X$ tables) that are indexed. The X$ tables can change without notice. Use this view only to write queries against fixed views (V$ views) more efficiently.

This Column Datatype Represents This
TABLE_NAME VARCHAR2(30) The name of the dynamic performance table that is indexed
INDEX_NUMBER NUMBER Number that distinguishes to which index a column belongs
COLUMN_NAME VARCHAR2(30) Name of the column that is being indexed
COLUMN_POSITION NUMBER Position of the column in the index key (this is mostly relevant for multicolumn indexes)

V$INSTANCE

This view shows the state of the current instance.

This Column Datatype Represents This
KEY VARCHAR2 Name of state variable, from Table 3 - 2
VALUE NUMBER Value of state variable
The following table lists names and values of state variables.

Instance State Variable Value
RESTRICTED MODE 0 (False), 4096 (True)
SHUTDOWN PENDING 0 (False), 1 (True)
STARTUP TIME-JULIAN Start time and date in Julian format
STARTUP TIME-SECONDS Number of seconds since midnight on the startup date
Table 3 - 2. State Variables

V$LATCH

This view lists statistics for non-parent latches and summary statistics for parent latches. That is, the statistics for a parent latch include counts from each of its children.

This Column Datatype Represents This
ADDR RAW(4) Address of latch object
LATCH# NUMBER Latch number
LEVEL# NUMBER Latch level
NAME VARCHAR2(64) Latch name
GETS NUMBER Number of times gotten wait
MISSES NUMBER Number of times gotten wait but failed first try
SLEEPS NUMBER Number of times slept when wanted wait
IMMEDIATE_GETS NUMBER Number of times gotten without wait
IMMEDIATE_MISSES NUMBER Number of time failed to get without wait
WAITERS_WOKEN NUMBER How many times a waiter was woken
WAITS_HOLDING_ LATCH NUMBER Number of waits while holding a different latch
SPIN_GETS NUMBER Gets that missed first try but suceeded on spin
SLEEP1 NUMBER Waits that slept 1 time
SLEEP2 NUMBER Waits that slept 2 times
SLEEP3 NUMBER Waits that slept 3 times
SLEEP4 NUMBER Waits that slept 4 times
SLEEP5 NUMBER Waits that slept 5 times
SLEEP6 NUMBER Waits that slept 6 times
SLEEP7 NUMBER Waits that slept 7 times
SLEEP8 NUMBER Waits that slept 8 times
SLEEP9 NUMBER Waits that slept 9 times
SLEEP10 NUMBER Waits that slept 10 times
SLEEP11 NUMBER Waits that slept 11 times

V$LATCHHOLDER

This view contains information about the current latch holders.

This Column Datatype Represents This
PID NUMBER Identifier of process holding the latch
SID NUMBER Identifier of the session that owns the latch
LADDR RAW(4) Latch address
NAME VARCHAR2 Name of latch being held

V$LATCHNAME

This view contains information about decoded latch names for the latches shown in V$LATCH. The rows of V$LATCHNAME have a one-to-one correspondence to the rows of V$LATCH.

This Column Datatype Represents This
LATCH# NUMBER Latch number
NAME VARCHAR2(64) Latch name

V$LATCH_CHILDREN

This view contains statistics about child latches. This view includes all columns of V$LATCH plus the CHILD# column. Note that child latches have the same parent if their LATCH# columns match each other.

This Column Datatype Represents This
ADDR RAW(4) Address of latch object
LATCH# NUMBER Latch number for a parent latch
CHILD# NUMBER Child number of a parent latch shown in LATCH#
LEVEL# NUMBER Latch level
NAME VARCHAR2(64) Latch name
GETS NUMBER Number of times gotten wait
MISSES NUMBER Number of times gotten wait but failed first try
SLEEPS NUMBER Number of times slept when wanted wait
IMMEDIATE_GETS NUMBER Number of times gotten without wait
IMMEDIATE_MISSES NUMBER Number of time failed to get without wait
WAITERS_WOKEN NUMBER How many times a waiter was woken
WAITS_HOLDING_ LATCH NUMBER Number of waits while holding a different latch
SPIN_GETS NUMBER Gets that missed first try but suceeded on spin
SLEEPn NUMBER Waits that slept n times

V$LATCH_MISSES

This view contains statistics about missed attempts to acquire a latch.

This Column Datatype Represents This
PARENT_NAME VARCHAR2 Latch name of a parent latch
WHERE VARCHAR2 Location that attempted to acquire the latch
NWFAIL_COUNT NUMBER Number of times that no-wait acquisition of the latch failed
SLEEP_COUNT NUMBER Number of times that acquisition attempts caused sleeps

V$LATCH_PARENT

This view contains statistics about the parent latch. The columns of V$LATCH_PARENT are identical to those in V$LATCH (see [*]).

V$LIBRARYCACHE

This view contains statistics about library cache performance and activity.

This Column Datatype Represents This
NAMESPACE VARCHAR2(15) The library cache namespace
GETS NUMBER The number of times a lock was requested for objects of this namespace
GETHITS NUMBER The number of times an object's handle was found in memory
GETHITRATIO NUMBER The ratio of GETHITS to GETS
PINS NUMBER The number of times a pin was requested for objects of this namespace
PINHITS NUMBER The number of times all of the meta data pieces of the library object were found in memory
PINHITRATIO NUMBER The ratio of PINHITS to PINS
RELOADS NUMBER Any pin of an object that is not the first pin performed since the object handle was created, and which requires loading the object from disk
INVALIDATIONS NUMBER The total number of times objects in this namespace were marked invalid because a dependent object was modified
DLM_LOCK_REQUESTS NUMBER The number of GET requests lock instance locks
DLM_PIN_REQUESTS NUMBER The number of PIN requests lock instance locks
DLM_PIN_RELEASES NUMBER The number of release requests pin instance locks
DLM_INVALIDATION_ REQUESTS NUMBER The number of GET requests for invalidation instance locks
DLM_INVALIDATIONS NUMBER The number of invalidation pings received from other instances

V$LICENSE

This view contains information about license limits.

This Column Datatype Represents This
SESSIONS_MAX NUMBER Maximum number of concurrent user sessions allowed for the instance
SESSIONS_WARNING NUMBER Warning limit for concurrent user sessions for the instance
SESSIONS_CURRENT NUMBER Current number of concurrent user sessions
SESSIONS_ HIGHWATER NUMBER Highest number of concurrent user sessions since the instance started
USERS_MAX NUMBER Maximum number of named users allowed for the database

V$LOADCSTAT

This view contains SQL*Loader statistics compiled during the execution of a direct load. These statistics apply to the whole load. Any select against this table results in "no rows returned" since you cannot load data and do a query at the same time.

This Column Datatype Represents This
READ NUMBER Number of records read
REJECTED NUMBER Number of records rejected
TDISCARD NUMBER Total number of discards during the load
NDISCARD NUMBER Number of discards from the current file
SAVEDATA NUMBER Whether save data points are used

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.

This Column Datatype Represents This
LOADED NUMBER Number of records loaded
REJECTED NUMBER Number of records rejected
FAILWHEN NUMBER Number of records that failed to meet any WHEN clause
ALLNULL NUMBER Number of records that were completely null and were therefore not loaded
LEFT2SKIP NUMBER Number of records yet to skip during a continued load
The following locks are obtained by user applications. Any process that is blocking others is likely to be holding one of these locks.

User Lock Type Description
TM DML enqueue lock
TX Transaction enqueue lock
UL User supplied lock
Table 3 - 3. User Lock Types

The following system locks are held for extremely short periods of time:

System Lock Type Description
BL Buffer hash table instance lock
CF Control file schema global enqueue lock
CI Cross-instance function invocation instance lock
CU Cursor bind lock
DF Data file instance lock
DL direct loader parallel index create lock
DM Mount/startup db primary/secondary instance lock
DR Distributed recovery process lock
DX Distributed transaction entry lock
FS File set lock
IN Instance number lock
IR Instance recovery serialization global enqueue lock
IS Instance state lock
IV Library cache invalidation instance lock
JQ Job queue lock
KK Thread kick lock
LA..LP Library cache lock instance lock (A..P=namespace)
MM Mount definition global enqueue lock
MR Media recovery lock
NA..NZ Library cache pin instance lock (A..Z=namespace)
PF Password File lock
PI, PS Parallel operation locks
PR Process startup lock
QA..QZ Row cache instance lock (A..Z=cache)
RT Redo thread global enqueue lock
SC System commit number instance lock
SM SMON lock
SN Sequence number instance lock
SQ Sequence number enqueue lock
SS Sort segment locks
ST Space transaction enqueue lock
SV Sequence number value lock
TA Generic enqueue lock
TS Temporary segment enqueue lock (ID2=0)
TS New block allocation enqueue lock (ID2=1)
TT Temporary table enqueue lock
UN User name lock
US Undo segment DDL lock
WL Being-written redo log instance lock
Table 3 - 4. (continued) System Lock Types

V$LOCK

This view lists the locks currently held by the Oracle7 Server and outstanding requests for a lock or latch.

This Column Datatype Represents This
ADDR RAW(4) Address of lock state object
KADDR RAW(4) Address of lock
SID NUMBER Identifier for session holding or acquiring the lock
TYPE VARCHAR2(2) Type of lock: MR, Media Recovery RT, Redo Thread UN, User Name TX, Transaction TM, DML UL, PL/SQL User Lock DX, Distributed Xaction CF, Control File IS, Instance State FS, File Set IR, Instance Recovery ST, Disk Space Transaction TS, Temp Segment IV, Library Cache Invalidation LS, Log Start or Switch RW, Row Wait SQ, Sequence Number TE, Extend Table TT, Temp Table
ID1 NUMBER Lock identifier #1 (depends on type)
ID2 NUMBER Lock identifier #2 (depends on type)
LMODE NUMBER Mode the lock is currently held in by the session: 0, None 1, Null 2, Row-S (SS) 3, Row-X (SX) 4, Share 5, S/Row-X (SSX) 6, Exclusive
REQUEST NUMBER Mode the lock is being requested in by the process: 0, None 1, Null 2, Row-S (SS) 3, Row-X (SX) 4, Share 5, S/Row-X (SSX) 6, Exclusive
CTIME NUMBER Time since current mode was granted
BLOCK NUMBER The lock is blocking another lock

V$LOCK_ACTIVITY

This is a Parallel Server view.

V$LOCK_ACTIVITY shows the DLM lock operation activity of the current instance. Each row corresponds to a type of lock operation.

This Column Datatype Represents This
FROM_VAL VARCHAR2(4) PCM lock initial state: NULL S X SSX
TO_VAL VARCHAR2(4) PCM lock initial state: NULL S X SSX
ACTION_VAL VARCHAR2(51) Description of lock conversions Lock buffers for read Lock buffers for write Make buffers CR (no write) Upgrade read lock to write Make buffers CR (write dirty buffers) Downgrade write lock to read (write dirty buffers) Write transaction table/undo blocks Transaction table/undo blocks (write dirty buffers) Make transaction table/undo blocks available share Rearm transaction table write mechanism
COUNTER NUMBER
For more information, see Oracle7 Parallel Server Concepts & Administration.

V$LOCK_ELEMENT

This is a Parallel Server view.

This Column Datatype Represents This
LOCK_ELEMENT_ ADDR RAW(4) The address of the lock element that contains the PCM lock that is covering the buffer. If more than one buffer has the same address, then these buffers are covered by the same PCM lock.
INDX NUMBER Platform specific lock manager identifier
CLASS NUMBER Platform specific lock manager identifier
MODE_HELD NUMBER Platform dependent value for lock mode held; often: 3 = share 5 = exclusive
BLOCK_COUNT NUMBER Number of blocks covered by PCM lock
RELEASING NUMBER Non-zero if PCM lock is being downgraded
ACQUIRING NUMBER Non-zero if PCM lock is being upgraded
INVALID NUMBER Non-zero if PCK lock is invalid. (A lock may become invalid after a system failure.)
For more information, see the Oracle7 Parallel Server Concepts & Administration manual.

V$LOCKED_OBJECT

This view lists all locks acquired by every transaction on the system.

This Column Datatype Represents This
XIDUSN NUMBER Undo segment number
XIDSLOT NUMBER Slot number
XIDSQN NUMBER Sequence number
OBJECT_ID NUMBER Object ID being locked
SESSION_ID NUMBER Session ID
ORACLE_USERNAME VARCHAR2(30) Oracle user name
OS_USER_NAME VARCHAR2(15) OS user name
PROCESS VARCHAR2(9) OS process ID
LOCKED_MODE NUMBER Lock mode

V$LOCKS_WITH_COLLISIONS

This is a Parallel Server view.

This Column Datatype Represents This
LOCK_ELEMENT_ ADDR RAW(4) The address of the lock element that contains the PCM lock covering the buffer. If more than one buffer has the same address, then these buffers are covered by the same PCM lock.
For more information, see Oracle7 Parallel Server Concepts & Administration.

V$LOG

This view contains log file information from the control files.

This Column Datatype Represents This
GROUP# NUMBER Log group number
THREAD# NUMBER Log thread number
SEQUENCE# NUMBER Log sequence number
BYTES NUMBER Size of the log in bytes
MEMBERS NUMBER Number of members in the log group
ARCHIVED VARCHAR2 Archive status: TRUE, FALSE
STATUS VARCHAR2(16) Log status. The STATUS column can have the values in the following table.
FIRST_CHANGE# NUMBER Lowest SCN in the log
FIRST_TIME VARCHAR2 Time of first SCN in the log

The following table defines values in the log STATUS column.

STATUS Meaning
UNUSED Indicates the online redo log has never been written to. This is the state of a redo log that was just added, or just after a RESETLOGS, when it is not the current redo log.
CURRENT Indicates this is the current redo log. This implies that the redo log is active. The redo log could be open or closed.
ACTIVE Indicates the log is active but is not the current log. It is needed for crash recovery. It may be in use for block recovery. It might or might not be archived.
CLEARING Indicates the log is being recreated as an empty log after an ALTER DATABASE CLEAR LOGFILE command. After the log is cleared, the status changes to UNUSED.
CLEARING_ CURRENT Indicates that the current log is being cleared of a closed thread. The log can stay in this status if there is some failure in the switch such as an I/O error writing the new log header.
INACTIVE Indicates the log is no longer needed for instance recovery. It may be in use for media recovery. It might or might not have already been archived.
Table 3 - 5. Log Status Meaning

V$LOGFILE

This view contains information about redo log files.

This Column Datatype Represents This
GROUP# NUMBER Redo log group identifier number
STATUS VARCHAR2 Status of this log member: INVALID (file is inaccessible), STALE (file's contents are incomplete), DELETED (file is no longer used), or blank (file is in use)
MEMBER VARCHAR2 Redo log member name

V$LOGHIST

This view contains log history information from the control file. This view is retained for historical compatibility. Use of V$LOG_HISTORY is recommended instead.

This Column Datatype Represents This
THREAD# NUMBER Log thread number
SEQUENCE# NUMBER Log sequence number
FIRST_CHANGE# NUMBER Lowest SCN in the log
FIRST_TIME VARCHAR2 Time of first SCN in the log
SWITCH_CHANGE# NUMBER SCN at which the log switch occurred; one more than highest SCN in the log

V$LOG_HISTORY

This view lists the archived log names for all logs in the log history.

This Column Datatype Represents This
THREAD# NUMBER Thread number of the archived log
SEQUENCE# NUMBER Sequence number of the archived log
TIME VARCHAR2 Time of first entry (lowest SCN) in the log
LOW_CHANGE# NUMBER Lowest SCN in the log
HIGH_CHANGE# NUMBER Highest SCN in the log
ARCHIVE_NAME VARCHAR2 Name of archive file, using the naming convention specified by the current values of the LOG_ARCHIVE_FORMAT and LOG_ARCHIVE_DEST initialization parameters. Note that the value of this column indicates the path based on the current values of these initialization parameters, therefore archive logs that were created with other settings of these initialization parameters may indicate the wrong path.

V$MLS_PARAMETERS

This is a Trusted Oracle7 Server view that lists Trusted Oracle7 Server-specific initialization parameters.

For more information, see the Trusted Oracle7 Server Administrator's Guide.

V$MTS

This view contains information for tuning the multi-threaded server.

This Column Datatype Represents This
MAXIMUM_ CONNECTIONS NUMBER The maximum number of connections each dispatcher can support. This value is determined at startup time using SQL*Net constants and other port-specific information.
SERVERS_STARTED NUMBER The total number of multi-threaded servers started since the instance started (but not including those started during startup)
SERVERS_ TERMINATED NUMBER The total number of multi-threaded servers stopped by Oracle since the instance started
SERVERS_ HIGHWATER NUMBER The highest number of servers running at one time since the instance started. If this value reaches the value set for the MTS_MAX_SERVERS initialization parameter, consider raising the value of MTS_MAX_ SERVERS.

V$MYSTAT

This view contains statistics on the current session.

This Column Datatype Represents This
SID NUMBER The id of the current session
STATISTIC# NUMBER The number of the statistic
VALUE NUMBER The value of the statistic

V$NLS_PARAMETERS

This view contains current values of NLS parameters.

This Column Datatype Represents This
PARAMETER VARCHAR2 Parameter name: NLS_LANGUAGE NLS_SORT NLS_TERRITORY NLS_CHARACTERSET NLS_CURRENCY NLS_ISO_CURRENCY NLS_NUMERIC_CHARACTERS NLS_DATE_FORMAT NLS_DATE_LANGUAGE
VALUE VARCHAR2 NLS parameter value

V$NLS_VALID_VALUES

This view lists all valid values for NLS parameters.

This Column Datatype Represents This
PARAMETER VARCHAR2(64) NLS_* parameter: LANGUAGE SORT TERRITORY CHARACTERSET
VALUE VARCHAR2(64) NLS_* parameter value

V$OBJECT_DEPENDENCY

This view can be used to determine what objects are depended on by a package, procedure, or cursor that is currently loaded in the shared pool. For example, together with V$SESSION and V$SQL, it can be used to determine which tables are used in the SQL statement that a user is currently executing.

This Column Datatype Represents This
FROM_ADDRESS RAW(4) The address of a procedure, package, or cursor that is currently loaded in the shared pool
FROM_HASH NUMBER The hash value of a procedure, package, or cursor that is currently loaded in the shared pool
TO_OWNER VARCHAR2(64) The owner of the object that is depended on
TO_NAME VARCHAR2 (1000) The name of the object that is depended on
TO_ADDRESS RAW(4) The address of the object that is depended on. These can be used to look up more information on the object in V$DB_OBJECT_CACHE.
TO_HASH NUMBER The hash value of the object that is depended on. These can be used to look up more information on the object in V$DB_OBJECT_CACHE.
TO_TYPE NUMBER The type of the object that is depended on

V$OPEN_CURSOR

This view lists cursors that each user session currently has opened and parsed.

This Column Datatype Represents This
SADDR RAW Session address
SID NUMBER Session identifier
USER_NAME VARCHAR2 User that is logged in to the session
ADDRESS RAW Used with HASH_VALUE to identify uniquely the SQL statement being executed in the session
HASH_VALUE NUMBER Used with ADDRESS to identify uniquely the SQL statement being executed in the session
SQL_TEXT VARCHAR2 First 60 characters of the SQL statement that is parsed into the open cursor

V$OPTION

This view lists options that are installed with the Oracle7 Server.

This Column Datatype Represents This
PARAMETER VARCHAR2(64) The name of the option
VALUE VARCHAR2(64) TRUE if the option is installed

V$PARAMETER

This view lists information about initialization parameters.

This Column Datatype Represents This
NUM NUMBER Parameter number
NAME VARCHAR2(64) Parameter name
TYPE NUMBER Parameter type
VALUE VARCHAR2(512) Parameter value
ISDEFAULT VARCHAR2(9) Whether parameter is default

V$PING

This is a Parallel Server view.

The V$PING view is identical to the V$CACHE view but only shows blocks that have been pinged at least once. This view contains information from the block header of each block in the SGA of the current instance as related to particular database objects.

This Column Datatype Represents This
FILE# NUMBER Datafile identifier number (to find filename, query DBA_DATA_FILES or V$DBFILES)
BLOCK# NUMBER Block number
STATUS VARCHAR2(1) Status of block: FREE= not currently in use XCUR=exclusive SCUR=shared current CR=consistent read READ=being read from disk MREC=in media recovery mode IREC=in instance recovery mode
XNC NUMBER Number of PCM lock conversions due to contention with another instance
LOCK_ELEMENT_ ADDR RAW(4) The address of the lock element that contains the PCM lock that is covering the buffer. If more than one buffer has the same address, then these buffers are covered by the same PCM lock.
NAME VARCHAR2(30) Name of the database object containing the block
KIND VARCHAR2(12) Type of database object: TABLE CLUSTER INDEX UNDO = rollback segment
OWNER# NUMBER Owner number
For more information, see the Oracle7 Parallel Server Concepts & Administration manual.

V$PQ_SESSTAT

This view lists session statistics for parallel queries.

This Column Datatype Represents This
STATISTIC VARCHAR2(30) Name of the statistic
LAST_QUERY NUMBER The value of the statistic for the last query
SESSION_TOTAL NUMBER The value of the statistic for the entire session to this point in time

V$PQ_SLAVE

This view lists statistics for each of the active parallel query servers on an instance.

This Column Datatype Represents This
SLAVE_NAME VARCHAR2(4) Name of the parallel query server
STATUS VARCHAR2(4) The current status of the parallel query server (BUSY or IDLE)
SESSIONS NUMBER The number of sessions that have used this parallel query server
IDLE_TIME_CUR NUMBER The amount of time spent idle while processing statements in the current session
BUSY_TIME_CUR NUMBER The amount of time spent busy while processing statements in the current session
CPU_SECS_CUR NUMBER The amount of CPU time spent on the current session
MSGS_SENT_CUR NUMBER The number of messages sent while processing statements for the current session
MSGS_RCVD_CUR NUMBER The number of messages received while processing statements for the current session
IDLE_TIME_TOTAL NUMBER The total amount of time this query server has been idle
BUSY_TIME_TOTAL NUMBER The total amount of time this query server has been active
CPU_SECS_TOTAL NUMBER The total amount of CPU time this query server has used to process statements
MSGS_SENT_TOTAL NUMBER The total number of messages this query server has sent
MSGS_RCVD_TOTAL NUMBER The total number of messages this query server has received

V$PQ_SYSSTAT

This view lists system statistics for parallel queries.

This Column Datatype Represents This
STATISTIC VARCHAR2(30) Name of the statistic
VALUE NUMBER The value of the statistic

V$PQ_TQSTAT

This view contains statistics on parallel query operations. The statistics are compiled after the query completes and only remain for the duration of the session. It shows the number of rows processed through each parallel query server at each stage of the execution tree. This view can help determine skew problems in a query's execution.

This Column Datatype Represents This
DFO_NUMBER NUMBER The data flow operator (DFO) tree number to differentiate queries
TQ_ID NUMBER The table queue ID within the query, which represents the connection between two DFO nodes in the query execution tree
SERVER_TYPE VARCHAR2(10) The role in table queue - producer/consumer/ranger
NUM_ROWS NUMBER The number of rows produced/consumed
BYTES NUMBER The number of bytes produced/consumed
OPEN_TIME NUMBER Time (secs) the table queue remained open
AVG_LATENCY NUMBER Time (ms) for a message to be dequeued after it enters the queue
WAITS NUMBER The number of waits encountered when dequeueing
TIMEOUTS NUMBER The number of timeouts when waiting for a message
PROCESS VARCHAR2(10) Process ID
INSTANCE NUMBER Instance ID

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.

This Column Datatype Represents This
ADDR RAW(4) Address of process state object
PID NUMBER Oracle process identifier
SPID VARCHAR2 Operating system process identifier
USERNAME VARCHAR2 Operating system process username. Any Two-Task user coming across the network has "-T" appended to the username.
SERIAL# NUMBER Process serial number
TERMINAL VARCHAR2 Operating system terminal identifier
PROGRAM VARCHAR2 Program in progress
BACKGROUND VARCHAR2 1 for a background process; null for a normal process
LATCHWAIT VARCHAR2 Address of latch the process is waiting for; null if none
LATCHSPIN VARCHAR2 Address of latch the process is being spun on; null if none

V$PWFILE_USERS

This view lists users who have been granted SYSDBA and SYSOPER privileges as derived from the password file.

This Column Datatype Represents This
USERNAME VARCHAR2(30) The name of the user that is contained in the password file.
SYSDBA VARCHAR2(5) If the value of this column is TRUE, the user can connect with SYSDBA privileges.
SYSOPER VARCHAR2(5) If the value of this column is TRUE, the user can connect with SYSOPER privileges

V$QUEUE

This view contains information on the multi-thread message queues.

This Column Datatype Represents This
PADDR RAW(4) Address of the process that owns the queue
TYPE VARCHAR2 Type of queue: COMMON (processed by servers), OUTBOUND (used by remote servers), DISPATCHER.
QUEUED NUMBER Number of items in the queue
WAIT NUMBER Total time that all items in this queue have waited. Divide by TOTALQ for average wait per item.
TOTALQ NUMBER Total number of items that have ever been in the queue

V$RECOVERY_LOG

This view lists information about archived logs that are needed to complete media recovery. This information is derived from the log history view, V$LOG_HISTORY.

This Column Datatype Represents This
THREAD# NUMBER Thread number of the archived log
SEQUENCE# NUMBER Sequence number of the archived log
TIME VARCHAR2 Time of first entry (lowest SCN) in the log
ARCHIVE_NAME VARCHAR2 Name of file when archived, using the naming convention specified by the LOG_ARCHIVE_FORMAT initialization parameter

V$RECOVER_FILE

This view shows the status of files needing media recovery.

This Column Datatype Represents This
FILE# NUMBER File identifier number
ONLINE VARCHAR2 Online status: ONLINE, OFFLINE
ERROR VARCHAR2 Why the file needs to be recovered: NULL if reason unknown, or OFFLINE NORMAL if recovery not needed
CHANGE# NUMBER SCN where recovery must start
TIME VARCHAR2 Time of SCN where recovery must start

V$RECOVERY_FILE_STATUS

This view contains one row for each datafile for each RECOVER command.

This Column Datatype Represents This
FILENUM NUMBER The number of the file being recovered
FILENAME VARCHAR2(257) The filename of the datafile being recovered
STATUS VARCHAR2(13) The status of the recovery. Contains one of the following values: · IN RECOVERY · CURRENT · NOT RECOVERED

V$RECOVERY_STATUS

This view contains statistics of the current recovery process.

This Column Datatype Represents This
RECOVERY_CHECKPOINT VARCHAR2(20) The point in time to which the recovery has occurred. If no logs have been applied, this is the point in time the recovery starts.
THREAD NUMBER The number of the redo thread currently being processed.
SEQUENCE_NEEDED NUMBER Log sequence number of the log needed by the recovery process. The value is 0 if no log is needed.
SCN_NEEDED VARCHAR2(16) The low SCN of the log needed by recovery. The value is 0 if unknown or no log is needed.
TIME_NEEDED VARCHAR2(20) Time when the log was created. The value is midnight on 1/1/88 if the time is unknown or if no log is needed.
PREVIOUS_LOG_NAME VARCHAR2(257) The filename of the log.
PREVIOUS_LOG_STATUS VARCHAR2(13) The status of the previous log. Contains one of the following values: w RELEASE · WRONG NAME · MISSING NAME · UNNEEDED NAME · NONE
REASON VARCHAR2(13) The reason recovery is returning control to the user. Contains one of the following values: w NEED LOG · LOG REUSED · THREAD DISABLED

V$REQDIST

This view lists statistics for the histogram of MTS dispatcher request times, divided into 12 buckets, or ranges of time. The time ranges grow exponentially as a function of the bucket number.

This Column Datatype Represents This
BUCKET NUMBER Bucket number: 0..11; the maximum time for each bucket is (4 * 2^N)/100 seconds
COUNT NUMBER Count of requests whose total time to complete (excluding wait time) falls in this range

V$RESOURCE

This view contains information about resources.

This Column Datatype Represents This
ADDR RAW(4) Address of resource object
TYPE VARCHAR2 Resource type
ID1 NUMBER Resource identifier #1
ID2 NUMBER Resource identifier #2

V$ROLLNAME

This view lists the names of all online rollback segments. This view can only be accessed when the database is open.

This Column Datatype Represents This
USN NUMBER Rollback (undo) segment number
NAME VARCHAR2 Rollback segment name

V$ROLLSTAT

This view contains rollback segment statistics.

This Column Datatype Represents This
USN NUMBER Rollback segment number
EXTENTS NUMBER Number of rollback extents
RSSIZE NUMBER Size in bytes of rollback segment
WRITES NUMBER Number of bytes written to rollback segment
XACTS NUMBER Number of active transactions
GETS NUMBER Number of header gets
WAITS NUMBER Number of header waits
OPTSIZE NUMBER Optimal size of rollback segment
HWMSIZE NUMBER High water mark of rollback segment size
SHRINKS NUMBER Number of times the size of a rollback segment decreases
WRAPS NUMBER Number of times rollback segment is wrapped
EXTENDS NUMBER Number of times rollback segment size is extended
AVESHRINK NUMBER Average shrink size
AVEACTIVE NUMBER Current size of active extents, averaged over time.
STATUS VARCHAR2(15) Rollback segment status
CUREXT NUMBER Current extent
CURBLK NUMBER Current block

V$ROWCACHE

This view shows statistics for data dictionary activity Each row contains statistics for one data dictionary cache.

This Column Datatype Represents This
CACHE# NUMBER Row cache ID number
TYPE VARCHAR2 Parent or subordinate row cache type
SUBORDINATE# NUMBER Subordinate set number
PARAMETER VARCHAR2 Name of the initialization parameter that determines the number of entries in the data dictionary cache
COUNT NUMBER Total number of entries in the cache
USAGE NUMBER Number of cache entries that contain valid data
FIXED NUMBER Number of fixed entries in the cache
GETS NUMBER Total number of requests for information on the data object
GETMISSES NUMBER Number of data requests resulting in cache misses
SCANS NUMBER Number of scan requests
SCANMISSES NUMBER Number of times a scan failed to find the data in the cache
SCANCOMPLETES NUMBER For a list of subordinate entries, the number of times the list was scanned completely
MODIFICATIONS NUMBER Number of inserts, updates, and deletions
FLUSHES NUMBER Number of times flushed to disk

V$SECONDARY

This is a Trusted Oracle7 Server view that lists secondary mounted databases.

For more information, see the Trusted Oracle7 Server Administrator's Guide.

V$SESSION

This view lists session information for each current session.

This Column Datatype Represents This
SADDR RAW(4) Session address
SID NUMBER Session identifier
SERIAL# NUMBER Session serial number. Used to identify uniquely a session's objects. Guarantees that session-level commands are applied to the correct session objects if the session ends and another session begins with the same session ID.
AUDSID NUMBER Auditing session ID
PADDR RAW(4) Address of the process that owns this session
USER# NUMBER Oracle user identifier
USERNAME VARCHAR2 Oracle username
COMMAND NUMBER Command in progress (last statement parsed); for a list of values, see Table 3 - 6
TADDR VARCHAR2 Address of transaction state object
LOCKWAIT VARCHAR2 Address of lock waiting for; null if none
STATUS VARCHAR2 Status of the session: ACTIVE (currently executing SQL), INACTIVE, KILLED (marked to be killed), CACHED (temporarily cached for use by Oracle*XA)
SERVER VARCHAR2 Server type: DEDICATED, SHARED, PSEUDO, NONE
SCHEMA# NUMBER Schema user identifier
SCHEMANAME VARCHAR2 Schema user name
OSUSER VARCHAR2 Operating system client user name
PROCESS VARCHAR2 Operating system client process ID
MACHINE VARCHAR2 Operating system machine name
TERMINAL VARCHAR2 Operating system terminal name
PROGRAM VARCHAR2 Operating system program name
TYPE VARCHAR2 Session type
SQL_ADDRESS RAW(4) Used with SQL_HASH_VALUE to identify the SQL statement that is currently being executed
SQL_HASH_VALUE NUMBER Used with SQL_ADDRESS to identify the SQL statement that is currently being executed
MODULE VARCHAR2(48) Contains the name of the currently executing module as set by calling the DBMS_APPLICATION_ INFO.SET_MODULE procedure.
MODULE_HASH NUMBER The hash value of the above module_name
ACTION VARCHAR2(32) Contains the name of the currently executing action as set by calling the dbms_application_info.set_action procedure.
ACTION_HASH NUMBER The hash value of the above action name
CLIENT_INFO VARCHAR2(64) Information set by the DBMS_ APPLICATION_INFO.SET_ CLIENT_INFO procedure.
FIXED_TABLE_ SEQUENCE NUMBER This contains a number that increases every time the session completes a call to the database and there has been an intervening select from a dynamic performance table. This column can be used by performance monitors that wish to monitor statistics in the database. Each time the performance monitor looks at the database, it only needs to look at sessions that are currently active or have a higher value in this column then the highest value that the performance monitor saw the last time. All the other sessions have been idle since the last time the performance monitor looked at the database.
ROW_WAIT_OBJ# NUMBER Object id for the table containing the rowid specified in ROW_WAIT_ROW#
ROW_WAIT_FILE# NUMBER Identifier for the datafile containing the rowid specified in ROW_WAIT_ROW#. This column is valid only if the session is currently waiting for another transaction to commit and the value of ROW_WAIT_OBJ# is non-zero.
ROW_WAIT_BLOCK# NUMBER Identifier for the block containing the rowid specified in ROW_WAIT_ROW#. This column is valid only if the session is currently waiting for another transaction to commit and the value of ROW_WAIT_OBJ# is non-zero.
ROW_WAIT_ROW# NUMBER The current rowid being locked. This column is valid only if the session is currently waiting for another transaction to commit and the value of ROW_WAIT_OBJ# is non-zero.
Table 3 - 6 lists numeric values corresponding to commands that may be in progress during a session. These values may appear in the V$SESSION COMMAND column. They also appear in the data dictionary view SYS.AUDIT_ACTIONS.

Command Number Command
0 No command in progress. Occurs when process is in a transitory state, usually when terminating.
1 CREATE TABLE
2 INSERT
3 SELECT
4 CREATE CLUSTER
5 ALTER CLUSTER
6 UPDATE
7 DELETE
8 DROP CLUSTER
9 CREATE INDEX
10 DROP INDEX
11 ALTER INDEX
12 DROP TABLE
13 CREATE SEQUENCE
14 ALTER SEQUENCE
15 ALTER TABLE
16 DROP SEQUENCE
17 GRANT
18 REVOKE
19 CREATE SYNONYM
20 DROP SYNONYM
21 CREATE VIEW
22 DROP VIEW
23 VALIDATE INDEX
24 CREATE PROCEDURE
25 ALTER PROCEDURE
26 LOCK TABLE
27 NO OPERATION
28 RENAME
29 COMMENT
30 AUDIT
31 NOAUDIT
32 CREATE DATABASE LINK
33 DROP DATABASE LINK
34 CREATE DATABASE
35 ALTER DATABASE
36 CREATE ROLLBACK SEGMENT
37 ALTER ROLLBACK SEGMENT
38 DROP ROLLBACK SEGMENT
39 CREATE TABLESPACE
40 ALTER TABLESPACE
41 DROP TABLESPACE
42 ALTER SESSION
43 ALTER USER
44 COMMIT
45 ROLLBACK
46 SAVEPOINT
47 PL/SQL EXECUTE
48 SET TRANSACTION
49 ALTER SYSTEM SWITCH LOG
50 EXPLAIN
51 CREATE USER
52 CREATE ROLE
53 DROP USER
54 DROP ROLE
55 SET ROLE
56 CREATE SCHEMA
57 CREATE CONTROL FILE
58 ALTER TRACING
59 CREATE TRIGGER
60 ALTER TRIGGER
61 DROP TRIGGER
62 ANALYZE TABLE
63 ANALYZE INDEX
64 ANALYZE CLUSTER
65 CREATE PROFILE
67 DROP PROFILE
68 ALTER PROFILE
69 DROP PROCEDURE
70 ALTER RESOURCE COST
71 CREATE SNAPSHOT LOG
72 ALTER SNAPSHOT LOG
73 DROP SNAPSHOT LOG
74 CREATE SNAPSHOT
75 ALTER SNAPSHOT
76 DROP SNAPSHOT
79 ALTER ROLE
85 TRUNCATE TABLE
86 TRUNCATE CLUSTER
88 ALTER VIEW
91 CREATE FUNCTION
92 ALTER FUNCTION
93 DROP FUNCTION
94 CREATE PACKAGE
95 ALTER PACKAGE
96 DROP PACKAGE
97 CREATE PACKAGE BODY
98 ALTER PACKAGE BODY
99 DROP PACKAGE BODY
Table 3 - 6. (continued) Command Number Values

V$SESSION_CONNECT_INFO

This view displays information about network connections for the current session.

This Column Datatype Represents This
SID NUMBER Session identifier (can be used to join this view with V$SESSION)
AUTHENTICATION_ TYPE VARCHAR2(15) How the user was authenticated: OS, PROTOCOL, or NETWORK.
OSUSER VARCHAR2(30) The external username for this database user
NETWORK_ SERVICE_BANNER VARCHAR2(2000) Product banners for each SQL*Net service used for this connection (one row per banner)

V$SESSION_CURSOR_CACHE

This view displays information on cursor usage for the current session.

This Column Datatype Represents This
MAXIMUM NUMBER Maximum number of cursors to cache. Once you hit this number, some cursors will need to be closed to open more
COUNT NUMBER Current number of cursors (in use or not)
OPENED_ONCE NUMBER Number of cursors opened at least once
OPEN NUMBER Current number of open cursors
OPENS NUMBER Cumulative total of cursor opens
HITS NUMBER Cumulative total of cursor open hits
HIT_RATIO NUMBER Ratio of the number of times we found an open cursor divided by the number of times we looked for a cursor

V$SESSION_EVENT

This view lists information on waits for an event by a session.

Note that the TIME_WAITED and AVERAGE_WAIT columns will contain a value of zero on those platforms that do not support a fast timing mechanism. If you are running on one of these platforms and you wish this column to reflect true wait times, you must set TIMED_STATISTICS to TRUE in the parameter file. Please remember that doing this will have a small negative effect on system performance.

This Column Datatype Represents This
SID NUMBER The id of the session
EVENT VARCHAR2(64) The name of the wait event
TOTAL_WAITS NUMBER The total number of waits for this event by this session
TOTAL_TIMEOUTS NUMBER The total number of timeouts for this event by this session
TIME_WAITED NUMBER The total amount of time waited for this event by this session, in hundredths of a second
AVERAGE_WAIT NUMBER The average amount of time waited for this event by this session, in hundredths of a second

V$SESSION_WAIT

This view lists the resources or events for which active sessions are waiting.

The following are tuning considerations:

This Column Datatype Represents This
SID NUMBER Session identifier
SEQ# NUMBER Sequence number that uniquely identifies this wait. Incremented for each wait.
EVENT VARCHAR2 Resource or event for which the session is waiting
P1TEXT VARCHAR2 Description of first additional parameter
P1 NUMBER First additional parameter
P1RAW RAW(4) First additional parameter
P2TEXT VARCHAR2 Description of second parameter
P2 NUMBER Second additional parameter
P2RAW RAW(4) Second additional parameter
P3TEXT VARCHAR2 Description of third parameter
P3 NUMBER Third additional parameter
P3RAW RAW(4) Third additional parameter
WAIT_TIME NUMBER A non-zero value is the session's last wait time. A zero value means the session is currently waiting.
STATE VARCHAR2 Wait state (see following table)

The following table defines values in the V$SESSION_WAIT STATUS column.

STATUS Meaning
WAITING the session is currently waiting
WAITED UNKNOWN TIME duration of last wait is unknown
WAITED SHORT TIME last wait < 1/100th of a second
WAITED KNOWN TIME WAIT_TIME = duration of last wait
Table 3 - 7. Wait State STATUS Values

V$SESSTAT

This view lists user session statistics.

This Column Datatype Represents This
SID NUMBER Session identifier
STATISTIC# NUMBER Statistic number (identifier)
VALUE NUMBER Statistic value

V$SESS_IO

This view lists I/O statistics for each user session.

This Column Datatype Represents This
SID NUMBER Session identifier
BLOCK_GETS NUMBER Block gets for this session
CONSISTENT_GETS NUMBER Consistent gets for this session
PHYSICAL_READS NUMBER Physical reads for this session
BLOCK_CHANGES NUMBER Block changes for this session
CONSISTENT_ CHANGES NUMBER Consistent changes for this session

V$SGA

This view contains summary information on the System Global Area.

This Column Datatype Represents This
NAME VARCHAR2 SGA component group
VALUE NUMBER Memory size in bytes

V$SGASTAT

This view contains detailed information on the System Global Area.

This Column Datatype Represents This
NAME VARCHAR2 SGA component name
BYTES NUMBER Memory size in bytes

V$SHARED_POOL_RESERVED

This fixed view lists statistics that help you tune the reserved pool and space within the shared pool.

The following columns of V$SHARED_POOL_RESERVED are only valid if the initialization parameter SHARED_POOL_RESERVED_SIZE is set to a valid value.

This Column Datatype Represents This
FREE_SPACE NUMBER Total amount of free space on the reserved list
AVG_FREE_SIZE NUMBER Average size of the free memory on the reserved list
FREE_COUNT NUMBER Number of free pieces of memory on the reserved list
MAX_FREE_SIZE NUMBER Size of the largest free piece of memory on the reserved list
USED_SPACE NUMBER Total amount of used memory on the reserved list
AVG_USED_SIZE NUMBER Average size of the used memory on the reserved list
USED_COUNT NUMBER Number of used pieces of memory on the reserved list
MAX_USED_SIZE NUMBER Size of the largest used piece of memory on the reserved list
REQUESTS NUMBER Number of times that the reserved list was searched for a free piece of memory
REQUEST_MISSES NUMBER Number of times the reserved list did not have a free piece of memory to satisfy the request, and started flushing objects from the LRU list
LAST_MISS_SIZE NUMBER Request size of the last request miss, when the reserved list did not have a free piece of memory to satisfy the request and started flushing objects from the LRU list
MAX_MISS_SIZE NUMBER Request size of the largest request miss, when the reserved list did not have a free piece of memory to satisfy the request and started flushing objects from the LRU list
The following columns of V$SHARED_POOL_RESERVED contains values which are valid even if SHARED_POOL_RESERVED_SIZE is not set.

This Column Datatype Represents This
REQUEST_FAILURES NUMBER Number of times that no memory was found to satisfy a request (that is, the number of times the error ORA-4031 occurred)
LAST_FAILURE_SIZE NUMBER Request size of the last failed request (that is, the request size for the last ORA-4031 error)
ABORTED_REQUEST _THRESHOLD NUMBER Minimum size of a request which signals an ORA-4031 error without flushing objects
ABORTED_REQUESTS NUMBER Number of requests that signalled an ORA-4031 error without flushing objects
LAST_ABORTED_SIZE NUMBER Last size of the request that returned an ORA-4031 error without flushing objects from the LRU list

V$SHARED_SERVER

This view contains information on the shared server processes.

This Column Datatype Represents This
NAME VARCHAR2 Name of the server
PADDR RAW(4) Server's process address
STATUS VARCHAR2 Server status: EXEC (executing SQL), WAIT (ENQ) (waiting for a lock), WAIT (SEND) (waiting to send data to user), WAIT (COMMON) (idle; waiting for a user request), WAIT (RESET) (waiting for a circuit to reset after a break), QUIT (terminating)
MESSAGES NUMBER Number of messages processed
BYTES NUMBER Total number of bytes in all messages
BREAKS NUMBER Number of breaks
CIRCUIT RAW(4) Address of circuit currently being serviced
IDLE NUMBER Total idle time in hundredths of a second
BUSY NUMBER Total busy time in hundredths of a second
REQUESTS NUMBER Total number of requests taken from the common queue in this server's lifetime

V$SORT_SEGMENT

This view contains information about every sort segment in a given instance.

This Column Datatype Represents This
TABLESPACE_NAME VARCHAR2(31) Name of tablespace
SEGMENT_FILE NUMBER File number of the first extent
SEGMENT_BLOCK NUMBER Block number of the first extent
EXTENT_SIZE NUMBER Extent size
CURRENT_USERS NUMBER Number of active users of the segment
TOTAL_EXTENTS NUMBER Total number of extents in the segment
TOTAL_BLOCKS NUMBER Total number of blocks in the segment
USED_EXTENTS NUMBER Extents allocated to active sorts
USED_BLOCKS NUMBER Blocks allocated to active sorts
FREE_EXTENTS NUMBER Extents not allocated to any sort
FREE_BLOCKS NUMBER Blocks not allocated to any sort
ADDED_EXTENTS NUMBER Number of extent allocations
EXTENT_HITS NUMBER Number of times an unused extent was found in the pool
FREED_EXTENTS NUMBER Number of deallocated extents
FREE_REQUESTS NUMBER Number of requests to deallocate
MAX_SIZE NUMBER Maximum number of extents ever used
MAX_BLOCKS NUMBER Maximum number of blocks ever used
MAX_USED_SIZE NUMBER Maximum number of extents used by all sorts
MAX_USED_BLOCKS NUMBER Maximum number of blocks used by all sorts
MAX_SORT_SIZE NUMBER Maximum number of extents used by an individual sort
MAX_SORT_BLOCKS NUMBER Maximum number of blocks used by an individual sort

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.

This Column Datatype Represents This
SQL_TEXT VARCHAR2(1000) The first eighty characters of the SQL text for the current cursor
SHARABLE_MEM NUMBER The sum of all sharable memory, in bytes, of all the child cursors under this parent
PERSISTENT_MEM NUMBER The sum of all persistent memory, in bytes, of all the child cursors under this parent
RUNTIME_MEM NUMBER The sum of all the ephemeral frame sizes of all the children
SORTS NUMBER The sum of the number of sorts that was done for all the children
LOADED_VERSIONS NUMBER The number of children that are present in the cache AND have their context heap (KGL heap 6) loaded
OPEN_VERSIONS NUMBER The number of child cursors that are currently open under this current this parent
USERS_OPENING NUMBER The number of users that have any of the child cursors open
EXECUTIONS NUMBER The number of executions that took place on this object since it was brought into the library cache
USERS_EXECUTING NUMBER The sum of all users executiong the statement over all children
LOADS NUMBER The number of times the object was loaded or reloaded
FIRST_LOAD_TIME VARCHAR2(19) The time stamp of the parent creation time
INVALIDATIONS NUMBER The sum of invalidations over all the children
PARSE_CALLS NUMBER The sum of all parse calls to all the child cursors under this parent
DISK_READS NUMBER The sum of the number of disk reads over all child cursors
BUFFER_GETS NUMBER The sum of buffer gets over all child cursors
ROWS_PROCESSED NUMBER The total number of rows the parsed SQL statement returns
COMMAND_TYPE NUMBER The Oracle command type definition
OPTIMIZER_MODE VARCHAR2(10) Mode under which the SQL statement is executed
PARSING_USER_ID NUMBER The user ID of the user that has parsed the very first cursor under this parent
PARSING_SCHEMA_ID NUMBER The schema ID that was used to parse this child cursor
KEPT_VERSIONS NUMBER The number of child cursors that have been marked to be kept using the DBMS_SHARED_POOL package
ADDRESS RAW(4) The address of the handle to the parent for this cursor
HASH_VALUE NUMBER The hash value of the parent statement in the library cache
CHILD_NUMBER NUMBER The number of the child of the original SQL text, beginning from 0
MODULE VARCHAR2(64) Contains the name of the module that was executing at the time that the SQL statement was first parsed as set by calling DBMS_APPLICATION_INFO.SET_MODULE
MODULE_HASH NUMBER The hash value of the module that is named in the MODULE column
ACTION VARCHAR2(64) Contains the name of the action that was executing at the time that the SQL statement was first parsed as set by calling DBMS_APPLICATION_INFO.SET_ACTION
ACTION_HASH NUMBER The hash value of the action that is named in the ACTION column
SERIALIZABLE_ ABORTS NUMBER The number of times the transaction fails to serialize, producing ORA-8177 errors, per cursor

V$SQLAREA

This view lists statistics on shared SQL area and contains one row per SQL string. It provides statistics on SQL statements that are in memory, parsed, and ready for execution.

This Column Datatype Represents This
SQL_TEXT VARCHAR2(1000) The first eighty characters of the SQL text for the current cursor
SHARABLE_MEM NUMBER The sum of all sharable memory, in bytes, of all the child cursors under this parent
PERSISTENT_MEM NUMBER The sum of all persistent memory, in bytes, of all the child cursors under this parent
RUNTIME_MEM NUMBER The sum of all the ephemeral frame sizes of all the children
SORTS NUMBER The sum of the number of sorts that was done for all the children
VERSION_COUNT NUMBER The number of children that are present in the cache under this parent
LOADED_VERSIONS NUMBER The number of children that are present in the cache AND have their context heap (KGL heap 6) loaded
OPEN_VERSIONS NUMBER The number of child cursors that are currently open under this current this parent
USERS_OPENING NUMBER The number of users that have any of the child cursors open
EXECUTIONS NUMBER The number of executions that took place on this object since it was brought into the library cache
USERS_EXECUTING NUMBER The sum of all users executiong the statement over all children
LOADS NUMBER The number of times the object was loaded or reloaded
FIRST_LOAD_TIME VARCHAR2(19) The time stamp of the parent creation time
INVALIDATIONS NUMBER The sum of invalidations over all the children
PARSE_CALLS NUMBER The sum of all parse calls to all the child cursors under this parent
DISK_READS NUMBER The sum of the number of disk reads over all child cursors
BUFFER_GETS NUMBER The sum of buffer gets over all child cursors
ROWS_PROCESSED NUMBER The total number of rows the parsed SQL statement returns
COMMAND_TYPE NUMBER The Oracle command type definition
OPTIMIZER_MODE VARCHAR2(10) Mode under which the SQL statement is executed
PARSING_USER_ID NUMBER The user ID of the user that has parsed the very first cursor under this parent
PARSING_SCHEMA_ID NUMBER The schema ID that was used to parse this child cursor
KEPT_VERSIONS NUMBER The number of child cursors that have been marked to be kept using the dbms_shared_pool package
ADDRESS RAW(4) The address of the handle to the parent for this cursor
HASH_VALUE NUMBER The hash value of the parent statement in the library cache
MODULE VARCHAR2(64) Contains the name of the module that was executing at the time that the SQL statement was first parsed as set by calling DBMS_APPLICATION_INFO.SET_MODULE
MODULE_HASH NUMBER The hash value of the module that is named in the MODULE column
ACTION VARCHAR2(64) Contains the name of the action that was executing at the time that the SQL statement was first parsed as set by calling DBMS_APPLICATION_INFO.SET_ACTION
ACTION_HASH NUMBER The hash value of the action that is named in the ACTION column
SERIALIZABLE_ ABORTS NUMBER The number of times the transaction fails to serialize, producing ORA-8177 errors, per cursor

V$SQLTEXT

This view contains the text of SQL statements belonging to shared SQL cursors in the SGA.

This Column Datatype Represents This
ADDRESS RAW Used with HASH_VALUE to identify uniquely a cached cursor
HASH_VALUE NUMBER Used with ADDRESS to identify uniquely a cached cursor
PIECE NUMBER Number used to order the pieces of SQL text
SQL_TEXT VARCHAR2 A column containing one piece of the SQL text
COMMAND_TYPE NUMBER Code for the type of SQL statement (SELECT, INSERT, etc.)

V$SQLTEXT_WITH_NEWLINES

This view is identical to the V$SQLTEXT view except that, to improve legibility, V$SQLTEXT_WITH_NEWLINES does not replace newlines and tabs in the SQL statement with spaces.

This Column Datatype Represents This
ADDRESS RAW Used with HASH_VALUE to identify uniquely a cached cursor
HASH_VALUE NUMBER Used with ADDRESS to identify uniquely a cached cursor
PIECE NUMBER Number used to order the pieces of SQL text
SQL_TEXT VARCHAR2 A column containing one piece of the SQL text
COMMAND_TYPE NUMBER Code for the type of SQL statement (SELECT, INSERT, etc.)

V$STATNAME

Decoded statistic names for the statistics shown in the V$SESSTAT table

This Column Datatype Represents This
STATISTIC# NUMBER Statistic number
NAME VARCHAR2 Statistic name
CLASS NUMBER Statistic class: 1 (User), 2 (Redo), 4 (Enqueue), 8 (Cache), 16 (OS), 32 (Parallel Server), 64 (SQL), 128 (Debug)
Additional Information: On some platforms the CLASS column will also contain operating system-specific statistics. See your operating system-specific Oracle documentation for more information about these statistics.

V$SYSLABEL

This is a Trusted Oracle7 Server view that lists system labels.

For more information, see the Trusted Oracle7 Server Administrator's Guide.

V$SYSSTAT

This view lists system statistics.

This Column Datatype Represents This
STATISTIC# NUMBER Statistic number
NAME VARCHAR2(64) Statistic name
CLASS NUMBER Statistic class: 1 (User), 2 (Redo), 4 (Enqueue), 8 (Cache), 16 (OS), 32 (Parallel Server), 64 (SQL), 128 (Debug)
VALUE NUMBER Statistic value

V$SYSTEM_CURSOR_CACHE

This view displays similar information to the V$SESSION_CURSOR_CACHE view except that this information is system wide.

This Column Datatype Represents This
OPENS NUMBER Cumulative total of cursor opens
HITS NUMBER Cumulative total of cursor open hits
HIT_RATIO NUMBER Ratio of the number of times you found an open cursor divided by the number of times you looked for a cursor

V$SYSTEM_EVENT

This view contains information on total waits for an event.

Note that the TIME_WAITED and AVERAGE_WAIT columns will contain a value of zero on those platforms that do not support a fast timing mechanism. If you are running on one of these platforms and you wish this column to reflect true wait times, you must set TIMED_STATISTICS to TRUE in the parameter file. Please remember that doing this will have a small negative effect on system performance.

This Column Datatype Represents This
EVENT VARCHAR2(64) The name of the wait event
TOTAL_WAITS NUMBER The total number of waits for this event
TOTAL_TIMEOUTS NUMBER The total number of timeouts for this event
TIME_WAITED NUMBER The total amount of time waited for this event, in hundredths of a second
AVERAGE_WAIT NUMBER The average amount of time waited for this event, in hundredths of a second

V$SYSTEM_PARAMETER

This view contains information on system parameters.

V$THREAD

This view contains thread information from the control file.

This Column Datatype Represents This
THREAD# NUMBER Thread number
STATUS VARCHAR2 Thread status: OPEN, CLOSED
ENABLED VARCHAR2 Enabled status: DISABLED, (enabled) PRIVATE, or (enabled) PUBLIC
GROUPS NUMBER Number of log groups assigned to this thread
INSTANCE VARCHAR2 Instance name, if available
OPEN_TIME VARCHAR2 Last time the thread was opened
CURRENT_GROUP# NUMBER Current log group
SEQUENCE# NUMBER Sequence number of current log
CHECKPOINT_ CHANGE# NUMBER SCN at last checkpoint
CHECKPOINT_TIME VARCHAR2 Time of last checkpoint

V$TIMER

This view lists the elapsed time in hundredths of seconds. Time is measured since the beginning of the epoch, which is operating system specific, and wraps around to 0 again whenever the value overflows four bytes (roughly 497 days).

This Column Datatype Represents This
HSECS NUMBER Elapsed time in hundredths of a second

V$TRANSACTION

This view lists the active transactions in the system.

This Column Datatype Represents This
ADDR RAW(4) Address of transaction state object
XIDUSN NUMBER Undo segment number, invalid if inactive
XIDSLOT NUMBER Slot number, invalid if inactive
XIDSQN NUMBER Sequence number, invalid if inactive
UBAFIL NUMBER Undo block address (UBA) filenum, invalid if inactive
UBABLK NUMBER UBA block number, invalid if inactive
UBASQN NUMBER UBA sequence number, invalid if inactive
UBAREC NUMBER UBA record number, invalid if inactive
STATUS VARCHAR2(16) Status
START_TIME VARCHAR2(20) Start time
START_SCNB NUMBER Start system change number (SCN) base
START_SCNW NUMBER Start SCN wrap
START_UEXT NUMBER Start extent number
START_UBAFIL NUMBER Start UBA file number
START_UBABLK NUMBER Start UBA block number
START_UBASQN NUMBER Start UBA sequence number
START_UBAREC NUMBER Start UBA record number
SES_ADDR RAW(4) Session object address
FLAG NUMBER Flag
SPACE VARCHAR2(3) Is a space transaction
RECURSIVE VARCHAR2(3) Is a recursive transaction
NOUNDO VARCHAR2(3) Is a noundo transaction
PRV_XIDUSN NUMBER Parent transaction ID
PRV_XIDSLT NUMBER Parent transaction slot number
PRV_XIDSQN NUMBER Parent transaction sequence number
USED_UBLK NUMBER Undo blocks used
USED_UREC NUMBER Undo record used
LOG_IO NUMBER Logical I/O
PHY_IO NUMBER Physical I/O
CR_GET NUMBER Consistent gets
CR_CHANGE NUMBER Consistent changes

V$TYPE_SIZE

This view lists the sizes of various database components for use in estimating data block capacity.

This Column Datatype Represents This
COMPONENT VARCHAR2 Component name, such as segment or buffer header
TYPE VARCHAR2 Component type
DESCRIPTION VARCHAR2 Description of component
SIZE NUMBER Size of component

V$VERSION

Version numbers of core library components in the Oracle Server. There is one row for each component.

This Column Datatype Represents This
BANNER VARCHAR2 Component name and version number

V$WAITSTAT

This view lists block contention statistics. This table is only updated when timed statistics are enabled.

This Column Datatype Represents This
CLASS VARCHAR2 Class of block subject to contention
COUNT NUMBER Number of waits by this OPERATION for this CLASS of block
TIME NUMBER Sum of all wait times for all the waits by this OPERATION for this CLASS of block


Contents Index Home Previous Next