我也没有看明白TOM的回复,dba_tab_modifications 记录每个表的DML语句影响的ROWS吗? 无论是1条还是多条!

ORACLE 通过下面的语句 如果表的更改量超过了10%才去做分析.  TOM的10%是指这个吗?

select a.table_owner, a.table_name, a.inserts,a.updates,a.deletes ,b.num_rows

from dba_tab_modifications a, dba_tables b

where a.table_name = b.table_name

and table_owner not in

('SYS', 'SYSTEM', 'SYSMAN', 'DMSYS', 'OLAPSYS', 'XDB',

'EXFSYS', 'CTXSYS', 'WMSYS', 'DBSNMP', 'ORDSYS',

'OUTLN', 'TSMSYS', 'MDSYS')

and inserts > 0 and partitioned='NO' and a.inserts/decode(b.num_rows,0,1,b.num_rows)>=0.1

or a.table_name = b.table_name

and table_owner not in

('SYS', 'SYSTEM', 'SYSMAN', 'DMSYS', 'OLAPSYS', 'XDB',

'EXFSYS', 'CTXSYS', 'WMSYS', 'DBSNMP', 'ORDSYS',

'OUTLN', 'TSMSYS', 'MDSYS')

and updates > 0 and partitioned='NO' and a.updates/decode(b.num_rows,0,1,b.num_rows)>=0.1 or

a.table_name = b.table_name

and table_owner not in

('SYS', 'SYSTEM', 'SYSMAN', 'DMSYS', 'OLAPSYS', 'XDB',

'EXFSYS', 'CTXSYS', 'WMSYS', 'DBSNMP', 'ORDSYS',

'OUTLN', 'TSMSYS', 'MDSYS')

and deletes > 0 and partitioned='NO' and a.deletes/decode(b.num_rows,0,1,b.num_rows)>=0.1 ;