Oracle Books, Websites etc

Oracle 8 dynamic performance V$ views

V$ views are dynamic performance views based on the X$ tables. When using these views you should have timed_statistics set to true in your init.ora file. GV$ views are dynamic performance views in a parallel server environment. These views are owned by SYS.

V$ACCESS
V$ACTIVE_INSTANCES 
V$AQ 
V$AQ1 
V$ARCHIVE 
V$ARCHIVED_LOG 
V$ARCHIVE_DEST 
V$ARCHIVE_PROCESSES 

V$BACKUP 
V$BACKUP_ASYNC_IO 
V$BACKUP_CORRUPTION 
V$BACKUP_DATAFILE 
V$BACKUP_DEVICE 
V$BACKUP_PIECE 
V$BACKUP_REDOLOG 
V$BACKUP_SET 
V$BACKUP_SYNC_IO 
V$BGPROCESS 
V$BH 
V$BSP 
V$BUFFER_POOL 
V$BUFFER_POOL_STATISTICS 

V$CACHE
V$CIRCUIT 
V$CLASS_PING 
V$COMPATIBILITY 
V$COMPATSEG 
V$CONTEXT 
V$CONTROLFILE 
V$CONTROLFILE_RECORD_SECTION 
V$COPY_CORRUPTION 

V$DATABASE 
V$DATAFILE 
V$DATAFILE_COPY 
V$DATAFILE_HEADER 
V$DBFILE 
V$DBLINK 
V$DB_OBJECT_CACHE 
V$DB_PIPES 
V$DELETED_OBJECT 
V$DISPATCHER 
V$DISPATCHER_RATE 
V$DLM_ALL_LOCKS 
V$DLM_CONVERT_LOCAL 
V$DLM_CONVERT_REMOTE 
V$DLM_LATCH 
V$DLM_LOCKS 
V$DLM_MISC 
V$DLM_RESS 

V$ENABLEDPRIVS 
V$ENQUEUE_LOCK 
V$EVENT_NAME 
V$EXECUTION 

V$FAST_START_SERVERS 
V$FAST_START_TRANSACTIONS 
V$FILESTAT 
V$FILE_PING 
V$FIXED_TABLE 
V$FIXED_VIEW_DEFINITION 

V$GLOBAL_BLOCKED_LOCKS 
V$GLOBAL_TRANSACTION 

V$HS_AGENT 
V$HS_PARAMETER 
V$HS_SESSION 

V$INDEXED_FIXED_COLUMN 
V$INSTANCE 
V$INSTANCE_RECOVERY 

V$KCCDI 
V$KCCFE 

V$LATCH 
V$LATCHHOLDER 
V$LATCHNAME 
V$LATCH_CHILDREN 
V$LATCH_MISSES 
V$LATCH_PARENT 
V$LIBRARYCACHE 
V$LICENSE 
V$LOADCSTAT 
V$LOADISTAT 
V$LOADPSTAT 
V$LOADTSTAT 
V$LOCK 
V$_LOCK
V$LOCKED_OBJECT 
V$LOCKS_WITH_COLLISIONS 
V$LOCK_ACTIVITY 
V$LOCK_ELEMENT 
V$LOG 
V$LOGFILE 
V$LOGHIST 
V$LOGMNR_CONTENTS 
V$LOGMNR_DICTIONARY 
V$LOGMNR_LOGS 
V$LOGMNR_PARAMETERS 
V$LOG_HISTORY 

V$MAX_ACTIVE_SESS_TARGET_MTH 
V$MLS_PARAMETERS 
V$MTS 
V$MYSTAT 

V$NLS_PARAMETERS 
V$NLS_VALID_VALUES 

V$OBJECT_DEPENDENCY 
V$OBSOLETE_PARAMETER 
V$OFFLINE_RANGE 
V$OPEN_CURSOR 
V$OPTION 

V$PARALLEL_DEGREE_LIMIT_MTH 
V$PARAMETER 
V$PARAMETER2 
V$PQ_SESSTAT 
V$PQ_SLAVE 
V$PQ_SYSSTAT 
V$PQ_TQSTAT 
V$PROCESS 
V$PROXY_ARCHIVEDLOG 
V$PROXY_DATAFILE 
V$PWFILE_USERS 
V$PX_PROCESS 
V$PX_PROCESS_SYSSTAT 
V$PX_SESSION 
V$PX_SESSTAT 

V$QUEUE 

V$RECOVERY_FILE_STATUS 
V$RECOVERY_LOG 
V$RECOVERY_PROGRESS 
V$RECOVERY_STATUS 
V$RECOVER_FILE 
V$REQDIST 
V$RESERVED_WORDS 
V$RESOURCE 
V$RESOURCE_LIMIT 
V$ROLLNAME 
V$ROLLSTAT 
V$ROWCACHE 
V$ROWCACHE_PARENT 
V$ROWCACHE_SUBORDINATE 
V$RSRC_CONSUMER_GROUP 
V$RSRC_CONSUMER_GROUP_CPU_MTH
V$RSRC_PLAN 
V$RSRC_PLAN_CPU_MTH 

V$SESSION 
V$SESSION_CONNECT_INFO 
V$SESSION_CURSOR_CACHE 
V$SESSION_EVENT 
V$SESSION_LONGOPS 
V$SESSION_OBJECT_CACHE 
V$SESSION_WAIT 
V$SESSTAT 
V$SESS_IO 
V$SGA 
V$SGASTAT 
V$SHARED_POOL_RESERVED 
V$SHARED_SERVER 
V$SORT_SEGMENT 
V$SORT_USAGE 
V$SQL 
V$SQLAREA 
V$SQLTEXT 
V$SQLTEXT_WITH_NEWLINES 
V$SQL_BIND_DATA 
V$SQL_BIND_METADATA 
V$SQL_CURSOR 
V$SQL_SHARED_MEMORY 
V$STATNAME 
V$SUBCACHE 
V$SYSSTAT 
V$SYSTEM_CURSOR_CACHE 
V$SYSTEM_EVENT 
V$SYSTEM_PARAMETER 
V$SYSTEM_PARAMETER2 

V$TABLESPACE 
V$TARGETRBA 
V$TEMPFILE 
V$TEMPORARY_LOBS 
V$TEMPSTAT 
V$TEMP_EXTENT_MAP 
V$TEMP_EXTENT_POOL 
V$TEMP_PING 
V$TEMP_SPACE_HEADER 
V$THREAD 
V$TIMER 
V$TRANSACTION 
V$TRANSACTION_ENQUEUE 
V$TYPE_SIZE 

V$VERSION 

V$WAITSTAT

There is a GV$ view for every V$ view except for V$ROLLNAME, V$CACHE_LOCK, V$LOCK_ACTIVITY, and V$LOCKS_WITH_COLLISIONS. (also V$KCCDI -? , V$KCCFE- ? .)

The global views have an additional column INST_ID (instance number)

The V$ views are actually public synonyms for corresponding V_$ views.



Back to the Top

Simon Sheppard
SS64.com