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