oracle V$-----X$

来源:互联网 发布:哪吒lite飞控调参软件 编辑:程序博客网 时间:2024/05/22 14:00

转自:http://www.orablogger.com/2009/01/%E4%B8%BB%E8%A6%81%E7%9A%84%E5%8A%A8%E6%80%81%E8%A7%86%E5%9B%BE%E5%AF%B9%E5%BA%94%E7%9A%84%E5%9F%BA%E8%A1%A8/


动态视图                         FIXED TABLE------------------------     -------------------------GV$ACCESS                    x$ksuses,x$kglob,x$kgldp,x$kgllkGV$ACTIVE_INSTANCES          x$ksimsiGV$ACTIVE_SESS_POOL_MTH      x$kgskaspGV$AQ1                       X$KWQSIGV$ACCESS                    x$ksuses,x$kglob,x$kgldp,x$kgllkGV$ACTIVE_INSTANCES          x$ksimsiGV$ACTIVE_SESS_POOL_MTH      x$kgskaspGV$AQ1                       X$KWQSIGV$ARCHIVE                   x$kccle,x$kccdiGV$ARCHIVED_LOG              x$kccalGV$ARCHIVE_DEST              x$kcrrdestGV$ARCHIVE_DEST_STATUS       x$kcrrdstatGV$ARCHIVE_GAP               v$archived_log, from v$log_history,GV$ARCHIVE_PROCESSES         x$kcrrarchGV$BACKUP                    x$kcvfhonlGV$BACKUP_ASYNC_IO           x$ksfqpGV$BACKUP_CORRUPTION         x$kccfcGV$BACKUP_DATAFILE           x$kccbfGV$BACKUP_DEVICE             x$ksfhdvntGV$BACKUP_PIECE              x$kccbpGV$BACKUP_REDOLOG            x$kccblGV$BACKUP_SET                x$kccbsGV$BACKUP_SYNC_IO            x$ksfqpGV$BGPROCESS                 x$ksbdp,x$ksbddGV$BH                        x$bh,x$leGV$BSP                       x$kclcrstGV$BUFFER_POOL               x$kcbwbpdGV$BUFFER_POOL_STATISTICS    x$kcbwds,x$kcbwbpdGV$CIRCUIT                   x$kmcvcGV$CLASS_CACHE_TRANSFER      x$class_statGV$CLASS_PING                x$class_statGV$COMPATIBILITY             x$kcktyGV$COMPATSEG                 x$kckceGV$CONTEXT                   x$contextGV$CONTROLFILE               x$kcccfGV$CONTROLFILE_RECORD_SECTION  x$kccrsGV$COPY_CORRUPTION             x$kccccGV$CR_BLOCK_SERVER             x$kclcrstGV$DATABASE                    x$kccdiGV$DATAFILE                    x$kccfe,x$kccfn,x$kccfn, x$kcvfhGV$DATAFILE_COPY               x$kccdcGV$DATAFILE_HEADER             x$kcvfhGV$DBFILE                      x$kccfnGV$DBLINK                      x$ugancoGV$DB_CACHE_ADVICE             x$kcbsc,x$kcbwbpdGV$DB_OBJECT_CACHE             x$kglobGV$DB_PIPES                    x$kglobGV$DELETED_OBJECT              x$kccdlGV$DISPATCHER                  x$kmmdiGV$DISPATCHER_RATE             x$kmmdiGV$DLM_ALL_LOCKS               V$GES_ENQUEUEGV$DLM_CONVERT_LOCAL           x$kjicvtGV$DLM_CONVERT_REMOTE          x$kjicvtGV$DLM_LATCH                   V$LATCHGV$DLM_LOCKS                   V$GES_BLOCKING_ENQUEUEGV$DLM_MISC                    x$kjisftGV$DLM_RESS                    x$kjirft,x$kjbrGV$DLM_TRAFFIC_CONTROLLER      x$kjitrftGV$ENABLEDPRIVS                x$kzsprGV$ENQUEUE_LOCK                x$ksqeq,x$ksuse,x$ksqrsGV$ENQUEUE_STAT                X$KSQSTGV$EVENT_NAME                  x$ksledGV$EXECUTION                   x$kstexGV$FAST_START_SERVERS          x$ktprxrsGV$FAST_START_TRANSACTIONS     x$ktprxrtGV$FILESTAT                    x$kcfio,x$kccfeGV$FILE_CACHE_TRANSFER         x$kcfio,x$kccfeGV$FILE_PING                   x$kcfio,x$kccfeGV$FIXED_TABLE                 x$kqfta,x$kqfdtGV$FIXED_VIEW_DEFINITION       x$kqfvi,x$kqfvtGV$GCSHVMASTER_INFO            x$kjdrpcmhvGV$GCSPFMASTER_INFO            x$kjdrpcmpfGV$GC_ELEMENT                  x$leGV$GC_ELEMENTS_WITH_COLLISIONS v$bhGV$GES_BLOCKING_ENQUEUE        V$GES_ENQUEUEGV$GES_ENQUEUE                 x$kjilkft,x$kjblGV$GLOBALCONTEXT               x$globalcontextGV$GLOBAL_BLOCKED_LOCKS        v$lock, v$dlm_locksGV$GLOBAL_TRANSACTION          X$K2GTE2GV$HS_AGENT                    X$HS_SESSIONGV$HS_PARAMETER                X$HS_SESSION,X$HOFPGV$HS_SESSION                  X$HS_SESSIONGV$HVMASTER_INFO               x$kjdrhvGV$INDEXED_FIXED_COLUMN        x$kqfco,x$kqftaGV$INSTANCE                    x$ksuxsinst,x$kvit,x$quiesceGV$INSTANCE_RECOVERY           X$KSUSGSTA,X$TARGETRBA,X$ESTIMATED_MTTRGV$LATCH                       x$kslld, x$kslltGV$LATCHHOLDER                 x$ksuprlatGV$LATCHNAME                   x$kslldGV$LATCH_CHILDREN              x$ksllt,x$kslldGV$LATCH_MISSES                x$ksllw,x$kslwscGV$LATCH_PARENT                x$ksllt, x$kslldGV$LIBRARYCACHE                x$kglstGV$LICENSE                     x$ksullGV$LOADCSTAT                   x$kllcntGV$LOADISTAT                   x$klcieGV$LOADPSTAT                   x$klptGV$LOADTSTAT                   x$klltabGV$LOCK                        v$_lock,x$ksuse,x$ksqrsGV$LOCKED_OBJECT               x$ktcxb,x$ktadm, x$ksuseGV$LOCKS_WITH_COLLISIONS       v$bhGV$LOCK_ACTIVITY               x$le_statGV$LOCK_ELEMENT                x$leGV$LOG                         x$kccle, x$kccrtGV$LOGFILE                     x$kccfnGV$LOGHIST                     x$kcclhGV$LOGMNR_CALLBACK             x$logmnr_callbackGV$LOGMNR_CONTENTS             x$logmnr_contentsGV$LOGMNR_DICTIONARY           x$logmnr_dictionaryGV$LOGMNR_LOGFILE              x$logmnr_logfileGV$LOGMNR_LOGS                 x$logmnr_logsGV$LOGMNR_PARAMETERS           x$logmnr_parametersGV$LOGMNR_PROCESS              x$logmnr_process, v$processGV$LOGMNR_REGION               x$logmnr_regionGV$LOGMNR_SESSION              x$logmnr_sessionGV$LOGMNR_TRANSACTION          x$logmnr_transactionGV$LOGSTDBY                    x$krvslvGV$LOGSTDBY_APPLY              x$knstasl,v$sessionGV$LOGSTDBY_COORDINATOR        x$knstacr,v$sessionGV$LOGSTDBY_STATS              x$krvslvsGV$LOG_HISTORY                 x$kcclhGV$MANAGED_STANDBY             x$kcrrmsGV$MAX_ACTIVE_SESS_TARGET_MTH  x$kgskaspGV$MVREFRESH                   x$knstmvr,v$sessionGV$MYSTAT                      x$ksumystaGV$NLS_PARAMETERS              x$nls_parametersGV$NLS_VALID_VALUES            x$ksulvGV$OBJECT_DEPENDENCY           x$kglob,x$kgldpGV$OBSOLETE_PARAMETER          x$ksppoGV$OFFLINE_RANGE               x$kccorGV$OPEN_CURSOR                 x$kgllkGV$OPTION                      x$optionGV$PARALLEL_DEGREE_LIMIT_MTH   x$kgskdoppGV$PARAMETER                   x$ksppi, x$ksppcvGV$PARAMETER2                  x$ksppi , x$ksppcv2GV$PGASTAT                     X$QESMMSGAGV$PQ_SESSTAT                  x$kxfpsstGV$PQ_SLAVE                    x$kxfpdpGV$PQ_SYSSTAT                  x$kxfpysGV$PQ_TQSTAT                   x$kxfqsrowGV$PROCESS                     x$ksuprGV$PROXY_ARCHIVEDLOG           x$kccpaGV$PROXY_DATAFILE              x$kccpdGV$PWFILE_USERS                x$kzsrtGV$PX_PROCESS                  x$kxfpdp, V$PROCESS, V$SESSIONGV$PX_PROCESS_SYSSTAT          x$kxfpnsGV$PX_SESSION                  x$ksuse,x$kxfpdpGV$PX_SESSTAT                  x$ksuse, x$kxfpdp, x$ksusesta,x$ksusdGV$QUEUE                       x$kmcqsGV$QUEUEING_MTH                x$kgskquepGV$RECOVERY_FILE_STATUS        x$kcrmx, x$kccfn , x$kccfe, x$kcrmfGV$RECOVERY_LOG                x$kcclh,x$kcvfhmrr,x$kccleGV$RECOVERY_PROGRESS           V$SESSION_LONGOPSGV$RECOVERY_STATUS             x$kcrmx, x$kcrfxGV$RECOVER_FILE                x$kcvfhmrrGV$REPLPROP                    x$knstrpp,v$sessionGV$REPLQUEUE                   x$knstrquGV$REQDIST                     x$kmmrdGV$RESERVED_WORDS              x$kwddefGV$RESOURCE                    x$ksqrsGV$RESOURCE_LIMIT              x$ksurlmtGV$RESUMABLE                   x$ktrsoGV$RMAN_CONFIGURATION          X$KCCRMGV$ROLLSTAT                    x$kturdGV$ROWCACHE                    x$kqrstGV$ROWCACHE_PARENT             x$kqrfpGV$ROWCACHE_SUBORDINATE        x$kqrfsGV$RSRC_CONSUMER_GROUP         x$kgskcftGV$RSRC_CONSUMER_GROUP_CPU_MTH x$kgskcpGV$RSRC_PLAN                   x$kgskpftGV$RSRC_PLAN_CPU_MTH           x$kgskppGV$SESSION                     x$ksuseGV$SESSION_CONNECT_INFO        x$ksuseconGV$SESSION_CURSOR_CACHE        x$kgiccGV$SESSION_EVENT               x$ksles , x$ksledGV$SESSION_LONGOPS             x$ksulopGV$SESSION_OBJECT_CACHE        x$kocstGV$SESSION_WAIT                x$ksusecst, x$ksledGV$SESSTAT                     x$ksusestaGV$SESS_IO                     x$ksusioGV$SGA                         x$ksmsdGV$SGASTAT                     x$ksmfs,x$ksmss,x$ksmls,x$ksmjsGV$SHARED_POOL_RESERVED        x$ksmspr, x$kghluGV$SHARED_SERVER               x$kmmsiGV$SHARED_SERVER_MONITOR       x$kmmsgGV$SORT_SEGMENT                x$ktstssdGV$SORT_USAGE                  x$ktsso, v$sessionGV$SPPARAMETER                 x$kspspfileGV$SQL                         x$kglcursorGV$SQLAREA                     x$kglcursorGV$SQLTEXT                     x$kglnaGV$SQLTEXT_WITH_NEWLINES       x$kglna1GV$SQL_BIND_DATA               x$kxsbdGV$SQL_BIND_METADATA           x$kksbvGV$SQL_CURSOR                  x$kxsccGV$SQL_PLAN                    x$kqlfxpl, obj$ , user$GV$SQL_REDIRECTION             x$kglcursor , x$kkssrdGV$SQL_SHARED_CURSOR           x$kkscsGV$SQL_SHARED_MEMORY           x$kglcursor, x$ksmhpGV$SQL_WORKAREAGV$SQL_WORKAREA_ACTIVE         x$qesmmiwtGV$STANDBY_LOG                 x$kccslGV$STATNAME                    x$ksusdGV$SUBCACHE                    x$kqlsetGV$SYSSTAT                     x$ksusgstaGV$SYSTEM_CURSOR_CACHE         x$kgicsGV$SYSTEM_EVENT                x$kslei , x$ksledGV$SYSTEM_PARAMETER            x$ksppi , x$ksppsvGV$SYSTEM_PARAMETER2           x$ksppi , x$ksppsv2GV$TABLESPACE                  x$kcctsGV$TEMPFILE                    x$kcctf, x$kccfn , x$kcvfhtmpGV$TEMPORARY_LOBS              X$KDLTGV$TEMPSTAT                    x$kcftio ,x$kcctfGV$TEMP_CACHE_TRANSFER         x$kcftio , x$kcctfGV$TEMP_EXTENT_MAP             ts$, x$ktftmeGV$TEMP_EXTENT_POOL            ts$ , x$ktstfcGV$TEMP_PING                   x$kcftio , x$kcctfGV$TEMP_SPACE_HEADER           ts$ , x$ktfthcGV$THREAD                      x$kccrtGV$TIMER                       x$ksutmGV$TIMEZONE_NAMES              X$TIMEZONE_NAMESGV$TRANSACTION                 x$ktcxbGV$TRANSACTION_ENQUEUE         x$ktcxb ,x$ksuse ,x$ksqrsGV$TYPE_SIZE                   x$kqfszGV$UNDOSTAT                    X$KTUSMSTGV$VERSION                     x$versionGV$VPD_POLICY                  x$kglcursor, x$kzrtpdGV$WAITSTAT                    x$kcbwaitGV$_LOCK                       v$_lock1,x$ktadm,x$ktcxbGV$_LOCK1                      x$kdnssf, x$ksqeqGV$_SEQUENCES                  X$KGLOBV$ACCESS                       GV$ACCESSV$ACTIVE_INSTANCES             GV$ACTIVE_INSTANCESV$ACTIVE_SESS_POOL_MTH         gv$active_sess_pool_mthV$AQ1                          GV$AQ1V$ARCHIVE                      GV$ARCHIVEV$ARCHIVED_LOG                 GV$ARCHIVED_LOGV$ARCHIVE_DEST                 GV$ARCHIVE_DESTV$ARCHIVE_DEST_STATUS          GV$ARCHIVE_DEST_STATUSV$ARCHIVE_GAP                  GV$ARCHIVE_GAPV$ARCHIVE_PROCESSES            GV$ARCHIVE_PROCESSESV$BACKUP                       GV$BACKUPV$BACKUP_ASYNC_IO              gv$backup_async_ioV$BACKUP_CORRUPTION            GV$BACKUP_CORRUPTIONV$BACKUP_DATAFILE              GV$BACKUP_DATAFILEV$BACKUP_DEVICE                GV$BACKUP_DEVICEV$BACKUP_PIECE                 GV$BACKUP_PIECEV$BACKUP_REDOLOG               GV$BACKUP_REDOLOGV$BACKUP_SET                   GV$BACKUP_SETV$BACKUP_SYNC_IO               gv$backup_sync_ioV$BGPROCESS                    gv$bgprocessV$BH                           gv$bhV$BSP                          gv$bspV$BUFFER_POOL                  gv$buffer_poolV$BUFFER_POOL_STATISTICS       gv$buffer_pool_statisticsV$CIRCUIT                      GV$CIRCUITV$CLASS_CACHE_TRANSFER         gv$class_cache_transferV$CLASS_PING                   gv$class_pingV$COMPATIBILITY                GV$COMPATIBILITYV$COMPATSEG                    GV$COMPATSEGV$CONTEXT                      x$contextV$CONTROLFILE                  GV$CONTROLFILEV$CONTROLFILE_RECORD_SECTION   GV$CONTROLFILE_RECORD_SECTIONV$COPY_CORRUPTION              GV$COPY_CORRUPTIONV$CR_BLOCK_SERVER              gv$cr_block_serverV$DATABASE                     GV$DATABASEV$DATAFILE                     GV$DATAFILEV$DATAFILE_COPY                GV$DATAFILE_COPYV$DATAFILE_HEADER              GV$DATAFILE_HEADERV$DBFILE                       GV$DBFILEV$DBLINK                       GV$DBLINKV$DB_CACHE_ADVICE              gv$db_cache_adviceV$DB_OBJECT_CACHE              GV$DB_OBJECT_CACHEV$DB_PIPES                     GV$DB_PIPESV$DELETED_OBJECT               GV$DELETED_OBJECTV$DISPATCHER                   GV$DISPATCHERV$DISPATCHER_RATE              GV$DISPATCHER_RATEV$DLM_ALL_LOCKS                GV$DLM_ALL_LOCKSV$DLM_CONVERT_LOCAL            GV$DLM_CONVERT_LOCALV$DLM_CONVERT_REMOTE           GV$DLM_CONVERT_REMOTEV$DLM_LATCH                    GV$DLM_LATCHV$DLM_LOCKS                    GV$DLM_LOCKSV$DLM_MISC                     GV$DLM_MISCV$DLM_RESS                     GV$DLM_RESSV$DLM_TRAFFIC_CONTROLLER       GV$DLM_TRAFFIC_CONTROLLERV$ENABLEDPRIVS                 GV$ENABLEDPRIVSV$ENQUEUE_LOCK                 GV$ENQUEUE_LOCKV$ENQUEUE_STAT                 GV$ENQUEUE_STATV$EVENT_NAME                   gv$event_nameV$EXECUTION                    GV$EXECUTIONV$FAST_START_SERVERS           GV$FAST_START_SERVERSV$FAST_START_TRANSACTIONS      GV$FAST_START_TRANSACTIONSV$FILESTAT                     GV$FILESTATV$FILE_CACHE_TRANSFER          gv$file_cache_transferV$FILE_PING                    gv$file_pingV$FIXED_TABLE                  GV$FIXED_TABLEV$FIXED_VIEW_DEFINITION        GV$FIXED_VIEW_DEFINITIONV$GCSHVMASTER_INFO             GV$GCSHVMASTER_INFOV$GCSPFMASTER_INFO             GV$GCSPFMASTER_INFOV$GC_ELEMENT                   gv$gc_elementV$GC_ELEMENTS_WITH_COLLISIONS  gv$gc_elements_with_collisionsV$GES_BLOCKING_ENQUEUE         GV$GES_BLOCKING_ENQUEUEV$GES_ENQUEUE                  GV$GES_ENQUEUEV$GLOBALCONTEXT                gv$globalcontextV$GLOBAL_BLOCKED_LOCKS         gv$global_blocked_locksV$GLOBAL_TRANSACTION           GV$GLOBAL_TRANSACTIONV$HS_AGENT                     GV$HS_AGENTV$HS_PARAMETER                 GV$HS_PARAMETERV$HS_SESSION                   GV$HS_SESSIONV$HVMASTER_INFO                GV$HVMASTER_INFOV$INDEXED_FIXED_COLUMN         GV$INDEXED_FIXED_COLUMNV$INSTANCE                     GV$INSTANCEV$INSTANCE_RECOVERY            GV$INSTANCE_RECOVERYV$LATCH                        gv$latchV$LATCHHOLDER                  GV$LATCHHOLDERV$LATCHNAME                    gv$latchnameV$LATCH_CHILDREN               GV$LATCH_CHILDRENV$LATCH_MISSES                 GV$LATCH_MISSESV$LATCH_PARENT                 GV$LATCH_PARENTV$LIBRARYCACHE                 GV$LIBRARYCACHEV$LICENSE                      gv$licenseV$LOADCSTAT                    GV$LOADCSTATV$LOADISTAT                    GV$LOADISTATV$LOADPSTAT                    GV$LOADPSTATV$LOADTSTAT                    GV$LOADTSTATV$LOCK                         GV$LOCKV$LOCKED_OBJECT                gv$locked_objectV$LOCKS_WITH_COLLISIONS        v$bhV$LOCK_ACTIVITY                GV$LOCK_ACTIVITYV$LOCK_ELEMENT                 gv$lock_elementV$LOG                          GV$LOGV$LOGFILE                      GV$LOGFILEV$LOGHIST                      GV$LOGHISTV$LOGMNR_CALLBACK              gv$logmnr_callbackV$LOGMNR_CONTENTS              GV$LOGMNR_CONTENTSV$LOGMNR_DICTIONARY            GV$LOGMNR_DICTIONARYV$LOGMNR_LOGFILE               gv$logmnr_logfileV$LOGMNR_LOGS                  GV$LOGMNR_LOGSV$LOGMNR_PARAMETERS            GV$LOGMNR_PARAMETERSV$LOGMNR_PROCESS               gv$logmnr_processV$LOGMNR_REGION                gv$logmnr_regionV$LOGMNR_SESSION               GV$LOGMNR_SESSIONV$LOGMNR_TRANSACTION           gv$logmnr_transactionV$LOGSTDBY                     gv$logstdbyV$LOGSTDBY_APPLY               GV$LOGSTDBY_APPLYV$LOGSTDBY_COORDINATOR         GV$LOGSTDBY_COORDINATORV$LOGSTDBY_STATS               gv$logstdby_statsV$LOG_HISTORY                  GV$LOG_HISTORYV$MANAGED_STANDBY              GV$MANAGED_STANDBYV$MAX_ACTIVE_SESS_TARGET_MTH   gv$max_active_sess_target_mthV$MVREFRESH                    GV$MVREFRESHV$MYSTAT                       GV$MYSTATV$NLS_PARAMETERS               GV$NLS_PARAMETERSV$NLS_VALID_VALUES             GV$NLS_VALID_VALUESV$OBJECT_DEPENDENCY            GV$OBJECT_DEPENDENCYV$OBSOLETE_PARAMETER           GV$OBSOLETE_PARAMETERV$OFFLINE_RANGE                GV$OFFLINE_RANGEV$OPEN_CURSOR                  GV$OPEN_CURSORV$OPTION                       GV$OPTIONV$PARALLEL_DEGREE_LIMIT_MTH    gv$parallel_degree_limit_mthV$PARAMETER                    GV$PARAMETERV$PARAMETER2                   GV$PARAMETER2V$PGASTAT                      GV$PGASTATV$PQ_SESSTAT                   GV$PQ_SESSTATV$PQ_SLAVE                     GV$PQ_SLAVEV$PQ_SYSSTAT                   GV$PQ_SYSSTATV$PQ_TQSTAT                    GV$PQ_TQSTATV$PROCESS                      gv$processV$PROXY_ARCHIVEDLOG            GV$PROXY_ARCHIVEDLOGV$PROXY_DATAFILE               GV$PROXY_DATAFILEV$PWFILE_USERS                 GV$PWFILE_USERSV$PX_PROCESS                   GV$PX_PROCESSV$PX_PROCESS_SYSSTAT           GV$PX_PROCESS_SYSSTATV$PX_SESSION                   GV$PX_SESSIONV$PX_SESSTAT                   GV$PX_SESSTATV$QUEUE                        GV$QUEUEV$QUEUEING_MTH                 gv$queueing_mthV$RECOVERY_FILE_STATUS         GV$RECOVERY_FILE_STATUSV$RECOVERY_LOG                 GV$RECOVERY_LOGV$RECOVERY_PROGRESS            GV$RECOVERY_PROGRESSV$RECOVERY_STATUS              GV$RECOVERY_STATUSV$RECOVER_FILE                 GV$RECOVER_FILEV$REPLPROP                     GV$REPLPROPV$REPLQUEUE                    GV$REPLQUEUEV$REQDIST                      GV$REQDISTV$RESERVED_WORDS               GV$RESERVED_WORDSV$RESOURCE                     GV$RESOURCEV$RESOURCE_LIMIT               GV$RESOURCE_LIMITV$RESUMABLE                    GV$RESUMABLEV$RMAN_CONFIGURATION           GV$RMAN_CONFIGURATIONV$ROLLSTAT                     GV$ROLLSTATV$ROWCACHE                     gv$rowcacheV$ROWCACHE_PARENT              gv$rowcache_parentV$ROWCACHE_SUBORDINATE         gv$rowcache_subordinateV$RSRC_CONSUMER_GROUP          gv$rsrc_consumer_groupV$RSRC_CONSUMER_GROUP_CPU_MTH  gv$rsrc_consumer_group_cpu_mthV$RSRC_PLAN                    gv$rsrc_planV$RSRC_PLAN_CPU_MTH            gv$rsrc_plan_cpu_mthVSESSION                       GV$SESSIONV$SESSION_CONNECT_INFO         gv$session_connect_infoV$SESSION_CURSOR_CACHE         GV$SESSION_CURSOR_CACHEV$SESSION_EVENT                gv$session_eventV$SESSION_LONGOPS              GV$SESSION_LONGOPSV$SESSION_OBJECT_CACHE         gv$session_object_cacheV$SESSION_WAIT                 gv$session_waitV$SESSTAT                      GV$SESSTATV$SESS_IO                      GV$SESS_IOV$SGA                          GV$SGAV$SGASTAT                      GV$SGASTATV$SHARED_POOL_RESERVED         GV$SHARED_POOL_RESERVEDV$SHARED_SERVER                GV$SHARED_SERVERV$SHARED_SERVER_MONITOR        GV$SHARED_SERVER_MONITORV$SORT_SEGMENT                 GV$SORT_SEGMENTV$SORT_USAGE                   GV$SORT_USAGEV$SPPARAMETER                  GV$SPPARAMETERV$SQL                          GV$SQLV$SQLAREA                      GV$SQLAREAV$SQLTEXT                      GV$SQLTEXTV$SQLTEXT_WITH_NEWLINES        GV$SQLTEXT_WITH_NEWLINESV$SQL_BIND_DATA                GV$SQL_BIND_DATAV$SQL_BIND_METADATA            GV$SQL_BIND_METADATAV$SQL_CURSOR                   GV$SQL_CURSORV$SQL_PLAN                     GV$SQL_PLANV$SQL_REDIRECTION              GV$SQL_REDIRECTIONV$SQL_SHARED_CURSOR            GV$SQL_SHARED_CURSORV$SQL_SHARED_MEMORY            GV$SQL_SHARED_MEMORYV$SQL_WORKAREA                 GV$SQL_WORKAREAV$SQL_WORKAREA_ACTIVE          GV$SQL_WORKAREA_ACTIVEV$STANDBY_LOG                  GV$STANDBY_LOGV$STATNAME                     GV$STATNAMEV$SUBCACHE                     GV$SUBCACHEV$SYSSTAT                      GV$SYSSTATV$SYSTEM_CURSOR_CACHE          GV$SYSTEM_CURSOR_CACHEV$SYSTEM_EVENT                 gv$system_eventV$SYSTEM_PARAMETER             GV$SYSTEM_PARAMETERV$SYSTEM_PARAMETER2            GV$SYSTEM_PARAMETER2V$TABLESPACE                   GV$TABLESPACEV$TEMPFILE                     GV$TEMPFILEV$TEMPORARY_LOBS               GV$TEMPORARY_LOBSV$TEMPSTAT                     GV$TEMPSTATV$TEMP_CACHE_TRANSFER          gv$temp_cache_transferV$TEMP_EXTENT_MAP              GV$TEMP_EXTENT_MAPV$TEMP_EXTENT_POOL             GV$TEMP_EXTENT_POOLV$TEMP_PING                    gv$temp_pingV$TEMP_SPACE_HEADER            GV$TEMP_SPACE_HEADERV$THREAD                       GV$THREADV$TIMER                        GV$TIMERV$TIMEZONE_NAMES               GV$TIMEZONE_NAMESV$TRANSACTION                  gv$transactionV$TRANSACTION_ENQUEUE          GV$TRANSACTION_ENQUEUEV$TYPE_SIZE                    GV$TYPE_SIZEV$UNDOSTAT                     X$KTUSMSTV$VERSION                      GV$VERSIONV$VPD_POLICY                   GV$VPD_POLICYV$WAITSTAT                     gv$waitstatV$_LOCK                        GV$_LOCKV$_LOCK1                       GV$_LOCK1V$_SEQUENCES                   GV$_SEQUENCES

0 0
原创粉丝点击