Oracle Dynamic Performance V$ Views

See also a dump of the Oracle Data Dictionary

 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 

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_TABLE where 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)
This document was originally based on Oracle 9i.


© Copyright SS64.com 1999-2014
Some rights reserved