Overblog Suivre ce blog
Editer la page Administration Créer mon blog
/ / /

Les Vues dynamiques V$ du dictionnaire de données décrivent toutes les informations relatives aux performances et tuning de la base ainsi que son fonctionnement.
Vous pouvez interroger ces vues V$ avec une base en état MOUNT.

Vous pouvez interroger aussi les vues GV$ (vues de bases en Cluster).Elles possèdent les mêmes caractéristiques que les V$ mais avec une colonne supplémentaire (Instance). 

SQL> SELECT table_name,
            comments
     FROM dictionary 
     WHERE table_namelike 'V$%' 
     ORDER BY table_name;


NOMS VUES Dynamiques

DESCRIPTIONS

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

Partager cette page

Repost 0
Published by