shared pool的物理结构和逻辑结构
KSMCHCLS
COUNT(*)
free
3299
freeabl
13634
no acce
17
perm
43
R-free
31
R-freea
76
recr
18519
******************************************************HEAP DUMP heap name="sga heap" desc=0x2000002c extent sz=0x32c8 alt=108 het=32767 rec=9 flg=-126 opc=0 parent=(nil) owner=(nil) nex=(nil) xsz=0x0******************************************************HEAP DUMP heap name="sga heap(1,1)" desc=0x2001b598 extent sz=0xfc4 alt=108 het=32767 rec=9 flg=-126 opc=0 parent=(nil) owner=(nil) nex=(nil) xsz=0x1000000EXTENT 0 addr=0x9d000000 Chunk 9d000038 sz= 24 R-freeable "reserved stoppe" Chunk 9d000050 sz= 839576 R-free " " Chunk 9d0ccfe8 sz= 24 R-freeable "reserved stoppe" Chunk 9d0cd000 sz= 10274952 free " " Chunk 9da99888 sz= 796 recreate "KGL handles " latch=(nil) Chunk 9da99ba4 sz= 1036 freeable "parameter table" Chunk 9da99fb0 sz= 96 freeable "library cache " Chunk 9da9a010 sz= 228 recreate "KGL handles " latch=(nil) Chunk 9da9a0f4 sz= 96 freeable "library cache " Chunk 9da9a154 sz= 284 recreate "KQR PO " latch=0x9baaf310 Chunk 9da9a270 sz= 284 recreate "KQR PO " latch=0x9baaf310 Chunk 9da9a38c sz= 540 recreate "KQR PO " latch=0x9baaf568 Chunk 9da9a5a8 sz= 96 freeable "library cache " Chunk 9da9a608 sz= 540 recreate "KGL handles " latch=(nil) Chunk 9da9a824 sz= 540 recreate "KGL handles " latch=(nil) Chunk 9da9aa40 sz= 540 recreate "KGL handles " latch=(nil) Chunk 9da9ac5c sz= 540 recreate "KGL handles " latch=(nil) Chunk 9da9ae78 sz= 540 recreate "KGL handles " latch=(nil) ?
?
BUCKET 5944: LIBRARY OBJECT HANDLE: handle=1895899e8 mtx=0x189589b18(1) cdp=1 name=select* from sys.obj$ where obj#=:x hash=8cd0bd4dbb09ea7c3d007f1ce9b01738 timestamp=08-21-2012 10:02:35 namespace= CRSR flags=RON/KGHP/TIM/PN0/SML/KST/DBN/MTX/[120100d0] kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch#=6 hpc=0002 hlc=0002 lwt=0x189589a90[0x189589a90,0x189589a90] ltm=0x189589aa0[0x189589aa0,0x189589aa0] pwt=0x189589a58[0x189589a58,0x189589a58] ptm=0x189589a68[0x189589a68,0x189589a68] ref=0x189589ac0[0x189589ac0,0x189589ac0] lnd=0x189589ad8[0x189589ad8,0x189589ad8] LOCK OWNERS: lock user session count mode flags -------- -------- -------- ----- ---- ------------------------ 17f72e938 1852c9890 1852c9890 1 N [00] LIBRARY OBJECT: object=1786e6168 type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0 CHILDREN: size=16 child# table reference handle ------ -------- --------- -------- 0 17816fa10 17816f680 144768330 DATA BLOCKS: data# heap pointer status pins change whr ----- -------- -------- --------- ---- ------ --- 0 144773248 1786e6280 I/P/A/-/- 0 NONE 00 BUCKET 5944 total object count=1
?
?
?
?
LIBRARY OBJECT HANDLE: handle=144768330 mtx=0x144768460(0) cdp=0 namespace=CRSR flags=RON/KGHP/PN0/EXP/[10010100] kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch#=6 hpc=fffe hlc=fffe lwt=0x1447683d8[0x1447683d8,0x1447683d8] ltm=0x1447683e8[0x1447683e8,0x1447683e8] pwt=0x1447683a0[0x1447683a0,0x1447683a0] ptm=0x1447683b0[0x1447683b0,0x1447683b0] ref=0x144768408[0x17816f680,0x17816f680] lnd=0x144768420[0x144768420,0x144768420] CHILD REFERENCES: reference latch flags --------- ----- ------------------- 17816f680 11 CHL[02] LOCK OWNERS: lock user session count mode flags -------- -------- -------- ----- ---- ------------------------ 17f72f1d8 1852c9890 1852c9890 1 N [00] LIBRARY OBJECT: object=178161a10 type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0 DEPENDENCIES: count=1 size=16 dependency# table reference handle position flags ----------- -------- --------- -------- -------- ------------------- 0 17837dae8 17837d828 189addbb8 17 DEP[01] AUTHORIZATIONS: count=1 size=16 minimum entrysize=16 00000000 00000000 00020000 00000000 ACCESSES: count=1 size=16 dependency# types ----------- ----- 0 0009 SCHEMA: count=1 size=262144 00000000 DATA BLOCKS: data# heap pointer status pins change whr ----- -------- -------- --------- ---- ------ --- 0 144e55298 178161b28 I/P/A/-/- 0 NONE 00 6 1786cd5a0 16ece5dc0 I/-/A/-/E 0 NONE 00
