【X$VIEW】X$部分视频说明

x$bh [B]uffer [H]eader

缓冲区头信息。通过连接x$bh和v$latch_children可以找到某个latch所保护的具体的 block select obj, dbarfil, dbablk from x$bh a, v$latch_children b where a.hladdr = b.addr

也可以找出同一个block在data buffer cache中存在多少个副本（多版本一致性读） select dbarfil, dbablk, count(*) from x$bh group by dbarfil, dbablk having count(*) > 2

注意:x$bh.id=dba_objects.data_object_id而不是dba_objects.object_id

x$k2gte [K]ernel [2]-phase commit [G]lobal [T]ransaction [E]ntry

x$k2gte.k2gtdses = v$session.saddr x$k2gte.k2gtdxcb = v$transcation.addr

x$kcbwait [K]ernel [C]ache [B]uffer [WAIT]

x$kcbfwait [K]ernel [C]ache [B]lock [F]ile [WAIT]

select count, time, name from v$datafile df, x$kcbfwait fw where fw.indx+1 = df.file#

x$kcbwds [K]ernel [C]ache [B]uffer [W]orking [D]ata [S]et

x$kcccf[K]ernel [C]ache [C]ontrolfile management [C]ontrol[F]ile

下面的SQL可以获得控制文件的block size select cfnam, (cffsz+1)*cfbsz from x$kcccf. cfbsz

x$kcccp [K]ernel [C]ache [C]ontrolfile [C]heckpoint [P]rogress

x$kccdi [K]ernel [C]ache [C]ontrolfile management [D]atabase [i]nformation

x$kccle [K]ernel [C]ache [C]ontrolfile [L]ogfile [S]tatistics

x$kcfio [K]ernel [C]ache [F]ile [I]/[O]

x$kclfh [K]ernel [C]ache [L]ock [F]ile [H]eader

x$kclfi [K]ernel [C]ache [L]ock [F]ile [I]ndex

x$kcluh [K]ernel [C]ache [L]ock [U]ndo [H]eader

x$kclui [K]ernel [C]ache [L]ock [U]ndo [I]ndex

x$kcrfx [K]ernel [c]ache [R]edo [F]ile [C]ontext

x$kdxst [K]ernel [D]ata inde[X] [ST]atus

index_stats的基表

x$kdxhs [K]ernel [D]ata inde[X] [H]i[S]togram

index_histogram的基表

x$kghlu [K]ernel [G]eneric [H]eap [L]R[U]s

x$kglcursor [K]ernel [G]eneric [L]ibrary cache [CURSOR]

v$sql和v$sqlarea的基表

x$kgllk [K]ernel [G]eneric [L]ibrary cache [L]oc[K]

dba_kgllock的基表

x$kglob [K]ernel [G]eneric [L]ibrary cache [OB]ject

x$kglob.kglhdadr = v$session_wait.p1raw

x$kglpn [K]ernel [G]eneric [L]ibrary [P]i[N]

dba_kgllock的基表

x$kglst [K]ernel [G]eneric [L]ibrary cache [ST]atus

x$kqfco [K]ernel [Q]uery [F]ixed table [CO]lumns

x$kqfta [K]ernel [Q]uery [F]ixed [TA]ble

x$kqfco.kqfcotab=x$kqfta.indx

x$kqfdt [k]ernel [Q]uery [F]ixed [D]erived [T]able

x$kqfp [K]ernel [Q]uery [F]ixed [P]rocudure

disk_and_fixed_objects的基表

x$kqfsz [K]ernel [Q]uery [F]ixed [S]i[Z]e

x$kqfvi[K]ernel [Q]uery [F]ixed [VI]ew

x$kqfvt [K]ernel [Q]uery [F]ixed [V]iew [T]able

x$fsled [K]ernel [S]ervice [E]vent [D]efinition

x$kslei [K]ernel [S]ervice [E]vent for [I]nstance

x$ksles [K]ernel [S]ervice [E]vent for [S]ession

x$ksmfs [K]ernel [S]ervice ]M]emory [F]ixed [S]GA

x$ksmfsv [K]ernel [S]ervice ]M]emory [F]ixed [S]GA variables

x$ksmjs [K]ernel [S]ervice ]M]emory [J]ava pool [S]ummary

x$ksmlru [K]ernel [S]ervice ]M]emory [LRU]

访问该表会清空该表的内容

x$ksmls [K]ernel [S]ervice ]M]emory [L]arge pool [S]ummary

x$ksmmem [K]ernel [S]ervice [MEM]ory

整个SGA的内存映射。下面的SQL可以查询数据库的版本 select ksmmmval from x$ksmmem where indx = 2 （64位的oracle可能为1）

x$ksmpp [K]ernel [S]ervice [M]emory [P]GA hea[P]

x$ksmsd [K]ernel [S]ervice [M]emory [S]GA [D]efinition

x$ksmsp [K]ernel [S]ervice [M]emory [S]GA] hea[P]

x$ksmspr [K]ernel [S]ervice [M]emory [S]hared [P]ool [R]eserved

x$ksmss [K]ernel [S]ervice [M]emory [S]hared pool [S]ummary

x$ksmup [K]ernel [S]ervice [M]emory [U]GA hea[P]

x$ksppcv [K]ernel [S]ervice [P]arameter [C]urrent] (session) [V]alue

x$ksppi [K]ernel [S]ervice [P]arameter [P]arameter [I]nfo

v$parameter, v$system_parameter and v$system_parameter2的基表。通过关联x$ksppcv和x$ksppi可以查询隐含参数 select a.ksppinm Parameter, a.ksppdesc Description, b.ksppstvl "Session Value", c.ksppstvl "Instance Value" from x$ksppi a, x$ksppcv b, x$ksppsv c where a.indx = b.indx and a.indx = c.indx and a.ksppinm like '_%' escape '' order by 1

x$ksppsv [K]ernel [S]ervice [P]arameter [S]ystem [V]alue

x$ksqeq [K]ernel [S]ervice en[Q]ueue [E]n[Q]ueue

x$ksqrs [K]ernel [S]ervice en[Q]ueue [RE]source

x$ksqst [K]ernel [S]ervice en[Q]ueue [S]tatistics [T]ypes

x$ksulv [K]ernel [S]ervice [U]ser [L]ocale [V]alue

x$ksulop [K]ernel [S]ervice [U]ser [L]ong [OP]eration

x$ksupr [K]ernel [S]ervice [U]ser [PR]ocess

x$ksuse [K]ernel [S]ervice [U]ser [SE]ssion

x$ktcxb [K]ernel [T]ransaction [C]ontrol object

v$transaction的基表

x$ktfbfe [K]ernel [T]ransaction [F]ile [B]itmap [F]ree [E]xtent

LMT文件头的可用extent位图（相当于DMT的fet$）。dba_free_space的基表

x$ktfbhc [K]ernel [T]ransaction [F]ile [B]itmap ??

每个datafile一条可用空间的记录

x$ktfbue [K]ernel [T]ransaction [F]ile [B]itmap [U]sed [E]xtent

LMT文件头的已用extent位图（相当于DMT的uet$）

x$ktuxe [K]ernel [T]ransaction [U]ndo transaction [E]ntry

9i之前，常用下面的语句获得当前SCN select max(ktuxescnw * power(2, 32) + ktuxescnb) from x$ktuxe

x$kxfpsds [K]ernel e[X]ecution [F]ast [P]rocess [S]lave [D]equeue [S]tatistics

x$kzsprv [K]ernel security [S]ession [PR]i[V]ilege

v$enabledprivilege的基表（v$enabledprivilege是session_privs的基表）

x$kzsro [K]ernel security [S]ession [RO]le

x$le [L]ock [E]lement

select a.* from x$bh a, x$le b where a.le_addr = b.addr

x$le_stat [L]ock [E]lement [STAT]us

x$message (background process)[MESSAGE]s

x$trace 从9i开始，x$trace记录了跟踪事件的信息。下面的SQL显示了那些跟踪事件已经开启： select event, count(*) from x$trace group by event

x$uganco [U]ser [G]lobal [A]rea [N]etwork [CO]nnection

v$dblink的基表

x$kvit