ELECT DEPTNO FROM DEPT WHERE DEPTNO=10 1692266099 1997852 4.6240E+10 kksfbc [KKSCHLFSP2] Cursor Pin 000000007BD3F260 a31kd5tkdvvmm SELECT DEPTNO FROM DEPT WHERE DEPTNO=10 1692266099 1345020 1.7428E+10 kksfbc [KKSCHLFSP2] Cursor Pin 000000007C08D440 a31kd5tkdvvmm SELECT DEPTNO FROM DEPT WHERE DEPTNO=10 1692266099 1273888 1.9013E+10 kksLockDelete [KKSCHLPIN6] Cursor Pin 000000007C08D440 a31kd5tkdvvmm SELECT DEPTNO FROM DEPT WHERE DEPTNO=10 6 rows selected.
SYS@book> @ fcha 000000007BD3EC98 LOC KSMCHPTR KSMCHIDX KSMCHDUR KSMCHCOM KSMCHSIZ KSMCHCLS KSMCHTYP KSMCHPAR --- ---------------- ---------- ---------- ---------------- ---------- -------- ---------- ---------------- SGA 000000007BD3E5D0 1 1 KGLH0^64ddee73 4096 recr 4095 000000007CA31368
SYS@book> @ fcha 000000007BD3F260 LOC KSMCHPTR KSMCHIDX KSMCHDUR KSMCHCOM KSMCHSIZ KSMCHCLS KSMCHTYP KSMCHPAR --- ---------------- ---------- ---------- ---------------- ---------- -------- ---------- ---------------- SGA 000000007BD3E5D0 1 1 KGLH0^64ddee73 4096 recr 4095 000000007CA31368
SYS@book> @ fcha 000000007C08D440 LOC KSMCHPTR KSMCHIDX KSMCHDUR KSMCHCOM KSMCHSIZ KSMCHCLS KSMCHTYP KSMCHPAR --- ---------------- ---------- ---------- ---------------- ---------- -------- ---------- ---------------- SGA 000000007C08D168 1 1 KGLH0^64ddee73 4096 freeabl 0 000000007CA31368
--//3个子光标的KSMCHPAR=000000007CA31368.不过位置不一样,1个在KSMCHCLS=recr.另外1个在KSMCHCLS=freeabl.
3.对比共享池的情况看看. select a.* from x$ksmsp a where a.ksmchpar=hextoraw('000000007CA31368') ADDR |