log buffer space 1 0.14 0.14
log file sync 1 0.02 0.02
SQL*Net message to client 1 0.00 0.00
SQL*Net message from client 1 0.00 0.00
selectindex_name,table_name
fromuser_indexes
wheretable_name in( 'HEAP_TABLE','ORG_INDEX_TABLE')
INDEX_NAME
TABLE_NAME
SYS_C0016433
HEAP_TABLE
SYS_IOT_TOP_84235
ORG_INDEX_TABLE
begin
scott.show_space(p_segname =>'HEAP_TABLE');
end;
Unformatted Blocks .....................0
FS1 Blocks (0-25) ......................0
FS2 Blocks (25-50) .....................0
FS3 Blocks (50-75) .....................1
FS4 Blocks (75-100).....................52
Full Blocks ............................443
Total Blocks............................512
Total Bytes.............................4194304
Total MBytes............................4
Unused Blocks...........................0
Unused Bytes............................0
Last Used Ext FileId....................4
Last Used Ext BlockId...................441609
Last Used Block.........................128
select * from user_tables where table_name in( 'HEAP_TABLE','ORG_INDEX_TABLE')
我们看不到块的个数
begin
scott.show_space(p_segname =>'ORG_INDEX_TABLE');
end;
出现错误
怎么看着个表的大小？
select * from user_segments where segment_name='ORG_INDEX_TABLE'
也看不到数据
analyze index SYS_IOT_TOP_84235 validate structure
HEIGHT
2
BLOCKS
512
NAME
SYS_IOT_TOP_84235
PARTITION_NAME
LF_ROWS
70231
LF_BLKS
440
LF_ROWS_LEN
3350295
LF_BLK_LEN
8000
BR_ROWS
439
BR_BLKS
1
BR_ROWS_LEN
4757
BR_BLK_LEN
8032
DEL_LF_ROWS
0
DEL_LF_ROWS_LEN
0
DISTINCT_KEYS
70231
MOST_REPEATED_KEY
1
BTREE_SPACE
3528032
USED_SPACE
3355052
PCT_USED
96
ROWS_PER_KEY
1
BLKS_GETS_PER_ACCESS
3
PRE_ROWS
0
PRE_ROWS_LEN
0
OPT_CMPR_COUNT
0
OPT_CMPR_PCTSAVE
0
analyze index SYS_C0016433 validate structure
HEIGHT
2
BLOCKS
256
NAME
SYS_C0016433
PARTITION_NAME
LF_ROWS
70231
LF_BLKS
243
LF_ROWS_LEN
1043578
LF_BLK_LEN
8000
BR_ROWS
242
BR_BLKS
1
BR_ROWS_LEN
2612
BR_BLK_LEN
8032
DEL_LF_ROWS
0
DEL_LF_ROWS_LEN
0
DISTINCT_KEYS
70231
MOST_REPEATED_KEY
1
BTREE_SPACE
1952032
USED_SPACE
1046190
PCT_USED
54
ROWS_PER_KEY
1
BLKS_GETS_PER_ACCESS
3
PRE_ROWS
0
PRE_ROWS_LEN
0
OPT_CMPR_COUNT
0
OPT_CMPR_PCTSAVE
0
我们看看执行计划
explain plan for
select * from ORG_INDEX_TABLE t
where t.object_id=30
select * from table(dbms_xplan.display())
---------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
---------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 46 | 1 (0)| 00:00:01 |
|* 1 | INDEX UNIQUE SCAN|SYS_IOT_TOP_84235 | 1 | 46 | 1 (0)| 00:00:01 |
---------------------------------------------------------------------------------------
我们并没有看到TABLE ACCESS BY INDEX ROWID，说明其他字段信息存放在SYS_IOT_TOP_84235
下面一个执行计划继续说明我们的结论
explain plan for
select * from ORG_INDEX_TABLE t
where t.oname='xxxx'
select * from table(dbms_xpl