SELECT?T1.owner,T1.object_name,T1.object_id
FROM?DBA_OBJECTS T1
WHERE?T1.object_name =?'PK_EMP'
AND?T1.owner =?'SCOTT'
AND?T1.object_type =?'INDEX';
?
OWNER???? OBJECT_NAME???? OBJECT_ID
SCOTT ? ? ?PK_EMP ? ? ? ? ? ? ? ? ?73197
SCOTT ? ? ?PK_EMP ? ? ? ? ? ? ? ? ?73197
?
通过alter session set events ?'immediate trace name ?treedump level?index_object_id' ? --通过查询去获取index_object_id的值
?
ALTER?SESSION?SET?EVENTS?'IMMEDIATE TRACE NAME TREEDUMP LEVEL 73197';
通过上面的events可以获取叶子节点的文件号跟块号
<