估算表的行记录:
SQL> select bytes from dba_segments
2 where segment_name='SOLO';
BYTES
----------
6291456
SQL> select avg_row_len from dba_tables
2 where table_name='SOLO';
AVG_ROW_LEN
-----------
94
SQL> SELECT 6291456/94 FROM DUAL;
6291456/94
----------
66930.383
如何估算一个表的行记录
最新推荐文章于 2021-08-18 20:26:43 发布