全部博文
-
编辑 删除
Oracle Internal X$Tables
Oracle Internal X$Tablesx$bh Buffer Hashx$kcbsw kernel cache, buffer statistics whyNote:34405.1 (select kcbwhdes, why0+why1+why2 "Gets", "OTHER_WAIT" from x$kcbsw s, x$kcbwh w where s.indx=w...
-
编辑 删除
x$视图介绍
x$bh[B]uffer [H]eader缓冲区头信息。通过连接x$bh和v$latch_children可以找到某个latch所保护的具体的blockselect obj, dbarfil, dbablk from x$bh a, v$latch_children b where a.hladdr = b.addr 也可以找出同...
