Home > oracle > 主要的动态视图对应的基表

主要的动态视图对应的基表

动态视图                         FIXED TABLE
------------------------     -------------------------
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
GV$LOGMNR_CALLBACK             x$logmnr_callback
GV$LOGMNR_CONTENTS             x$logmnr_contents
GV$LOGMNR_DICTIONARY           x$logmnr_dictionary
GV$LOGMNR_LOGFILE              x$logmnr_logfile
GV$LOGMNR_LOGS                 x$logmnr_logs
GV$LOGMNR_PARAMETERS           x$logmnr_parameters
GV$LOGMNR_PROCESS              x$logmnr_process, v$process
GV$LOGMNR_REGION               x$logmnr_region
GV$LOGMNR_SESSION              x$logmnr_session
GV$LOGMNR_TRANSACTION          x$logmnr_transaction
GV$LOGSTDBY                    x$krvslv
GV$LOGSTDBY_APPLY              x$knstasl,v$session
GV$LOGSTDBY_COORDINATOR        x$knstacr,v$session
GV$LOGSTDBY_STATS              x$krvslvs
GV$LOG_HISTORY                 x$kcclh
GV$MANAGED_STANDBY             x$kcrrms
GV$MAX_ACTIVE_SESS_TARGET_MTH  x$kgskasp
GV$MVREFRESH                   x$knstmvr,v$session
GV$MYSTAT                      x$ksumysta
GV$NLS_PARAMETERS              x$nls_parameters
GV$NLS_VALID_VALUES            x$ksulv
GV$OBJECT_DEPENDENCY           x$kglob,x$kgldp
GV$OBSOLETE_PARAMETER          x$ksppo
GV$OFFLINE_RANGE               x$kccor
GV$OPEN_CURSOR                 x$kgllk
GV$OPTION                      x$option
GV$PARALLEL_DEGREE_LIMIT_MTH   x$kgskdopp
GV$PARAMETER                   x$ksppi, x$ksppcv
GV$PARAMETER2                  x$ksppi , x$ksppcv2
GV$PGASTAT                     X$QESMMSGA
GV$PQ_SESSTAT                  x$kxfpsst
GV$PQ_SLAVE                    x$kxfpdp
GV$PQ_SYSSTAT                  x$kxfpys
GV$PQ_TQSTAT                   x$kxfqsrow
GV$PROCESS                     x$ksupr
GV$PROXY_ARCHIVEDLOG           x$kccpa
GV$PROXY_DATAFILE              x$kccpd
GV$PWFILE_USERS                x$kzsrt
GV$PX_PROCESS                  x$kxfpdp, V$PROCESS, V$SESSION
GV$PX_PROCESS_SYSSTAT          x$kxfpns
GV$PX_SESSION                  x$ksuse,x$kxfpdp
GV$PX_SESSTAT                  x$ksuse, x$kxfpdp, x$ksusesta,x$ksusd
GV$QUEUE                       x$kmcqs
GV$QUEUEING_MTH                x$kgskquep
GV$RECOVERY_FILE_STATUS        x$kcrmx, x$kccfn , x$kccfe, x$kcrmf
GV$RECOVERY_LOG                x$kcclh,x$kcvfhmrr,x$kccle
GV$RECOVERY_PROGRESS           V$SESSION_LONGOPS
GV$RECOVERY_STATUS             x$kcrmx, x$kcrfx
GV$RECOVER_FILE                x$kcvfhmrr
GV$REPLPROP                    x$knstrpp,v$session
GV$REPLQUEUE                   x$knstrqu
GV$REQDIST                     x$kmmrd
GV$RESERVED_WORDS              x$kwddef
GV$RESOURCE                    x$ksqrs
GV$RESOURCE_LIMIT              x$ksurlmt
GV$RESUMABLE                   x$ktrso
GV$RMAN_CONFIGURATION          X$KCCRM
GV$ROLLSTAT                    x$kturd
GV$ROWCACHE                    x$kqrst
GV$ROWCACHE_PARENT             x$kqrfp
GV$ROWCACHE_SUBORDINATE        x$kqrfs
GV$RSRC_CONSUMER_GROUP         x$kgskcft
GV$RSRC_CONSUMER_GROUP_CPU_MTH x$kgskcp
GV$RSRC_PLAN                   x$kgskpft
GV$RSRC_PLAN_CPU_MTH           x$kgskpp
GV$SESSION                     x$ksuse
GV$SESSION_CONNECT_INFO        x$ksusecon
GV$SESSION_CURSOR_CACHE        x$kgicc
GV$SESSION_EVENT               x$ksles , x$ksled
GV$SESSION_LONGOPS             x$ksulop
GV$SESSION_OBJECT_CACHE        x$kocst
GV$SESSION_WAIT                x$ksusecst, x$ksled
GV$SESSTAT                     x$ksusesta
GV$SESS_IO                     x$ksusio
GV$SGA                         x$ksmsd
GV$SGASTAT                     x$ksmfs,x$ksmss,x$ksmls,x$ksmjs
GV$SHARED_POOL_RESERVED        x$ksmspr, x$kghlu
GV$SHARED_SERVER               x$kmmsi
GV$SHARED_SERVER_MONITOR       x$kmmsg
GV$SORT_SEGMENT                x$ktstssd
GV$SORT_USAGE                  x$ktsso, v$session
GV$SPPARAMETER                 x$kspspfile
GV$SQL                         x$kglcursor
GV$SQLAREA                     x$kglcursor
GV$SQLTEXT                     x$kglna
GV$SQLTEXT_WITH_NEWLINES       x$kglna1
GV$SQL_BIND_DATA               x$kxsbd
GV$SQL_BIND_METADATA           x$kksbv
GV$SQL_CURSOR                  x$kxscc
GV$SQL_PLAN                    x$kqlfxpl, obj$ , user$
GV$SQL_REDIRECTION             x$kglcursor , x$kkssrd
GV$SQL_SHARED_CURSOR           x$kkscs
GV$SQL_SHARED_MEMORY           x$kglcursor, x$ksmhp
GV$SQL_WORKAREA
GV$SQL_WORKAREA_ACTIVE         x$qesmmiwt
GV$STANDBY_LOG                 x$kccsl
GV$STATNAME                    x$ksusd
GV$SUBCACHE                    x$kqlset
GV$SYSSTAT                     x$ksusgsta
GV$SYSTEM_CURSOR_CACHE         x$kgics
GV$SYSTEM_EVENT                x$kslei , x$ksled
GV$SYSTEM_PARAMETER            x$ksppi , x$ksppsv
GV$SYSTEM_PARAMETER2           x$ksppi , x$ksppsv2
GV$TABLESPACE                  x$kccts
GV$TEMPFILE                    x$kcctf, x$kccfn , x$kcvfhtmp
GV$TEMPORARY_LOBS              X$KDLT
GV$TEMPSTAT                    x$kcftio ,x$kcctf
GV$TEMP_CACHE_TRANSFER         x$kcftio , x$kcctf
GV$TEMP_EXTENT_MAP             ts$, x$ktftme
GV$TEMP_EXTENT_POOL            ts$ , x$ktstfc
GV$TEMP_PING                   x$kcftio , x$kcctf
GV$TEMP_SPACE_HEADER           ts$ , x$ktfthc
GV$THREAD                      x$kccrt
GV$TIMER                       x$ksutm
GV$TIMEZONE_NAMES              X$TIMEZONE_NAMES
GV$TRANSACTION                 x$ktcxb
GV$TRANSACTION_ENQUEUE         x$ktcxb ,x$ksuse ,x$ksqrs
GV$TYPE_SIZE                   x$kqfsz
GV$UNDOSTAT                    X$KTUSMST
GV$VERSION                     x$version
GV$VPD_POLICY                  x$kglcursor, x$kzrtpd
GV$WAITSTAT                    x$kcbwait
GV$_LOCK                       v$_lock1,x$ktadm,x$ktcxb
GV$_LOCK1                      x$kdnssf, x$ksqeq
GV$_SEQUENCES                  X$KGLOB
V$ACCESS                       GV$ACCESS
V$ACTIVE_INSTANCES             GV$ACTIVE_INSTANCES
V$ACTIVE_SESS_POOL_MTH         gv$active_sess_pool_mth
V$AQ1                          GV$AQ1
V$ARCHIVE                      GV$ARCHIVE
V$ARCHIVED_LOG                 GV$ARCHIVED_LOG
V$ARCHIVE_DEST                 GV$ARCHIVE_DEST
V$ARCHIVE_DEST_STATUS          GV$ARCHIVE_DEST_STATUS
V$ARCHIVE_GAP                  GV$ARCHIVE_GAP
V$ARCHIVE_PROCESSES            GV$ARCHIVE_PROCESSES
V$BACKUP                       GV$BACKUP
V$BACKUP_ASYNC_IO              gv$backup_async_io
V$BACKUP_CORRUPTION            GV$BACKUP_CORRUPTION
V$BACKUP_DATAFILE              GV$BACKUP_DATAFILE
V$BACKUP_DEVICE                GV$BACKUP_DEVICE
V$BACKUP_PIECE                 GV$BACKUP_PIECE
V$BACKUP_REDOLOG               GV$BACKUP_REDOLOG
V$BACKUP_SET                   GV$BACKUP_SET
V$BACKUP_SYNC_IO               gv$backup_sync_io
V$BGPROCESS                    gv$bgprocess
V$BH                           gv$bh
V$BSP                          gv$bsp
V$BUFFER_POOL                  gv$buffer_pool
V$BUFFER_POOL_STATISTICS       gv$buffer_pool_statistics
V$CIRCUIT                      GV$CIRCUIT
V$CLASS_CACHE_TRANSFER         gv$class_cache_transfer
V$CLASS_PING                   gv$class_ping
V$COMPATIBILITY                GV$COMPATIBILITY
V$COMPATSEG                    GV$COMPATSEG
V$CONTEXT                      x$context
V$CONTROLFILE                  GV$CONTROLFILE
V$CONTROLFILE_RECORD_SECTION   GV$CONTROLFILE_RECORD_SECTION
V$COPY_CORRUPTION              GV$COPY_CORRUPTION
V$CR_BLOCK_SERVER              gv$cr_block_server
V$DATABASE                     GV$DATABASE
V$DATAFILE                     GV$DATAFILE
V$DATAFILE_COPY                GV$DATAFILE_COPY
V$DATAFILE_HEADER              GV$DATAFILE_HEADER
V$DBFILE                       GV$DBFILE
V$DBLINK                       GV$DBLINK
V$DB_CACHE_ADVICE              gv$db_cache_advice
V$DB_OBJECT_CACHE              GV$DB_OBJECT_CACHE
V$DB_PIPES                     GV$DB_PIPES
V$DELETED_OBJECT               GV$DELETED_OBJECT
V$DISPATCHER                   GV$DISPATCHER
V$DISPATCHER_RATE              GV$DISPATCHER_RATE
V$DLM_ALL_LOCKS                GV$DLM_ALL_LOCKS
V$DLM_CONVERT_LOCAL            GV$DLM_CONVERT_LOCAL
V$DLM_CONVERT_REMOTE           GV$DLM_CONVERT_REMOTE
V$DLM_LATCH                    GV$DLM_LATCH
V$DLM_LOCKS                    GV$DLM_LOCKS
V$DLM_MISC                     GV$DLM_MISC
V$DLM_RESS                     GV$DLM_RESS
V$DLM_TRAFFIC_CONTROLLER       GV$DLM_TRAFFIC_CONTROLLER
V$ENABLEDPRIVS                 GV$ENABLEDPRIVS
V$ENQUEUE_LOCK                 GV$ENQUEUE_LOCK
V$ENQUEUE_STAT                 GV$ENQUEUE_STAT
V$EVENT_NAME                   gv$event_name
V$EXECUTION                    GV$EXECUTION
V$FAST_START_SERVERS           GV$FAST_START_SERVERS
V$FAST_START_TRANSACTIONS      GV$FAST_START_TRANSACTIONS
V$FILESTAT                     GV$FILESTAT
V$FILE_CACHE_TRANSFER          gv$file_cache_transfer
V$FILE_PING                    gv$file_ping
V$FIXED_TABLE                  GV$FIXED_TABLE
V$FIXED_VIEW_DEFINITION        GV$FIXED_VIEW_DEFINITION
V$GCSHVMASTER_INFO             GV$GCSHVMASTER_INFO
V$GCSPFMASTER_INFO             GV$GCSPFMASTER_INFO
V$GC_ELEMENT                   gv$gc_element
V$GC_ELEMENTS_WITH_COLLISIONS  gv$gc_elements_with_collisions
V$GES_BLOCKING_ENQUEUE         GV$GES_BLOCKING_ENQUEUE
V$GES_ENQUEUE                  GV$GES_ENQUEUE
V$GLOBALCONTEXT                gv$globalcontext
V$GLOBAL_BLOCKED_LOCKS         gv$global_blocked_locks
V$GLOBAL_TRANSACTION           GV$GLOBAL_TRANSACTION
V$HS_AGENT                     GV$HS_AGENT
V$HS_PARAMETER                 GV$HS_PARAMETER
V$HS_SESSION                   GV$HS_SESSION
V$HVMASTER_INFO                GV$HVMASTER_INFO
V$INDEXED_FIXED_COLUMN         GV$INDEXED_FIXED_COLUMN
V$INSTANCE                     GV$INSTANCE
V$INSTANCE_RECOVERY            GV$INSTANCE_RECOVERY
V$LATCH                        gv$latch
V$LATCHHOLDER                  GV$LATCHHOLDER
V$LATCHNAME                    gv$latchname
V$LATCH_CHILDREN               GV$LATCH_CHILDREN
V$LATCH_MISSES                 GV$LATCH_MISSES
V$LATCH_PARENT                 GV$LATCH_PARENT
V$LIBRARYCACHE                 GV$LIBRARYCACHE
V$LICENSE                      gv$license
V$LOADCSTAT                    GV$LOADCSTAT
V$LOADISTAT                    GV$LOADISTAT
V$LOADPSTAT                    GV$LOADPSTAT
V$LOADTSTAT                    GV$LOADTSTAT
V$LOCK                         GV$LOCK
V$LOCKED_OBJECT                gv$locked_object
V$LOCKS_WITH_COLLISIONS        v$bh
V$LOCK_ACTIVITY                GV$LOCK_ACTIVITY
V$LOCK_ELEMENT                 gv$lock_element
V$LOG                          GV$LOG
V$LOGFILE                      GV$LOGFILE
V$LOGHIST                      GV$LOGHIST
V$LOGMNR_CALLBACK              gv$logmnr_callback
V$LOGMNR_CONTENTS              GV$LOGMNR_CONTENTS
V$LOGMNR_DICTIONARY            GV$LOGMNR_DICTIONARY
V$LOGMNR_LOGFILE               gv$logmnr_logfile
V$LOGMNR_LOGS                  GV$LOGMNR_LOGS
V$LOGMNR_PARAMETERS            GV$LOGMNR_PARAMETERS
V$LOGMNR_PROCESS               gv$logmnr_process
V$LOGMNR_REGION                gv$logmnr_region
V$LOGMNR_SESSION               GV$LOGMNR_SESSION
V$LOGMNR_TRANSACTION           gv$logmnr_transaction
V$LOGSTDBY                     gv$logstdby
V$LOGSTDBY_APPLY               GV$LOGSTDBY_APPLY
V$LOGSTDBY_COORDINATOR         GV$LOGSTDBY_COORDINATOR
V$LOGSTDBY_STATS               gv$logstdby_stats
V$LOG_HISTORY                  GV$LOG_HISTORY
V$MANAGED_STANDBY              GV$MANAGED_STANDBY
V$MAX_ACTIVE_SESS_TARGET_MTH   gv$max_active_sess_target_mth
V$MVREFRESH                    GV$MVREFRESH
V$MYSTAT                       GV$MYSTAT
V$NLS_PARAMETERS               GV$NLS_PARAMETERS
V$NLS_VALID_VALUES             GV$NLS_VALID_VALUES
V$OBJECT_DEPENDENCY            GV$OBJECT_DEPENDENCY
V$OBSOLETE_PARAMETER           GV$OBSOLETE_PARAMETER
V$OFFLINE_RANGE                GV$OFFLINE_RANGE
V$OPEN_CURSOR                  GV$OPEN_CURSOR
V$OPTION                       GV$OPTION
V$PARALLEL_DEGREE_LIMIT_MTH    gv$parallel_degree_limit_mth
V$PARAMETER                    GV$PARAMETER
V$PARAMETER2                   GV$PARAMETER2
V$PGASTAT                      GV$PGASTAT
V$PQ_SESSTAT                   GV$PQ_SESSTAT
V$PQ_SLAVE                     GV$PQ_SLAVE
V$PQ_SYSSTAT                   GV$PQ_SYSSTAT
V$PQ_TQSTAT                    GV$PQ_TQSTAT
V$PROCESS                      gv$process
V$PROXY_ARCHIVEDLOG            GV$PROXY_ARCHIVEDLOG
V$PROXY_DATAFILE               GV$PROXY_DATAFILE
V$PWFILE_USERS                 GV$PWFILE_USERS
V$PX_PROCESS                   GV$PX_PROCESS
V$PX_PROCESS_SYSSTAT           GV$PX_PROCESS_SYSSTAT
V$PX_SESSION                   GV$PX_SESSION
V$PX_SESSTAT                   GV$PX_SESSTAT
V$QUEUE                        GV$QUEUE
V$QUEUEING_MTH                 gv$queueing_mth
V$RECOVERY_FILE_STATUS         GV$RECOVERY_FILE_STATUS
V$RECOVERY_LOG                 GV$RECOVERY_LOG
V$RECOVERY_PROGRESS            GV$RECOVERY_PROGRESS
V$RECOVERY_STATUS              GV$RECOVERY_STATUS
V$RECOVER_FILE                 GV$RECOVER_FILE
V$REPLPROP                     GV$REPLPROP
V$REPLQUEUE                    GV$REPLQUEUE
V$REQDIST                      GV$REQDIST
V$RESERVED_WORDS               GV$RESERVED_WORDS
V$RESOURCE                     GV$RESOURCE
V$RESOURCE_LIMIT               GV$RESOURCE_LIMIT
V$RESUMABLE                    GV$RESUMABLE
V$RMAN_CONFIGURATION           GV$RMAN_CONFIGURATION
V$ROLLSTAT                     GV$ROLLSTAT
V$ROWCACHE                     gv$rowcache
V$ROWCACHE_PARENT              gv$rowcache_parent
V$ROWCACHE_SUBORDINATE         gv$rowcache_subordinate
V$RSRC_CONSUMER_GROUP          gv$rsrc_consumer_group
V$RSRC_CONSUMER_GROUP_CPU_MTH  gv$rsrc_consumer_group_cpu_mth
V$RSRC_PLAN                    gv$rsrc_plan
V$RSRC_PLAN_CPU_MTH            gv$rsrc_plan_cpu_mth
VSESSION                       GV$SESSION
V$SESSION_CONNECT_INFO         gv$session_connect_info
V$SESSION_CURSOR_CACHE         GV$SESSION_CURSOR_CACHE
V$SESSION_EVENT                gv$session_event
V$SESSION_LONGOPS              GV$SESSION_LONGOPS
V$SESSION_OBJECT_CACHE         gv$session_object_cache
V$SESSION_WAIT                 gv$session_wait
V$SESSTAT                      GV$SESSTAT
V$SESS_IO                      GV$SESS_IO
V$SGA                          GV$SGA
V$SGASTAT                      GV$SGASTAT
V$SHARED_POOL_RESERVED         GV$SHARED_POOL_RESERVED
V$SHARED_SERVER                GV$SHARED_SERVER
V$SHARED_SERVER_MONITOR        GV$SHARED_SERVER_MONITOR
V$SORT_SEGMENT                 GV$SORT_SEGMENT
V$SORT_USAGE                   GV$SORT_USAGE
V$SPPARAMETER                  GV$SPPARAMETER
V$SQL                          GV$SQL
V$SQLAREA                      GV$SQLAREA
V$SQLTEXT                      GV$SQLTEXT
V$SQLTEXT_WITH_NEWLINES        GV$SQLTEXT_WITH_NEWLINES
V$SQL_BIND_DATA                GV$SQL_BIND_DATA
V$SQL_BIND_METADATA            GV$SQL_BIND_METADATA
V$SQL_CURSOR                   GV$SQL_CURSOR
V$SQL_PLAN                     GV$SQL_PLAN
V$SQL_REDIRECTION              GV$SQL_REDIRECTION
V$SQL_SHARED_CURSOR            GV$SQL_SHARED_CURSOR
V$SQL_SHARED_MEMORY            GV$SQL_SHARED_MEMORY
V$SQL_WORKAREA                 GV$SQL_WORKAREA
V$SQL_WORKAREA_ACTIVE          GV$SQL_WORKAREA_ACTIVE
V$STANDBY_LOG                  GV$STANDBY_LOG
V$STATNAME                     GV$STATNAME
V$SUBCACHE                     GV$SUBCACHE
V$SYSSTAT                      GV$SYSSTAT
V$SYSTEM_CURSOR_CACHE          GV$SYSTEM_CURSOR_CACHE
V$SYSTEM_EVENT                 gv$system_event
V$SYSTEM_PARAMETER             GV$SYSTEM_PARAMETER
V$SYSTEM_PARAMETER2            GV$SYSTEM_PARAMETER2
V$TABLESPACE                   GV$TABLESPACE
V$TEMPFILE                     GV$TEMPFILE
V$TEMPORARY_LOBS               GV$TEMPORARY_LOBS
V$TEMPSTAT                     GV$TEMPSTAT
V$TEMP_CACHE_TRANSFER          gv$temp_cache_transfer
V$TEMP_EXTENT_MAP              GV$TEMP_EXTENT_MAP
V$TEMP_EXTENT_POOL             GV$TEMP_EXTENT_POOL
V$TEMP_PING                    gv$temp_ping
V$TEMP_SPACE_HEADER            GV$TEMP_SPACE_HEADER
V$THREAD                       GV$THREAD
V$TIMER                        GV$TIMER
V$TIMEZONE_NAMES               GV$TIMEZONE_NAMES
V$TRANSACTION                  gv$transaction
V$TRANSACTION_ENQUEUE          GV$TRANSACTION_ENQUEUE
V$TYPE_SIZE                    GV$TYPE_SIZE
V$UNDOSTAT                     X$KTUSMST
V$VERSION                      GV$VERSION
V$VPD_POLICY                   GV$VPD_POLICY
V$WAITSTAT                     gv$waitstat
V$_LOCK                        GV$_LOCK
V$_LOCK1                       GV$_LOCK1
V$_SEQUENCES                   GV$_SEQUENCES
Categories: oracle Tags: ,
  1. No comments yet.
  1. No trackbacks yet.

*
To prove you're a person (not a spam script), type the security word shown in the picture. Click on the picture to hear an audio file of the word.
Click to hear an audio file of the anti-spam word

Videos, Slideshows and Podcasts by Cincopa Wordpress Plugin