Oracle Scratchpad

July 6, 2010

dba_tab_modifications

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

3 Comments »

  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 10.2.0.4 on SUN)
    regards
    srivenu

    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

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

The Rubric Theme. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 3,514 other followers