[k]ernel layer
[2]-phase commit
[g]lobal [t]ransaction [e]ntry
x$k2gte - current 2pc tx
x$k2gte2 - current 2pc tx
[c]ache layer
[b]uffer management
buffer [h]ash
x$bh - hash table
buffer lru statistics
x$kcbcbh - [c]urrent [b]uffers (buckets) - lru_statistics
x$kcbrbh - [r]ecent [b]uffers (buckets) - lru_extended
buffer [wait]s
x$kcbwait - waits by block class
x$kcbfwait - waits by file
[w]orking sets - 7.3 or higher
x$kcbwds - set [d]escriptors
[c]ontrol file management
[c]ontrol [f]ile list - 7.0.16 or higher
x$kcccf - control file names & status
[d]atabase [i]nformation
x$kccdi - database information
data [f]iles
x$kccfe - file [e]ntries ( from control file )
x$kccfn - [f]ile [n]ames
[l]og files
x$kccle - log file [e]ntries
x$kcclh - log [h]istory ( archive entries )
thread information
x$kccrt - [r]edo [t]hread information
[f]ile management
x$kcfio - file [io] statistics
[l]ock manager component ( lck )
[h]ash and bucket tables - 7.0.15 to 7.1.1, and 7.2.0 or higher
x$kclfh - file [h]ash table
x$kclfi - file bucket table
x$le - lock [e]lements
x$le_stat - lock conversion [stat]istics
x$kclfx - lock element [f]ree list statistics - 7.3 or higher
x$kclls - per lck free list statistics - 7.3 or higher
x$kclqn - [n]ame (hash) table statistics - 7.3 or higher
[r]edo component
[m]edia recovery - kcra.h - 7.3 or higher
x$kcrmf - [f]ile context
x$kcrmt - [t]hread context
x$kcrmx - recovery conte[x]t
[f]ile read
x$kcrfx - file read conte[x]t - 7.3 or higher
reco[v]ery component
[f]ile [h]eaders
x$kcvfh - all file headers
x$kcvfhmrr - files with [m]edia [r]ecovery [r]equired
x$kcvfhonl - [onl]ine file headers
[k]ompatibility management - 7.1.1 or higher
x$kckce - [c]ompatibility segment [e]ntries
x$kckty - compatibility [ty]pes
x$kckfm - compatibility [f]or[m]ats ( index into x$kckce )
[d]ata layer
sequence [n]umber component
x$kdnce - sequence [c]ache [e]ntries - 7.2 or lower
[s]equence enqueues - common area for enqueue objects
x$kdnssc - [c]ache enqueue objects - 7.2 or lower
x$kdnssf - [f]lush enqueue objects - 7.2 or lower
x$kdnst - cache [st]atistics - 7.2 or lower
inde[x] block component
x$kdxhs - index [h]i[s]togram
x$kdxst - index [st]atistics
[g]eneric layer
[h]eap manager
x$kghlu - state (summary) of [l]r[u] heap(s) - defined in ksmh.h
[i]nstantiation manager
[c]ursor [c]ache
x$kgicc - session statistics - defined in kqlf.h
x$kgics - system wide statistics - defined in kqlf.h
[l]ibrary cache manager ( defined and mapped from kqlf )
bind variables
x$kksbv - library object [b]ind [v]ariables
object cache
x$kglob - all [ob]jects
x$kgltable - filter for [table]s
x$kglbody - filter for [body] ( packages )
x$kgltrigger - filter for [trigger]s
x$kglindex - filter for [index]es
x$kglcluster - filter for [cluster]s
x$kglcursor - filter for [cursor]s
cache dependency
x$kgldp - object [d]e[p]endency table
x$kglrd - [r]ead only [d]ependency table - 7.3 or higher
object locks
x$kgllk - object [l]oc[k]s
object names
x$kglna - object [na]mes (sql text)
x$kglna1 - object [na]mes (sql text) with newlines - 7.2.0 or higher
object pins
x$kglpn - object [p]i[n]s
cache statistics
x$kglst - library cache [st]atistics
translation table
x$kgltr - address [tr]anslation
access table
x$kglxs - object access table
authorization table - 7.1.5 or higher
x$kglau - object authorization table
latch cleanup - 7.0.15 or higher
x$kgllc - [l]atch [c]leanup for cache/pin latches
[k]ompile layer
[s]hared objects
x$kksai - cursor [a]llocation [i]nformation - 7.3.2 or higher
[l]oader
[l]ibrary
x$kllcnt - [c]o[nt]rol statistics
x$klltab - [tab]le statistics
[m]ulti-threaded layer
[c]ircuit component
x$kmcqs - current [q]ueue [s]tate
x$kmcvc - [v]irtual [c]ircuit state
[m]onitor server/dispatcher
[d]ispatcher
x$kmmdi - [d]ispatcher [i]nfo (status)
x$kmmdp - [d]ispatcher config ( [p]rotocol info )
[s]erver
x$kmmsi - [s]erver [i]nfo ( status )
x$kmmsg - [sg]a info ( global statistics)
x$kmmrd - [r]equest timing [d]istributions
s[q]l version and option layer
kernel [v]ersions
x$version - library versions
kernel [o]ptions - 7.1.3 or higher
x$option - server options
[q]uery layer
[d]ictionary cache management
x$kqdpg - [pg]a row cache cursor statistics
[f]ixed tables/views management
x$kqfco - table [co]lumn definitions
x$kqfdt - [d]erived [t]ables
x$kqfsz - kernel data structure type [s]i[z]es
x$kqfta - fixed [ta]bles
x$kqfvi - fixed [vi]ews
x$kqfvt - [v]iew [t]ext definition - 7.2.0 or higher
[r]ow cache management
x$kqrst - cache [st]atistics
x$kqrpd - [p]arent cache [d]efinition - 7.1.5 or higher
x$kqrsd - [s]ubordinate cache [d]efinition - 7.1.5 or higher
[s]ervice layer
[b]ackground management
[d]etached process
x$ksbdd - detached process [d]efinition (info)
x$ksbdp - detached [p]rocess descriptor (name)
x$messages - background message table
[i]nstance [m]anagement - 7.3 or higher
x$ksimat - instance [at]tributes
x$ksimav - [a]ttribute [v]alues for all instances
x$ksimsi - [s]erial and [i]nstance numbers
[l]ock management
[e]vent waits
x$ksled - event [d]escriptors
x$kslei - [i]nstance wide statistics since startup
x$ksles - current [s]ession statistics
[l]atches
x$kslld - latch [d]escriptor (name)
x$ksllt - latch statistics [ + child latches @ 7.3 or higher ]
x$ksllw - latch context ( [w]here ) descriptors - 7.3 or higher
x$kslpo - latch [po]st statistics - 7.3 or higher
x$kslwsc- no[w]ait and [s]leep [c]ount stats by context -7.3 or higher
[m]emory management
[c]ontext areas
x$ksmcx - e[x]tended statistics on usage - 7.3.1 or lower
heap areas
x$ksmsp - sga hea[p]
x$ksmpp - [p]ga hea[p] - 7.3.2 and above
x$ksmup - [u]ga hea[p] - 7.3.2 and above
x$ksmhp - any [h]ea[p] - 7.3.2 and above
x$ksmspr- [s]hared [p]ool [r]eserved list - 7.1.5 or higher
[l]east recently used shared pool chunks
x$ksmlru - lr[u] flushes from the shared pool
[s]ga objects
x$ksmsd - size [d]efinition for fixed/variable summary
x$ksmss - statistics (lengths) of sga objects
sga [mem]ory
x$ksmmem - map of the entire sga - 7.2.0 or higher
x$ksmfsv - addresses of [f]ixed [s]ga [v]ariables - 7.2.1 or higher
[p]arameter component
x$ksppi - [p]arameter [i]nfo ( names )
x$ksppcv - [c]urrent session [v]alues - 7.3.2 or above
x$ksppsv - [s]ystem [v]alues - 7.3.2 or above
en[q]ueue management
x$ksqdn - global [d]atabase [n]ame
x$ksqeq - [e]n[q]ueue object
x$ksqrs - enqueue [r]e[s]ource
x$ksqst - enqueue [s]tatistics by [t]ype
[u]ser management
[c]ost
x$ksucf - cost [f]unction (resource limit)
[l]icence
x$ksull - licence [l]imits
[l]anguage manager
x$nls_parameters - nls parameters
x$ksulv - nls [v]alid values - 7.1.2 or higher
[my] [st]atistics
x$ksumysta - [my] [st]atisics (current session)
[p]rocess info
x$ksupl - process (resource) [l]imits
x$ksuprlat - [lat]ch holder
x$ksupr - process object
[r]esource
x$ksuru - resource [u]sage
[s]tatistics
x$ksusd - [d]escriptors (statistic names)
x$ksusgsta - [g]lobal [st]atistics
[se]ssions
x$ksusecst - session status for events
x$ksusesta - session [sta]tistics
x$ksusecon - [con]nection authentication - 7.2.1 or higher
x$ksuse - [se]ssion info
x$ksusio - [s]ystem [io] statistics per session
[t]imer
x$ksutm - ti[m]e in 1/100th seconds
instance [x]
x$ksuxsinst - [inst]ance state
[t]race management
x$trace - current traced events
x$traces - all possible traces
x$kstex - code [ex]ecution - 7.2.1 or higher
e[x]ecution management
device/node [a]ffinity - 7.3.2 and above
x$ksxafa - current file/node affinity
[t]ransaction layer
table [a]ccess [d]efinition
x$ktadm - d[m]l lock
[c]ontrol component
x$ktcxb - transaction o[b]ject
[s]or[t] segments - 7.3 or higher
x$ktstssd - [s]ort [s]egment [d]escriptor - per tablespace statistics
[t]ablespace
x$kttvs - [v]alid [s]aveundo
[u]ndo
x$kturd - inuse [d]escriptors
x$ktuxe - transaction [e]ntry (table) - 7.3.2 or above
performance layer [v] - 7.0.16 or higher
[i]nformation tables
x$kvii - [i]nitialisation instance parameters
x$kvis - [s]izes of structure elements
x$kvit - [t]ransitory instance parameters
security layer [z]
[d]ictionary component
x$kzdos - [os] roles
[s]ecurity state
x$kzspr - enabled [pr]ivileges
x$kzsro - enabled [ro]les
[r]emote logins - 7.1.1 or higher
x$kzsrt - [r]emote password file [t]able entries
e[x]ecution layer
parallel query (execute [f]ast) - 7.1.1 or higher
[p]rocess and queue manager
statistics - 7.1.3 or higher
x$kxfpys - s[ys]tem statistics
x$kxfpdp - [d]etached [p]rocess (slave) statistics
x$kxfqsrow - table [q]ueue statistics - 7.3.2 or higher
[c]oordinator component
x$kxfpcst - query [st]atistics
x$kxfpcms - [m]essage [s]tatistics
x$kxfpcds - [d]equeue [s]tatistics
[s]lave component
x$kxfpsst - query [st]atistics
x$kxfpsms - [m]essage [s]tatistics
x$kxfpcds - [d]equeue [s]tatistics
[s]hared cursor
x$kxsbd - [b]ind [d]ata - 7.3.2 and above
x$kxscc - sql [c]ursor [c]ache data - 7.3.2 and above
[n]etwork layer - 7.0.15 or higher
network [co]nnections
x$uganco - current [n]etwork [co]nnections
[2]-phase commit
[g]lobal [t]ransaction [e]ntry
x$k2gte - current 2pc tx
x$k2gte2 - current 2pc tx
[c]ache layer
[b]uffer management
buffer [h]ash
x$bh - hash table
buffer lru statistics
x$kcbcbh - [c]urrent [b]uffers (buckets) - lru_statistics
x$kcbrbh - [r]ecent [b]uffers (buckets) - lru_extended
buffer [wait]s
x$kcbwait - waits by block class
x$kcbfwait - waits by file
[w]orking sets - 7.3 or higher
x$kcbwds - set [d]escriptors
[c]ontrol file management
[c]ontrol [f]ile list - 7.0.16 or higher
x$kcccf - control file names & status
[d]atabase [i]nformation
x$kccdi - database information
data [f]iles
x$kccfe - file [e]ntries ( from control file )
x$kccfn - [f]ile [n]ames
[l]og files
x$kccle - log file [e]ntries
x$kcclh - log [h]istory ( archive entries )
thread information
x$kccrt - [r]edo [t]hread information
[f]ile management
x$kcfio - file [io] statistics
[l]ock manager component ( lck )
[h]ash and bucket tables - 7.0.15 to 7.1.1, and 7.2.0 or higher
x$kclfh - file [h]ash table
x$kclfi - file bucket table
x$le - lock [e]lements
x$le_stat - lock conversion [stat]istics
x$kclfx - lock element [f]ree list statistics - 7.3 or higher
x$kclls - per lck free list statistics - 7.3 or higher
x$kclqn - [n]ame (hash) table statistics - 7.3 or higher
[r]edo component
[m]edia recovery - kcra.h - 7.3 or higher
x$kcrmf - [f]ile context
x$kcrmt - [t]hread context
x$kcrmx - recovery conte[x]t
[f]ile read
x$kcrfx - file read conte[x]t - 7.3 or higher
reco[v]ery component
[f]ile [h]eaders
x$kcvfh - all file headers
x$kcvfhmrr - files with [m]edia [r]ecovery [r]equired
x$kcvfhonl - [onl]ine file headers
[k]ompatibility management - 7.1.1 or higher
x$kckce - [c]ompatibility segment [e]ntries
x$kckty - compatibility [ty]pes
x$kckfm - compatibility [f]or[m]ats ( index into x$kckce )
[d]ata layer
sequence [n]umber component
x$kdnce - sequence [c]ache [e]ntries - 7.2 or lower
[s]equence enqueues - common area for enqueue objects
x$kdnssc - [c]ache enqueue objects - 7.2 or lower
x$kdnssf - [f]lush enqueue objects - 7.2 or lower
x$kdnst - cache [st]atistics - 7.2 or lower
inde[x] block component
x$kdxhs - index [h]i[s]togram
x$kdxst - index [st]atistics
[g]eneric layer
[h]eap manager
x$kghlu - state (summary) of [l]r[u] heap(s) - defined in ksmh.h
[i]nstantiation manager
[c]ursor [c]ache
x$kgicc - session statistics - defined in kqlf.h
x$kgics - system wide statistics - defined in kqlf.h
[l]ibrary cache manager ( defined and mapped from kqlf )
bind variables
x$kksbv - library object [b]ind [v]ariables
object cache
x$kglob - all [ob]jects
x$kgltable - filter for [table]s
x$kglbody - filter for [body] ( packages )
x$kgltrigger - filter for [trigger]s
x$kglindex - filter for [index]es
x$kglcluster - filter for [cluster]s
x$kglcursor - filter for [cursor]s
cache dependency
x$kgldp - object [d]e[p]endency table
x$kglrd - [r]ead only [d]ependency table - 7.3 or higher
object locks
x$kgllk - object [l]oc[k]s
object names
x$kglna - object [na]mes (sql text)
x$kglna1 - object [na]mes (sql text) with newlines - 7.2.0 or higher
object pins
x$kglpn - object [p]i[n]s
cache statistics
x$kglst - library cache [st]atistics
translation table
x$kgltr - address [tr]anslation
access table
x$kglxs - object access table
authorization table - 7.1.5 or higher
x$kglau - object authorization table
latch cleanup - 7.0.15 or higher
x$kgllc - [l]atch [c]leanup for cache/pin latches
[k]ompile layer
[s]hared objects
x$kksai - cursor [a]llocation [i]nformation - 7.3.2 or higher
[l]oader
[l]ibrary
x$kllcnt - [c]o[nt]rol statistics
x$klltab - [tab]le statistics
[m]ulti-threaded layer
[c]ircuit component
x$kmcqs - current [q]ueue [s]tate
x$kmcvc - [v]irtual [c]ircuit state
[m]onitor server/dispatcher
[d]ispatcher
x$kmmdi - [d]ispatcher [i]nfo (status)
x$kmmdp - [d]ispatcher config ( [p]rotocol info )
[s]erver
x$kmmsi - [s]erver [i]nfo ( status )
x$kmmsg - [sg]a info ( global statistics)
x$kmmrd - [r]equest timing [d]istributions
s[q]l version and option layer
kernel [v]ersions
x$version - library versions
kernel [o]ptions - 7.1.3 or higher
x$option - server options
[q]uery layer
[d]ictionary cache management
x$kqdpg - [pg]a row cache cursor statistics
[f]ixed tables/views management
x$kqfco - table [co]lumn definitions
x$kqfdt - [d]erived [t]ables
x$kqfsz - kernel data structure type [s]i[z]es
x$kqfta - fixed [ta]bles
x$kqfvi - fixed [vi]ews
x$kqfvt - [v]iew [t]ext definition - 7.2.0 or higher
[r]ow cache management
x$kqrst - cache [st]atistics
x$kqrpd - [p]arent cache [d]efinition - 7.1.5 or higher
x$kqrsd - [s]ubordinate cache [d]efinition - 7.1.5 or higher
[s]ervice layer
[b]ackground management
[d]etached process
x$ksbdd - detached process [d]efinition (info)
x$ksbdp - detached [p]rocess descriptor (name)
x$messages - background message table
[i]nstance [m]anagement - 7.3 or higher
x$ksimat - instance [at]tributes
x$ksimav - [a]ttribute [v]alues for all instances
x$ksimsi - [s]erial and [i]nstance numbers
[l]ock management
[e]vent waits
x$ksled - event [d]escriptors
x$kslei - [i]nstance wide statistics since startup
x$ksles - current [s]ession statistics
[l]atches
x$kslld - latch [d]escriptor (name)
x$ksllt - latch statistics [ + child latches @ 7.3 or higher ]
x$ksllw - latch context ( [w]here ) descriptors - 7.3 or higher
x$kslpo - latch [po]st statistics - 7.3 or higher
x$kslwsc- no[w]ait and [s]leep [c]ount stats by context -7.3 or higher
[m]emory management
[c]ontext areas
x$ksmcx - e[x]tended statistics on usage - 7.3.1 or lower
heap areas
x$ksmsp - sga hea[p]
x$ksmpp - [p]ga hea[p] - 7.3.2 and above
x$ksmup - [u]ga hea[p] - 7.3.2 and above
x$ksmhp - any [h]ea[p] - 7.3.2 and above
x$ksmspr- [s]hared [p]ool [r]eserved list - 7.1.5 or higher
[l]east recently used shared pool chunks
x$ksmlru - lr[u] flushes from the shared pool
[s]ga objects
x$ksmsd - size [d]efinition for fixed/variable summary
x$ksmss - statistics (lengths) of sga objects
sga [mem]ory
x$ksmmem - map of the entire sga - 7.2.0 or higher
x$ksmfsv - addresses of [f]ixed [s]ga [v]ariables - 7.2.1 or higher
[p]arameter component
x$ksppi - [p]arameter [i]nfo ( names )
x$ksppcv - [c]urrent session [v]alues - 7.3.2 or above
x$ksppsv - [s]ystem [v]alues - 7.3.2 or above
en[q]ueue management
x$ksqdn - global [d]atabase [n]ame
x$ksqeq - [e]n[q]ueue object
x$ksqrs - enqueue [r]e[s]ource
x$ksqst - enqueue [s]tatistics by [t]ype
[u]ser management
[c]ost
x$ksucf - cost [f]unction (resource limit)
[l]icence
x$ksull - licence [l]imits
[l]anguage manager
x$nls_parameters - nls parameters
x$ksulv - nls [v]alid values - 7.1.2 or higher
[my] [st]atistics
x$ksumysta - [my] [st]atisics (current session)
[p]rocess info
x$ksupl - process (resource) [l]imits
x$ksuprlat - [lat]ch holder
x$ksupr - process object
[r]esource
x$ksuru - resource [u]sage
[s]tatistics
x$ksusd - [d]escriptors (statistic names)
x$ksusgsta - [g]lobal [st]atistics
[se]ssions
x$ksusecst - session status for events
x$ksusesta - session [sta]tistics
x$ksusecon - [con]nection authentication - 7.2.1 or higher
x$ksuse - [se]ssion info
x$ksusio - [s]ystem [io] statistics per session
[t]imer
x$ksutm - ti[m]e in 1/100th seconds
instance [x]
x$ksuxsinst - [inst]ance state
[t]race management
x$trace - current traced events
x$traces - all possible traces
x$kstex - code [ex]ecution - 7.2.1 or higher
e[x]ecution management
device/node [a]ffinity - 7.3.2 and above
x$ksxafa - current file/node affinity
[t]ransaction layer
table [a]ccess [d]efinition
x$ktadm - d[m]l lock
[c]ontrol component
x$ktcxb - transaction o[b]ject
[s]or[t] segments - 7.3 or higher
x$ktstssd - [s]ort [s]egment [d]escriptor - per tablespace statistics
[t]ablespace
x$kttvs - [v]alid [s]aveundo
[u]ndo
x$kturd - inuse [d]escriptors
x$ktuxe - transaction [e]ntry (table) - 7.3.2 or above
performance layer [v] - 7.0.16 or higher
[i]nformation tables
x$kvii - [i]nitialisation instance parameters
x$kvis - [s]izes of structure elements
x$kvit - [t]ransitory instance parameters
security layer [z]
[d]ictionary component
x$kzdos - [os] roles
[s]ecurity state
x$kzspr - enabled [pr]ivileges
x$kzsro - enabled [ro]les
[r]emote logins - 7.1.1 or higher
x$kzsrt - [r]emote password file [t]able entries
e[x]ecution layer
parallel query (execute [f]ast) - 7.1.1 or higher
[p]rocess and queue manager
statistics - 7.1.3 or higher
x$kxfpys - s[ys]tem statistics
x$kxfpdp - [d]etached [p]rocess (slave) statistics
x$kxfqsrow - table [q]ueue statistics - 7.3.2 or higher
[c]oordinator component
x$kxfpcst - query [st]atistics
x$kxfpcms - [m]essage [s]tatistics
x$kxfpcds - [d]equeue [s]tatistics
[s]lave component
x$kxfpsst - query [st]atistics
x$kxfpsms - [m]essage [s]tatistics
x$kxfpcds - [d]equeue [s]tatistics
[s]hared cursor
x$kxsbd - [b]ind [d]ata - 7.3.2 and above
x$kxscc - sql [c]ursor [c]ache data - 7.3.2 and above
[n]etwork layer - 7.0.15 or higher
network [co]nnections
x$uganco - current [n]etwork [co]nnections
扫一扫
1206
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
