BUCKET 198: LIBRARY OBJECT HANDLE: handle=2c2b4ac4 name= SELECT a.statement_id, a.timestamp, a.remarks, a.operation, a.options, a.object_node, a.object_owner, a.object_name, a.object_instance, a.object_type, a.optimizer, a.search_columns, a.id, a.parent_id, a.position, a.cost, a.cardinality, a.bytes, a.other_tag, a.partition_start, a.partition_stop, a.partition_id, a.other, a.distribution , ROWID FROM plan_table a hash=60dd47a1 timestamp=08-27-2004 10:19:28 namespace=CRSR flags=RON/TIM/PN0/LRG/[10010001] kkkk-dddd-llll=0000-0001-0001 lock=0 pin=0 latch=0 lwt=2c2b4adc[2c2b4adc,2c2b4adc] ltm=2c2b4ae4[2c2b4ae4,2c2b4ae4] pwt=2c2b4af4[2c2b4af4,2c2b4af4] ptm=2c2b4b4c[2c2b4b4c,2c2b4b4c] ref=2c2b4acc[2c2b4acc,2c2b4acc] LIBRARY OBJECT: object=2c0b1430 type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0 CHILDREN: size=16 child# table reference handle ------ -------- --------- -------- 0 2c0b15ec 2c0b15b4 2c2c0d50 DATA BLOCKS: data# heap pointer status pins change ----- -------- -------- ------ ---- ------ 0 2c362290 2c0b14b4 I/-/A 0 NONE LIBRARY OBJECT HANDLE: handle=2c3675d4 name=SYS.DBMS_STANDARD hash=50748ddb timestamp=NULL namespace=BODY/TYBD flags=TIM/SML/[02000000] kkkk-dddd-llll=0000-0011-0011 lock=0 pin=0 latch=0 lwt=2c3675ec[2c3675ec,2c3675ec] ltm=2c3675f4[2c3675f4,2c3675f4] pwt=2c367604[2c367604,2c367604] ptm=2c36765c[2c36765c,2c36765c] ref=2c3675dc[2c3675dc,2c3675dc] LIBRARY OBJECT: object=2c1528e8 flags=NEX[0002] pflags= [00] status=VALD load=0 DATA BLOCKS: data# heap pointer status pins change ----- -------- -------- ------ ---- ------ 0 2c367564 2c1529cc I/-/A 0 NONE 4 2c15297c 0 -/P/- 0 NONE LIBRARY OBJECT HANDLE: handle=2c347dd8 name=select pos#,intcol#,col#,spare1 from icol$ where obj#=:1 hash=fa15ebe3 timestamp=07-28-2004 18:04:43 namespace=CRSR flags=RON/TIM/PN0/SML/[12010000] kkkk-dddd-llll=0000-0001-0001 lock=0 pin=0 latch=0 lwt=2c347df0[2c347df0,2c347df0] ltm=2c347df8[2c347df8,2c347df8] pwt=2c347e08[2c347e08,2c347e08] ptm=2c347e60[2c347e60,2c347e60] ref=2c347de0[2c347de0,2c347de0] LIBRARY OBJECT: object=2c1cd1a0 type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0 CHILDREN: size=16 child# table reference handle ------ -------- --------- -------- 0 2c1cd35c 2c1cd324 2c281678 1 2c1cd35c 2c352c50 2c0eeb8c 2 2c1cd35c 2c352c6c 2c2bb05c DATA BLOCKS: data# heap pointer status pins change ----- -------- -------- ------ ---- ------ 0 2c2e8c58 2c1cd224 I/-/A 0 NONE LIBRARY OBJECT HANDLE: handle=2c3a6484 name=SYS.TS$ hash=bb42852e timestamp=04-24-2002 00:04:15 namespace=TABL/PRCD/TYPE flags=PKP/TIM/KEP/SML/[02900000] kkkk-dddd-llll=0111-0111-0119 lock=0 pin=0 latch=0 lwt=2c3a649c[2c3a649c,2c3a649c] ltm=2c3a64a4[2c3a64a4,2c3a64a4] pwt=2c3a64b4[2c3a64b4,2c3a64b4] ptm=2c3a650c[2c3a650c,2c3a650c] ref=2c3a648c[2c0d4b14,2c09353c] LIBRARY OBJECT: object=2c3a626c type=TABL flags=EXS/LOC[0005] pflags= [00] status=VALD load=0 DATA BLOCKS: data# heap pointer status pins change ----- -------- -------- ------ ---- ------ 0 2c3a8ea4 2c3a63b0 I/P/A 0 NONE 3 2c3a5828 0 -/P/- 0 NONE 4 2c3a6300 2c3a5960 I/P/A 0 NONE 8 2c3a6360 2c3a4f00 I/P/A 0 NONE
|