V$ Views And GV$ Views
V$ tables G…$ tables Comment
O$SQL_BIND_CAPTURE GO$SQL_BIND_CAPTURE
GV$_RESUMABLE2
GV$RMAN_STATUS_CURRENT
V$ACCESS GV$ACCESS
V$ACTIVE_INSTANCES GV$ACTIVE_INSTANCES
V$ACTIVE_SERVICES GV$ACTIVE_SERVICES
V$ACTIVE_SESSION_HISTORY GV$ACTIVE_SESSION_HISTORY
V$ACTIVE_SESS_POOL_MTH GV$ACTIVE_SESS_POOL_MTH
V$ADVISOR_PROGRESS GV$ADVISOR_PROGRESS
V$ALERT_TYPES GV$ALERT_TYPES
V$AQ1 GV$AQ1
V$ARCHIVE GV$ARCHIVE
V$ARCHIVED_LOG GV$ARCHIVED_LOG
V$ARCHIVE_DEST GV$ARCHIVE_DEST
V$ARCHIVE_DEST_STATUS GV$ARCHIVE_DEST_STATUS
V$ARCHIVE_GAP GV$ARCHIVE_GAP
V$ARCHIVE_PROCESSES GV$ARCHIVE_PROCESSES
V$ASM_ALIAS GV$ASM_ALIAS
V$ASM_CLIENT GV$ASM_CLIENT
V$ASM_DISK GV$ASM_DISK
V$ASM_DISKGROUP GV$ASM_DISKGROUP
V$ASM_DISKGROUP_STAT GV$ASM_DISKGROUP_STAT
V$ASM_DISK_STAT GV$ASM_DISK_STAT
V$ASM_FILE GV$ASM_FILE
V$ASM_OPERATION GV$ASM_OPERATION
V$ASM_TEMPLATE GV$ASM_TEMPLATE
V$AW_AGGREGATE_OP GV$AW_AGGREGATE_OP
V$AW_ALLOCATE_OP GV$AW_ALLOCATE_OP
V$AW_CALC GV$AW_CALC
V$AW_LONGOPS GV$AW_LONGOPS
V$AW_OLAP GV$AW_OLAP
V$AW_SESSION_INFO GV$AW_SESSION_INFO
V$BACKUP GV$BACKUP
V$BACKUP_ARCHIVELOG_DETAILS
V$BACKUP_ARCHIVELOG_SUMMARY
V$BACKUP_ASYNC_IO GV$BACKUP_ASYNC_IO
V$BACKUP_CONTROLFILE_DETAILS
V$BACKUP_CONTROLFILE_SUMMARY
V$BACKUP_COPY_DETAILS
V$BACKUP_COPY_SUMMARY
V$BACKUP_CORRUPTION GV$BACKUP_CORRUPTION
V$BACKUP_DATAFILE GV$BACKUP_DATAFILE
V$BACKUP_DATAFILE_DETAILS
V$BACKUP_DATAFILE_SUMMARY
V$BACKUP_DEVICE GV$BACKUP_DEVICE
V$BACKUP_PIECE GV$BACKUP_PIECE
V$BACKUP_PIECE_DETAILS
V$BACKUP_REDOLOG GV$BACKUP_REDOLOG
V$BACKUP_SET GV$BACKUP_SET
V$BACKUP_SET_DETAILS
V$BACKUP_SET_SUMMARY
V$BACKUP_SPFILE GV$BACKUP_SPFILE
V$BACKUP_SPFILE_DETAILS
V$BACKUP_SPFILE_SUMMARY
V$BACKUP_SYNC_IO GV$BACKUP_SYNC_IO
V$BGPROCESS GV$BGPROCESS
V$BH GV$BH
V$BLOCKING_QUIESCE GV$BLOCKING_QUIESCE
V$BLOCK_CHANGE_TRACKING
V$BSP GV$BSP
V$BUFFERED_PUBLISHERS GV$BUFFERED_PUBLISHERS
V$BUFFERED_QUEUES GV$BUFFERED_QUEUES
V$BUFFERED_SUBSCRIBERS GV$BUFFERED_SUBSCRIBERS
V$BUFFER_POOL GV$BUFFER_POOL
V$BUFFER_POOL_STATISTICS GV$BUFFER_POOL_STATISTICS
V$CIRCUIT GV$CIRCUIT
V$CLASS_CACHE_TRANSFER GV$CLASS_CACHE_TRANSFER
V$CLASS_PING GV$CLASS_PING
V$CLIENT_STATS GV$CLIENT_STATS
V$CLUSTER_INTERCONNECTS GV$CLUSTER_INTERCONNECTS
V$CONFIGURED_INTERCONNECTS GV$CONFIGURED_INTERCONNECTS
V$CONTEXT GV$CONTEXT
V$CONTROLFILE GV$CONTROLFILE
V$CONTROLFILE_RECORD_SECTION GV$CONTROLFILE_RECORD_SECTION
V$COPY_CORRUPTION GV$COPY_CORRUPTION
V$CR_BLOCK_SERVER GV$CR_BLOCK_SERVER
V$CURRENT_BLOCK_SERVER GV$CURRENT_BLOCK_SERVER
V$DATABASE GV$DATABASE
V$DATABASE_BLOCK_CORRUPTION GV$DATABASE_BLOCK_CORRUPTION
V$DATABASE_INCARNATION GV$DATABASE_INCARNATION
V$DATAFILE GV$DATAFILE
V$DATAFILE_COPY GV$DATAFILE_COPY
V$DATAFILE_HEADER GV$DATAFILE_HEADER
V$DATAGUARD_CONFIG GV$DATAGUARD_CONFIG
V$DATAGUARD_STATS
V$DATAGUARD_STATUS GV$DATAGUARD_STATUS
V$DATAPUMP_JOB GV$DATAPUMP_JOB
V$DATAPUMP_SESSION GV$DATAPUMP_SESSION
V$DBFILE GV$DBFILE
V$DBLINK GV$DBLINK
V$DB_CACHE_ADVICE GV$DB_CACHE_ADVICE
V$DB_OBJECT_CACHE GV$DB_OBJECT_CACHE
V$DB_PIPES GV$DB_PIPES
V$DB_TRANSPORTABLE_PLATFORM GV$DB_TRANSPORTABLE_PLATFORM
V$DELETED_OBJECT GV$DELETED_OBJECT
V$DISPATCHER GV$DISPATCHER
V$DISPATCHER_CONFIG GV$DISPATCHER_CONFIG
V$DISPATCHER_RATE GV$DISPATCHER_RATE
V$DLM_ALL_LOCKS GV$DLM_ALL_LOCKS
V$DLM_CONVERT_LOCAL GV$DLM_CONVERT_LOCAL
V$DLM_CONVERT_REMOTE GV$DLM_CONVERT_REMOTE
V$DLM_LATCH GV$DLM_LATCH
V$DLM_LOCKS GV$DLM_LOCKS
V$DLM_MISC GV$DLM_MISC
V$DLM_RESS GV$DLM_RESS
V$DLM_TRAFFIC_CONTROLLER GV$DLM_TRAFFIC_CONTROLLER
V$ENABLEDPRIVS GV$ENABLEDPRIVS
V$ENQUEUE_LOCK GV$ENQUEUE_LOCK
V$ENQUEUE_STAT GV$ENQUEUE_STAT
V$ENQUEUE_STATISTICS GV$ENQUEUE_STATISTICS
V$EVENTMETRIC GV$EVENTMETRIC
V$EVENT_HISTOGRAM GV$EVENT_HISTOGRAM
V$EVENT_NAME GV$EVENT_NAME
V$EXECUTION GV$EXECUTION
V$FAST_START_SERVERS GV$FAST_START_SERVERS
V$FAST_START_TRANSACTIONS GV$FAST_START_TRANSACTIONS
V$FILEMETRIC GV$FILEMETRIC
V$FILEMETRIC_HISTORY GV$FILEMETRIC_HISTORY
V$FILESPACE_USAGE GV$FILESPACE_USAGE
V$FILESTAT GV$FILESTAT
V$FILE_CACHE_TRANSFER GV$FILE_CACHE_TRANSFER
V$FILE_HISTOGRAM GV$FILE_HISTOGRAM
V$FILE_PING GV$FILE_PING
V$FIXED_TABLE GV$FIXED_TABLE
V$FIXED_VIEW_DEFINITION GV$FIXED_VIEW_DEFINITION
V$FLASHBACK_DATABASE_LOG GV$FLASHBACK_DATABASE_LOG
V$FLASHBACK_DATABASE_LOGFILE GV$FLASHBACK_DATABASE_LOGFILE
V$FLASHBACK_DATABASE_STAT GV$FLASHBACK_DATABASE_STAT
V$FLASH_RECOVERY_AREA_USAGE
V$GCSHVMASTER_INFO GV$GCSHVMASTER_INFO
V$GCSPFMASTER_INFO GV$GCSPFMASTER_INFO
V$GC_ELEMENT GV$GC_ELEMENT
V$GC_ELEMENTS_WITH_COLLISIONS GV$GC_ELEMENTS_WITH_COLLISIONS
V$GES_BLOCKING_ENQUEUE GV$GES_BLOCKING_ENQUEUE
V$GES_ENQUEUE GV$GES_ENQUEUE
V$GLOBALCONTEXT GV$GLOBALCONTEXT
V$GLOBAL_BLOCKED_LOCKS GV$GLOBAL_BLOCKED_LOCKS
V$GLOBAL_TRANSACTION GV$GLOBAL_TRANSACTION
V$HS_AGENT GV$HS_AGENT
V$HS_PARAMETER GV$HS_PARAMETER
V$HS_SESSION GV$HS_SESSION
V$HVMASTER_INFO GV$HVMASTER_INFO
V$INDEXED_FIXED_COLUMN GV$INDEXED_FIXED_COLUMN
V$INSTANCE GV$INSTANCE
V$INSTANCE_CACHE_TRANSFER GV$INSTANCE_CACHE_TRANSFER
V$INSTANCE_LOG_GROUP GV$INSTANCE_LOG_GROUP
V$INSTANCE_RECOVERY GV$INSTANCE_RECOVERY
V$JAVAPOOL GV$JAVAPOOL
V$JAVA_LIBRARY_CACHE_MEMORY GV$JAVA_LIBRARY_CACHE_MEMORY
V$JAVA_POOL_ADVICE GV$JAVA_POOL_ADVICE
V$LATCH GV$LATCH
V$LATCHHOLDER GV$LATCHHOLDER
V$LATCHNAME GV$LATCHNAME
V$LATCH_CHILDREN GV$LATCH_CHILDREN
V$LATCH_MISSES GV$LATCH_MISSES
V$LATCH_PARENT GV$LATCH_PARENT
V$LIBRARYCACHE GV$LIBRARYCACHE
V$LIBRARY_CACHE_MEMORY GV$LIBRARY_CACHE_MEMORY
V$LICENSE GV$LICENSE
V$LOADISTAT GV$LOADISTAT
V$LOADPSTAT GV$LOADPSTAT
V$LOCK GV$LOCK
V$LOCKED_OBJECT GV$LOCKED_OBJECT
V$LOCKS_WITH_COLLISIONS GV$LOCKS_WITH_COLLISIONS
V$LOCK_ACTIVITY GV$LOCK_ACTIVITY
V$LOCK_ELEMENT GV$LOCK_ELEMENT
V$LOCK_TYPE GV$LOCK_TYPE
V$LOG GV$LOG
V$LOGFILE GV$LOGFILE
V$LOGHIST GV$LOGHIST
V$LOGMNR_CALLBACK GV$LOGMNR_CALLBACK
V$LOGMNR_CONTENTS GV$LOGMNR_CONTENTS
V$LOGMNR_DICTIONARY GV$LOGMNR_DICTIONARY
V$LOGMNR_DICTIONARY_LOAD GV$LOGMNR_DICTIONARY_LOAD
V$LOGMNR_LATCH GV$LOGMNR_LATCH
V$LOGMNR_LOGFILE GV$LOGMNR_LOGFILE
V$LOGMNR_LOGS GV$LOGMNR_LOGS
V$LOGMNR_PARAMETERS GV$LOGMNR_PARAMETERS
V$LOGMNR_PROCESS GV$LOGMNR_PROCESS
V$LOGMNR_REGION GV$LOGMNR_REGION
V$LOGMNR_SESSION GV$LOGMNR_SESSION
V$LOGMNR_STATS GV$LOGMNR_STATS
V$LOGMNR_TRANSACTION GV$LOGMNR_TRANSACTION
V$LOGSTDBY GV$LOGSTDBY
V$LOGSTDBY_PROCESS GV$LOGSTDBY_PROCESS
V$LOGSTDBY_PROGRESS GV$LOGSTDBY_PROGRESS
V$LOGSTDBY_STATE GV$LOGSTDBY_STATE
V$LOGSTDBY_STATS GV$LOGSTDBY_STATS
V$LOGSTDBY_TRANSACTION GV$LOGSTDBY_TRANSACTION
V$LOG_HISTORY GV$LOG_HISTORY
V$MANAGED_STANDBY GV$MANAGED_STANDBY
V$MAP_COMP_LIST GV$MAP_COMP_LIST
V$MAP_ELEMENT GV$MAP_ELEMENT
V$MAP_EXT_ELEMENT GV$MAP_EXT_ELEMENT
V$MAP_FILE GV$MAP_FILE
V$MAP_FILE_EXTENT GV$MAP_FILE_EXTENT
V$MAP_FILE_IO_STACK GV$MAP_FILE_IO_STACK
V$MAP_LIBRARY GV$MAP_LIBRARY
V$MAP_SUBELEMENT GV$MAP_SUBELEMENT
V$MAX_ACTIVE_SESS_TARGET_MTH GV$MAX_ACTIVE_SESS_TARGET_MTH
V$METRIC GV$METRIC
V$METRICGROUP GV$METRICGROUP
V$METRICNAME GV$METRICNAME
V$METRIC_HISTORY GV$METRIC_HISTORY
V$MTTR_TARGET_ADVICE GV$MTTR_TARGET_ADVICE
V$MUTEX_SLEEP GV$MUTEX_SLEEP
V$MUTEX_SLEEP_HISTORY GV$MUTEX_SLEEP_HISTORY
V$MVREFRESH GV$MVREFRESH
V$MYSTAT GV$MYSTAT
V$NLS_PARAMETERS GV$NLS_PARAMETERS
V$NLS_VALID_VALUES GV$NLS_VALID_VALUES
V$OBJECT_DEPENDENCY GV$OBJECT_DEPENDENCY
V$OBJECT_USAGE DBA_VIEWS
V$OBSOLETE_PARAMETER GV$OBSOLETE_PARAMETER
V$OFFLINE_RANGE GV$OFFLINE_RANGE
V$OPEN_CURSOR GV$OPEN_CURSOR
V$OPTION GV$OPTION
V$OSSTAT GV$OSSTAT
V$PARALLEL_DEGREE_LIMIT_MTH GV$PARALLEL_DEGREE_LIMIT_MTH
V$PARAMETER GV$PARAMETER
V$PARAMETER2 GV$PARAMETER2
V$PARAMETER_VALID_VALUES GV$PARAMETER_VALID_VALUES
V$PGASTAT GV$PGASTAT
V$PGA_TARGET_ADVICE GV$PGA_TARGET_ADVICE
V$PGA_TARGET_ADVICE_HISTOGRAM GV$PGA_TARGET_ADVICE_HISTOGRAM
V$PQ_SESSTAT GV$PQ_SESSTAT
V$PQ_SLAVE GV$PQ_SLAVE
V$PQ_SYSSTAT GV$PQ_SYSSTAT
V$PQ_TQSTAT GV$PQ_TQSTAT
V$PROCESS GV$PROCESS
V$PROCESS_MEMORY GV$PROCESS_MEMORY
V$PROCESS_MEMORY_DETAIL GV$PROCESS_MEMORY_DETAIL
V$PROCESS_MEMORY_DETAIL_PROG GV$PROCESS_MEMORY_DETAIL_PROG
V$PROPAGATION_RECEIVER GV$PROPAGATION_RECEIVER
V$PROPAGATION_SENDER GV$PROPAGATION_SENDER
V$PROXY_ARCHIVEDLOG GV$PROXY_ARCHIVEDLOG
V$PROXY_ARCHIVELOG_DETAILS
V$PROXY_ARCHIVELOG_SUMMARY
V$PROXY_COPY_DETAILS
V$PROXY_COPY_SUMMARY
V$PROXY_DATAFILE GV$PROXY_DATAFILE
V$PWFILE_USERS GV$PWFILE_USERS
V$PX_BUFFER_ADVICE GV$PX_BUFFER_ADVICE
V$PX_PROCESS GV$PX_PROCESS
V$PX_PROCESS_SYSSTAT GV$PX_PROCESS_SYSSTAT
V$PX_SESSION GV$PX_SESSION
V$PX_SESSTAT GV$PX_SESSTAT
V$QUEUE GV$QUEUE
V$QUEUEING_MTH GV$QUEUEING_MTH
V$RECOVERY_FILE_DEST
V$RECOVERY_FILE_STATUS GV$RECOVERY_FILE_STATUS
V$RECOVERY_LOG GV$RECOVERY_LOG
V$RECOVERY_PROGRESS GV$RECOVERY_PROGRESS
V$RECOVERY_STATUS GV$RECOVERY_STATUS
V$RECOVER_FILE GV$RECOVER_FILE
V$REPLPROP GV$REPLPROP
V$REPLQUEUE GV$REPLQUEUE
V$REQDIST GV$REQDIST
V$RESERVED_WORDS GV$RESERVED_WORDS
V$RESOURCE GV$RESOURCE
V$RESOURCE_LIMIT GV$RESOURCE_LIMIT
V$RESTORE_POINT GV$RESTORE_POINT
V$RESUMABLE GV$RESUMABLE
V$RFS_THREAD GV$RFS_THREAD
V$RMAN_BACKUP_JOB_DETAILS
V$RMAN_BACKUP_SUBJOB_DETAILS
V$RMAN_BACKUP_TYPE
V$RMAN_CONFIGURATION GV$RMAN_CONFIGURATION
V$RMAN_ENCRYPTION_ALGORITHMS GV$RMAN_ENCRYPTION_ALGORITHMS
V$RMAN_OUTPUT GV$RMAN_OUTPUT
V$RMAN_STATUS
V$ROLLSTAT GV$ROLLSTAT
V$ROWCACHE GV$ROWCACHE
V$ROWCACHE_PARENT GV$ROWCACHE_PARENT
V$ROWCACHE_SUBORDINATE GV$ROWCACHE_SUBORDINATE
V$RSRC_CONSUMER_GROUP GV$RSRC_CONSUMER_GROUP
V$RSRC_CONSUMER_GROUP_CPU_MTH GV$RSRC_CONSUMER_GROUP_CPU_MTH
V$RSRC_CONS_GROUP_HISTORY GV$RSRC_CONS_GROUP_HISTORY
V$RSRC_PLAN GV$RSRC_PLAN
V$RSRC_PLAN_CPU_MTH GV$RSRC_PLAN_CPU_MTH
V$RSRC_PLAN_HISTORY GV$RSRC_PLAN_HISTORY
V$RSRC_SESSION_INFO GV$RSRC_SESSION_INFO
V$RULE GV$RULE
V$RULE_SET GV$RULE_SET
V$RULE_SET_AGGREGATE_STATS GV$RULE_SET_AGGREGATE_STATS
V$SCHEDULER_RUNNING_JOBS GV$SCHEDULER_RUNNING_JOBS
V$SEGMENT_STATISTICS GV$SEGMENT_STATISTICS
V$SEGSTAT GV$SEGSTAT
V$SEGSTAT_NAME GV$SEGSTAT_NAME
V$SERVICEMETRIC GV$SERVICEMETRIC
V$SERVICEMETRIC_HISTORY GV$SERVICEMETRIC_HISTORY
V$SERVICES GV$SERVICES
V$SERVICE_EVENT GV$SERVICE_EVENT
V$SERVICE_STATS GV$SERVICE_STATS
V$SERVICE_WAIT_CLASS GV$SERVICE_WAIT_CLASS
V$SERV_MOD_ACT_STATS GV$SERV_MOD_ACT_STATS
V$SESSION GV$SESSION
V$SESSION_CONNECT_INFO GV$SESSION_CONNECT_INFO
V$SESSION_CURSOR_CACHE GV$SESSION_CURSOR_CACHE
V$SESSION_EVENT GV$SESSION_EVENT
V$SESSION_LONGOPS GV$SESSION_LONGOPS
V$SESSION_OBJECT_CACHE GV$SESSION_OBJECT_CACHE
V$SESSION_WAIT GV$SESSION_WAIT
V$SESSION_WAIT_CLASS GV$SESSION_WAIT_CLASS
V$SESSION_WAIT_HISTORY GV$SESSION_WAIT_HISTORY
V$SESSMETRIC GV$SESSMETRIC
V$SESSTAT GV$SESSTAT
V$SESS_IO GV$SESS_IO
V$SESS_TIME_MODEL GV$SESS_TIME_MODEL
V$SES_OPTIMIZER_ENV GV$SES_OPTIMIZER_ENV
V$SGA GV$SGA
V$SGAINFO GV$SGAINFO
V$SGASTAT GV$SGASTAT
V$SGA_CURRENT_RESIZE_OPS GV$SGA_CURRENT_RESIZE_OPS
V$SGA_DYNAMIC_COMPONENTS GV$SGA_DYNAMIC_COMPONENTS
V$SGA_DYNAMIC_FREE_MEMORY GV$SGA_DYNAMIC_FREE_MEMORY
V$SGA_RESIZE_OPS GV$SGA_RESIZE_OPS
V$SGA_TARGET_ADVICE GV$SGA_TARGET_ADVICE
V$SHARED_POOL_ADVICE GV$SHARED_POOL_ADVICE
V$SHARED_POOL_RESERVED GV$SHARED_POOL_RESERVED
V$SHARED_SERVER GV$SHARED_SERVER
V$SHARED_SERVER_MONITOR GV$SHARED_SERVER_MONITOR
V$SORT_SEGMENT GV$SORT_SEGMENT
V$SORT_USAGE GV$SORT_USAGE
V$SPPARAMETER GV$SPPARAMETER
V$SQL GV$SQL
V$SQLAREA GV$SQLAREA
V$SQLAREA_PLAN_HASH GV$SQLAREA_PLAN_HASH
V$SQLSTATS GV$SQLSTATS
V$SQLTEXT GV$SQLTEXT
V$SQLTEXT_WITH_NEWLINES GV$SQLTEXT_WITH_NEWLINES
V$SQL_BIND_DATA GV$SQL_BIND_DATA
V$SQL_BIND_METADATA GV$SQL_BIND_METADATA
V$SQL_CURSOR GV$SQL_CURSOR
V$SQL_JOIN_FILTER GV$SQL_JOIN_FILTER
V$SQL_OPTIMIZER_ENV GV$SQL_OPTIMIZER_ENV
V$SQL_PLAN GV$SQL_PLAN
V$SQL_PLAN_STATISTICS GV$SQL_PLAN_STATISTICS
V$SQL_PLAN_STATISTICS_ALL GV$SQL_PLAN_STATISTICS_ALL
V$SQL_REDIRECTION GV$SQL_REDIRECTION
V$SQL_SHARED_CURSOR GV$SQL_SHARED_CURSOR
V$SQL_SHARED_MEMORY GV$SQL_SHARED_MEMORY
V$SQL_WORKAREA GV$SQL_WORKAREA
V$SQL_WORKAREA_ACTIVE GV$SQL_WORKAREA_ACTIVE
V$SQL_WORKAREA_HISTOGRAM GV$SQL_WORKAREA_HISTOGRAM
V$STANDBY_APPLY_SNAPSHOT GV$STANDBY_APPLY_SNAPSHOT
V$STANDBY_LOG GV$STANDBY_LOG
V$STATISTICS_LEVEL GV$STATISTICS_LEVEL
V$STATNAME GV$STATNAME
V$STREAMS_APPLY_COORDINATOR GV$STREAMS_APPLY_COORDINATOR
V$STREAMS_APPLY_READER GV$STREAMS_APPLY_READER
V$STREAMS_APPLY_SERVER GV$STREAMS_APPLY_SERVER
V$STREAMS_CAPTURE GV$STREAMS_CAPTURE
V$STREAMS_POOL_ADVICE GV$STREAMS_POOL_ADVICE
V$STREAMS_TRANSACTION GV$STREAMS_TRANSACTION
V$SUBCACHE GV$SUBCACHE
V$SYSAUX_OCCUPANTS GV$SYSAUX_OCCUPANTS
V$SYSMETRIC GV$SYSMETRIC
V$SYSMETRIC_HISTORY GV$SYSMETRIC_HISTORY
V$SYSMETRIC_SUMMARY GV$SYSMETRIC_SUMMARY
V$SYSSTAT GV$SYSSTAT
V$SYSTEM_CURSOR_CACHE GV$SYSTEM_CURSOR_CACHE
V$SYSTEM_EVENT GV$SYSTEM_EVENT
V$SYSTEM_PARAMETER GV$SYSTEM_PARAMETER
V$SYSTEM_PARAMETER2 GV$SYSTEM_PARAMETER2
V$SYSTEM_WAIT_CLASS GV$SYSTEM_WAIT_CLASS
V$SYS_OPTIMIZER_ENV GV$SYS_OPTIMIZER_ENV
V$SYS_TIME_MODEL GV$SYS_TIME_MODEL
V$TABLESPACE GV$TABLESPACE
V$TEMPFILE GV$TEMPFILE
V$TEMPORARY_LOBS GV$TEMPORARY_LOBS
V$TEMPSTAT GV$TEMPSTAT
V$TEMP_CACHE_TRANSFER GV$TEMP_CACHE_TRANSFER
V$TEMP_EXTENT_MAP GV$TEMP_EXTENT_MAP
V$TEMP_EXTENT_POOL GV$TEMP_EXTENT_POOL
V$TEMP_HISTOGRAM GV$TEMP_HISTOGRAM
V$TEMP_PING GV$TEMP_PING
V$TEMP_SPACE_HEADER GV$TEMP_SPACE_HEADER
V$THREAD GV$THREAD
V$THRESHOLD_TYPES GV$THRESHOLD_TYPES
V$TIMER GV$TIMER
V$TIMEZONE_FILE GV$TIMEZONE_FILE
V$TIMEZONE_NAMES GV$TIMEZONE_NAMES
V$TRANSACTION GV$TRANSACTION
V$TRANSACTION_ENQUEUE GV$TRANSACTION_ENQUEUE
V$TRANSPORTABLE_PLATFORM GV$TRANSPORTABLE_PLATFORM
V$TSM_SESSIONS GV$TSM_SESSIONS
V$TYPE_SIZE GV$TYPE_SIZE
V$UNDOSTAT GV$UNDOSTAT
V$UNUSABLE_BACKUPFILE_DETAILS
V$VERSION GV$VERSION
V$VPD_POLICY GV$VPD_POLICY
V$WAITCLASSMETRIC GV$WAITCLASSMETRIC
V$WAITCLASSMETRIC_HISTORY GV$WAITCLASSMETRIC_HISTORY
V$WAITSTAT GV$WAITSTAT
V$WALLET GV$WALLET
V$XML_AUDIT_TRAIL GV$XML_AUDIT_TRAIL
V$_LOCK GV$_LOCK
V$_LOCK1 GV$_LOCK1
V$_SEQUENCES GV$_SEQUENCES

select f1.name, f2.name, f1.src || f2.src from
(select name, '' src from v$fixed_table where name like 'V$%' or name like 'O$%' union select view_name, 'DBA_VIEWS' src from dba_views where view_name like 'V$%') f1
full outer join
(select name, '' src from v$fixed_table where name not like 'X$%' and name not like 'V$%' and name not like 'O$%' union select view_name, 'DBA_VIEWS' src from dba_views where view_name like 'GV$%') f2
on 'G'||f1.name = f2.name
order by NVL('G'||f1.name, f2.name)
/