ORACLE SQL 10G Pour les Nuls
Commandes SQL pour DBA & Développeurs
Vues V$ du Dictionnaire de données Oracle
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 |
À lire aussi…
Download PDF Oracle
Rechercher sur le site
Thèmes Oracle
- INSTANCE - SGA (9)
- TABLESPACE (11)
- TABLES - INDEX (12)
- SYNONYMS (4)
- REDOLOG / ARCHIVELOG (10)
- CONTROL FILES (5)
- SECURITE - USER (5)
- ROLES / PRIVILEGES (10)
- LISTENER - ORACLE NET (6)
- PROCESSUS (6)
- DATABASE / PARAMETER (12)
- Recovery Manager RMAN (3)
- IMPORT / EXPORT (9)
- SQLPLUS (5)
- SQL LOADER (4)
- SQL VIEW (2)
- FUNCTIONS - SQL (31)
- ORACLE PLSQL (15)
- JOINTURES SQL - SQL JOINS (8)
- COMMANDES SQL DML-LMD (12)
- COMMANDES SQL DDL-LDD (12)
- ORACLE TRIGGERS (3)
- PLSQL Packages (5)
- COMMANDES UNIX / LINUX / OS (1)
- DBCA / OUI / INSTALL / PATCHSET (1)
- ORACLE SCRIPTS (2)
- ORACLE 10G / 11G RAC (2)
- OEM (1)
- OUTILS (5)
- SAUVEGARDES (1)
- DICTIONNAIRE DE DONNEES (1)
- TUNING (2)
- OS / TUNING (3)
- CERTIFICATIONS (2)
- ACTUALITES (4)
Les Vues V$ ...
Erreurs Oracle
- Erreurs ORA 00001 à 00200 Cause et Action
- Erreurs ORA 00201 à 00320 Cause et Action
- Erreurs ORA 00321 à 00600 Cause et Action
- Erreurs ORA 00601 à 00830 Cause et Action
- Erreurs SQL 01075 à 02157 Cause et Action
- Erreurs ORA TNS 12150 à 12236 Cause et Action
- Erreurs ORA TNS 12500 à 12699 Cause et Action
- Erreurs ORA 12700 à 12997 Cause et Action
- Erreurs ORA 13000 à 13220 Cause et Action
- Erreurs ORA 13221 à 13409 Cause et Action
- Erreurs ORA 13410 à 13530 Cause et Action
- Erreurs ORA 13600 à 13871 Cause et Action
- Erreurs ORA 13900 à 14099 Cause et Action
- Erreurs ORA 14100 à 14196 Cause et Action
- Erreurs ORA 14251 à 14553 Cause et Action
- Erreurs ORA 14601 à 15079 Cause et Action
- Erreurs ORA 15080 à 16018 Cause et Action
- Erreurs ORA 16019 à 16139 Cause et Action
- Erreurs ORA 16140 à 16260 Cause et Action
- Erreurs ORA 16400 à 16599 Cause et Action
- Erreurs ORA 16600 à 16661 Cause et Action
- Erreurs ORA 16700 à 16799 Cause et Action
- Erreurs ORA 16800 à 19045 Cause et Action
- Erreurs ORA 19100 à 19249 Cause et Action
- Erreurs ORA 19250 à 19380 Cause et Action
- Erreurs ORA EXP 00000 à 00107 Cause et Action
- Erreurs ORA IMP 00000 à 00401 Cause et Action
- Erreurs PLS 00049 à 00239 Cause et Action
- Erreurs PLS 00240 à 00399 Cause et Action
- Erreurs PLS 00400 à 00539 Cause et Action
- Erreurs PLS 00540 à 00659 Cause et Action
- Erreurs PLS 00660 à 00997 Cause et Action
- Erreurs PLS 01400 à 01913 Cause et Action
