Thursday, January 3, 2008

Oracle Dictionary - Dynamic Views

SQL> SELECT * FROM DICT WHERE TABLE_NAME LIKE 'V$%' ORDER BY TABLE_NAME;

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

398 rows selected.

SQL> SPOOL OFF;

Latest Posts