oracle主要的動態視圖與基表的對應關係

動態視圖

基表

GV$ACCESS

x$ksuses,x$kglob,x$kgldp,x$kgllk

GV$ACTIVE_INSTANCES

x$ksimsi

GV$ACTIVE_SESS_POOL_MTH

x$kgskasp

GV$AQ1

X$KWQSI

GV$ACCESS

x$ksuses,x$kglob,x$kgldp,x$kgllk

GV$ACTIVE_INSTANCES

x$ksimsi

GV$ACTIVE_SESS_POOL_MTH

x$kgskasp

GV$AQ1

X$KWQSI

GV$ARCHIVE

x$kccle,x$kccdi

GV$ARCHIVED_LOG

x$kccal

GV$ARCHIVE_DEST

x$kcrrdest

GV$ARCHIVE_DEST_STATUS

x$kcrrdstat

GV$ARCHIVE_GAP

v$archived_log, from v$log_history,

GV$ARCHIVE_PROCESSES

x$kcrrarch

GV$BACKUP

x$kcvfhonl

GV$BACKUP_ASYNC_IO

x$ksfqp

GV$BACKUP_CORRUPTION

x$kccfc

GV$BACKUP_DATAFILE

x$kccbf

GV$BACKUP_DEVICE

x$ksfhdvnt

GV$BACKUP_PIECE

x$kccbp

GV$BACKUP_REDOLOG

x$kccbl

GV$BACKUP_SET

x$kccbs

GV$BACKUP_SYNC_IO

x$ksfqp

GV$BGPROCESS

x$ksbdp,x$ksbdd

GV$BH

x$bh,x$le

GV$BSP

x$kclcrst

GV$BUFFER_POOL

x$kcbwbpd

GV$BUFFER_POOL_STATISTICS

x$kcbwds,x$kcbwbpd

GV$CIRCUIT

x$kmcvc

GV$CLASS_CACHE_TRANSFER

x$class_stat

GV$CLASS_PING

x$class_stat

GV$COMPATIBILITY

x$kckty

GV$COMPATSEG

x$kckce

GV$CONTEXT

x$context

GV$CONTROLFILE

x$kcccf

GV$CONTROLFILE_RECORD_SECTION

x$kccrs

GV$COPY_CORRUPTION

x$kcccc

GV$CR_BLOCK_SERVER

x$kclcrst

GV$DATABASE

x$kccdi

GV$DATAFILE

x$kccfe,x$kccfn,x$kccfn, x$kcvfh

GV$DATAFILE_COPY

x$kccdc

GV$DATAFILE_HEADER

x$kcvfh

GV$DBFILE

x$kccfn

GV$DBLINK

x$uganco

GV$DB_CACHE_ADVICE

x$kcbsc,x$kcbwbpd

GV$DB_OBJECT_CACHE

x$kglob

GV$DB_PIPES

x$kglob

GV$DELETED_OBJECT

x$kccdl

GV$DISPATCHER

x$kmmdi

GV$DISPATCHER_RATE

x$kmmdi

GV$DLM_ALL_LOCKS

V$GES_ENQUEUE

GV$DLM_CONVERT_LOCAL

x$kjicvt

GV$DLM_CONVERT_REMOTE

x$kjicvt

GV$DLM_LATCH

V$LATCH

GV$DLM_LOCKS

V$GES_BLOCKING_ENQUEUE

GV$DLM_MISC

x$kjisft

GV$DLM_RESS

x$kjirft,x$kjbr

GV$DLM_TRAFFIC_CONTROLLER

x$kjitrft

GV$ENABLEDPRIVS

x$kzspr

GV$ENQUEUE_LOCK

x$ksqeq,x$ksuse,x$ksqrs

GV$ENQUEUE_STAT

X$KSQST

GV$EVENT_NAME

x$ksled

GV$EXECUTION

x$kstex

GV$FAST_START_SERVERS

x$ktprxrs

GV$FAST_START_TRANSACTIONS

x$ktprxrt

GV$FILESTAT

x$kcfio,x$kccfe

GV$FILE_CACHE_TRANSFER

x$kcfio,x$kccfe

GV$FILE_PING

x$kcfio,x$kccfe

GV$FIXED_TABLE

x$kqfta,x$kqfdt

GV$FIXED_VIEW_DEFINITION

x$kqfvi,x$kqfvt

GV$GCSHVMASTER_INFO

x$kjdrpcmhv

GV$GCSPFMASTER_INFO

x$kjdrpcmpf

GV$GC_ELEMENT

x$le

GV$GC_ELEMENTS_WITH_COLLISIONS

v$bh

GV$GES_BLOCKING_ENQUEUE

V$GES_ENQUEUE

GV$GES_ENQUEUE

x$kjilkft,x$kjbl

GV$GLOBALCONTEXT

x$globalcontext

GV$GLOBAL_BLOCKED_LOCKS

v$lock, v$dlm_locks

GV$GLOBAL_TRANSACTION

X$K2GTE2

GV$HS_AGENT

X$HS_SESSION

GV$HS_PARAMETER

X$HS_SESSION,X$HOFP

GV$HS_SESSION

X$HS_SESSION

GV$HVMASTER_INFO

x$kjdrhv

GV$INDEXED_FIXED_COLUMN

x$kqfco,x$kqfta

GV$INSTANCE

x$ksuxsinst,x$kvit,x$quiesce

GV$INSTANCE_RECOVERY

X$KSUSGSTA,X$TARGETRBA,X$ESTIMATED_MTTR

GV$LATCH

x$kslld, x$ksllt

GV$LATCHHOLDER

x$ksuprlat

GV$LATCHNAME

x$kslld

GV$LATCH_CHILDREN

x$ksllt,x$kslld

GV$LATCH_MISSES

x$ksllw,x$kslwsc

GV$LATCH_PARENT

x$ksllt, x$kslld

GV$LIBRARYCACHE

x$kglst

GV$LICENSE

x$ksull

GV$LOADCSTAT

x$kllcnt

GV$LOADISTAT

x$klcie

GV$LOADPSTAT

x$klpt

GV$LOADTSTAT

x$klltab

GV$LOCK

v$_lock,x$ksuse,x$ksqrs

GV$LOCKED_OBJECT

x$ktcxb,x$ktadm, x$ksuse

GV$LOCKS_WITH_COLLISIONS

v$bh

GV$LOCK_ACTIVITY

x$le_stat

GV$LOCK_ELEMENT

x$le

GV$LOG

x$kccle, x$kccrt

GV$LOGFILE

x$kccfn

GV$LOGHIST

x$kcclh