1.可以通过DBA_HIST_SEG_STAT和DBA_HIST_SNAPSHOT视图来查看某个snapshot表有多少个block被变化。
2.可以通过dba_tab_modifications视图来看表的DML操作次数。
3.还没有找到一个方法可以查看任意时间表的被改变的block数量或者DML 次数。
通过DBA_HIST_SEG_STAT和DBA_HIST_SNAPSHOT视图来看,我们的order表有108416个block。每个snapshot(一天有9个snapshot)中改变的block数如下:
SNAP_ID | TABLE | CHANGED_BLOCKS | BEGIN_TIME | END_TIME |
26230 | ORDER | 18368 | 11-JUL-14 02.00.06.985000000 PM | 11-JUL-14 03.00.09.780000000 PM |
26227 | ORDER | 14160 | 11-JUL-14 11.00.03.061000000 AM | 11-JUL-14 12.00.01.479000000 PM |
26226 | ORDER | 41504 | 11-JUL-14 10.00.26.710000000 AM | 11-JUL-14 11.00.03.061000000 AM |
26231 | ORDER | 21600 | 11-JUL-14 03.00.09.780000000 PM | 11-JUL-14 04.00.09.660000000 PM |
26233 | ORDER | 29216 | 11-JUL-14 05.00.15.418000000 PM | 11-JUL-14 06.00.18.254000000 PM |
26216 | ORDER | 1696 | 11-JUL-14 12.00.26.802000000 AM | 11-JUL-14 01.00.04.567000000 AM |
26224 | ORDER | 14240 | 11-JUL-14 08.00.15.254000000 AM | 11-JUL-14 09.00.23.541000000 AM |
26232 | ORDER | 33696 | 11-JUL-14 04.00.09.660000000 PM | 11-JUL-14 05.00.15.418000000 PM |
26237 | ORDER | 4960 | 11-JUL-14 09.00.04.000000000 PM | 11-JUL-14 10.00.07.045000000 PM |