本文共 856 字,大约阅读时间需要 2 分钟。
select id,rowid,
dbms_rowid.rowid_object(rowid) object#, dbms_rowid.rowid_relative_fno(rowid) file#, dbms_rowid.rowid_block_number(rowid) block#, dbms_rowid.rowid_row_number(rowid) row# from scott.t where id in(1,300000); ID ROWID OBJECT# FILE# BLOCK# ROW#---------- ------------------ ---------- ---------- ---------- ---------- 1 AAAWb0AAEAACvPCAAp 91892 4 717762 41 300000 AAAWb0AAEAACvN8AAw 91892 4 717692 48select
t.segment_name,t.partition_name,t.BLOCK_ID,(t.BLOCKS + t.BLOCK_ID -1) "MAX_BLOCK_ID"from sys.dba_extents t,dba_tab_partitions pwhere t.PARTITION_NAME=p.partition_name and p.TABLE_OWNER='SCOTT' and p.table_name='T';SEGMENT_NA PARTITION_NAME BLOCK_ID MAX_BLOCK_ID---------- ------------------------------ ---------- ------------T SYS_P109 714368 715391T SYS_P110 715392 716415T SYS_P111 716416 717439 T SYS_P112 717440 718463
转载地址:http://sqlyz.baihongyu.com/