|
|
|
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$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.
