In case you don’t follow the link to Martin Widlake’s blog (see right) very often, he’s done a couple of recent posts on dba_tab_modifications that are worth reading.
(And I’ve just discovered the ‘gutter=”false”;’ option for the ‘sourcecode’ tag in one of the comments on Martin’s blog – and that’s also a helpful feature.)
There is actually a bug (4572043) in metalink about this issue, and is also reported to be the case for Merge statement.
Comment by milo — July 7, 2010 @ 5:19 pm UTC Jul 7,2010 |
One note of caution.
The dba_tab_modifications will also show uncommited DML counts at the time of flushing(tested on 10.2.0.4 on SUN)
regards
srivenu
Comment by srivenu — July 16, 2010 @ 6:56 pm UTC Jul 16,2010 |
Srivenu,
Thanks for the comment. There are various cases where the counts go wrong – for example if you rollback a change you may find the counts are not decreased (that may not be true, though, it was an oddity I noticed a long time ago.)
Comment by Jonathan Lewis — July 24, 2010 @ 9:27 am UTC Jul 24,2010 |