|
|
|
Oracle 9.2 Dynamic Performance V$ Views
These views are owned by SYS.
V$ACCESS V$ACTIVE_INSTANCES V$ACTIVE_SESS_POOL_MTH V$AQ V$AQ1 V$ARCHIVE V$ARCHIVED_LOG V$ARCHIVE_DEST V$ARCHIVE_DEST_STATUS V$ARCHIVE_GAP V$ARCHIVE_PROCESSES V$AW_CALC V$AW_OLAP V$AW_SESSION_INFO 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_SPFILE V$BACKUP_SYNC_IO V$BGPROCESS V$BH V$BSP V$BUFFER_POOL V$BUFFER_POOL_STATISTICS V$CIRCUIT V$CLASS_CACHE_TRANSFER V$CLASS_PING V$COMPATIBILITY V$COMPATSEG V$CONTEXT V$CONTROLFILE V$CONTROLFILE_RECORD_SECTION V$COPY_CORRUPTION V$CR_BLOCK_SERVER V$DATABASE V$DATABASE_BLOCK_CORRUPTION V$DATABASE_INCARNATION V$DATAFILE V$DATAFILE_COPY V$DATAFILE_HEADER V$DATAGUARD_STATUS V$DBFILE V$DBLINK V$DB_CACHE_ADVICE 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$DLM_TRAFFIC_CONTROLLER V$ENABLEDPRIVS V$ENQUEUE_LOCK V$ENQUEUE_STAT V$EVENT_NAME V$EXECUTION V$FAST_START_SERVERS V$FAST_START_TRANSACTIONS V$FILESTAT V$FILESTATXS V$FILE_CACHE_TRANSFER V$FILE_PING V$FIXED_TABLE V$FIXED_VIEW_DEFINITION V$GCSHVMASTER_INFO V$GCSPFMASTER_INFO V$GC_ELEMENT V$GC_ELEMENTS_W_COLLISIONS V$GES_BLOCKING_ENQUEUE V$GES_ENQUEUE V$GLOBALCONTEXT V$GLOBAL_BLOCKED_LOCKS V$GLOBAL_TRANSACTION V$HS_AGENT V$HS_PARAMETER V$HS_SESSION V$HVMASTER_INFO 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$LIBRARY_CACHE_MEMORY V$LICENSE V$LOADISTAT V$LOADPSTAT 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_CALLBACK V$LOGMNR_CONTENTS V$LOGMNR_DICTIONARY V$LOGMNR_LOGFILE V$LOGMNR_LOGS V$LOGMNR_PARAMETERS V$LOGMNR_PROCESS V$LOGMNR_REGION V$LOGMNR_SESSION V$LOGMNR_STATS V$LOGMNR_TRANSACTION V$LOGSTDBY V$LOGSTDBY_STATS V$LOG_HISTORY V$MANAGED_STANDBY V$MAP_COMP_LIST V$MAP_ELEMENT V$MAP_EXT_ELEMENT V$MAP_FILE V$MAP_FILE_EXTENT V$MAP_FILE_IO_STACK V$MAP_LIBRARY V$MAP_SUBELEMENT V$MAX_ACTIVE_SESS_TARGET_MTH V$MLS_PARAMETERS V$MTS V$MTTR_TARGET_ADVICE V$MVREFRESH V$MYSTAT V$NLS_PARAMETERS V$NLS_VALID_VALUES V$OBJECT_DEPENDENCY V$OBJECT_USAGE V$OBSOLETE_PARAMETER V$OFFLINE_RANGE V$OLAP_ALTER_SESSION V$OPEN_CURSOR V$OPTION V$PARALLEL_DEGREE_LIMIT_MTH V$PARAMETER V$PARAMETER2 V$PGASTAT V$PGA_TARGET_ADVICE V$PGA_TARGET_ADVICE_HISTOGRAM 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$QUEUEING_MTH V$RECOVERY_FILE_STATUS V$RECOVERY_LOG V$RECOVERY_PROGRESS V$RECOVERY_STATUS V$RECOVER_FILE V$REPLPROP V$REPLQUEUE V$REQDIST V$RESERVED_WORDS V$RESOURCE V$RESOURCE_LIMIT V$RESUMABLE V$RMAN_CONFIGURATION 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$SEGMENT_STATISTICS V$SEGSTAT V$SEGSTAT_NAME 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$SGA_CURRENT_RESIZE_OPS V$SGA_DYNAMIC_COMPONENTS V$SGA_DYNAMIC_FREE_MEMORY V$SGA_RESIZE_OPS V$SHARED_POOL_ADVICE V$SHARED_POOL_RESERVED V$SHARED_SERVER V$SHARED_SERVER_MONITOR V$SORT_SEGMENT V$SORT_USAGE V$SPPARAMETER V$SQL V$SQLAREA V$SQLTEXT V$SQLTEXT_WITH_NEWLINES V$SQLXS V$SQL_BIND_DATA V$SQL_BIND_METADATA V$SQL_CURSOR V$SQL_PLAN V$SQL_PLAN_STATISTICS V$SQL_PLAN_STATISTICS_ALL V$SQL_REDIRECTION V$SQL_SHARED_CURSOR V$SQL_SHARED_MEMORY V$SQL_WORKAREA V$SQL_WORKAREA_ACTIVE V$SQL_WORKAREA_HISTOGRAM V$STANDBY_LOG V$STATISTICS_LEVEL V$STATNAME V$STREAMS_APPLY_COORDINATOR V$STREAMS_APPLY_READER V$STREAMS_APPLY_SERVER V$STREAMS_CAPTURE V$SUBCACHE V$SYSSTAT V$SYSTEM_CURSOR_CACHE V$SYSTEM_EVENT V$SYSTEM_PARAMETER V$SYSTEM_PARAMETER2 V$TABLESPACE V$TEMPFILE V$TEMPORARY_LOBS V$TEMPSTAT V$TEMPSTATXS V$TEMP_CACHE_TRANSFER V$TEMP_EXTENT_MAP V$TEMP_EXTENT_POOL V$TEMP_PING V$TEMP_SPACE_HEADER V$THREAD V$TIMER V$TIMEZONE_NAMES V$TRANSACTION V$TRANSACTION_ENQUEUE V$TYPE_SIZE V$UNDOSTAT V$VERSION V$VPD_POLICY V$WAITSTAT
When using
these views you should have timed_statistics set to true in your init.ora
file. This has minimal effect on performance and can be permanently left on
(TIMED_STATISTICS=TRUE)
The V$ views are actually public synonyms for corresponding SYS.V_$ views.
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)
