Oracle Scratchpad

July 6, 2010


Filed under: Statistics,Troubleshooting — Jonathan Lewis @ 9:01 pm BST Jul 6,2010

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.)


  1. 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 BST Jul 7,2010 | Reply

  2. One note of caution.
    The dba_tab_modifications will also show uncommited DML counts at the time of flushing(tested on on SUN)

    Comment by srivenu — July 16, 2010 @ 6:56 pm BST Jul 16,2010 | Reply

    • 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 BST Jul 24,2010 | Reply

RSS feed for comments on this post. TrackBack URI

Comments and related questions are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Website Powered by

%d bloggers like this: