|
|
m14的结构和我的理解有点不太一样~，我从eygle上拷贝下面的内容：其中很详细的记录了children 相关信息，和大师给的图示好像不太一样。m14图示的子游标是放在heap data block 0上的。
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 |
|
楼主: vage
IP卡
狗仔卡
发表于 2013-9-2 23:05
显身卡
