Oracle Scratchpad

February 4, 2011

Dynamic Views

Filed under: humour — Jonathan Lewis @ 7:42 pm BST Feb 4,2011

People forget from time to time that when you query the dynamic performance views (v$ views) you shouldn’t expect to get a read-consistent result set – and this can lead to some very strange results, especially when you start writing joins between views (for example you may be able to find a session is both “not waiting” and “waiting” if you still join v$session and v$session_wait).

Here’s a visual analogy to help you remember what’s going on: “Australian Propellors ?”

And a graphic to help explain the phenomenon: “Rolling Shutter Effect.”

And here, for stunning effect only, is another clip that appeared in the “related topics”.

1 Comment »

  1. I think the needed in-memory-undo structures just to show consistent data would be far too big and ‘expensive’! (even more latches?)
    And the biggest advantage of this inconsistency is the sampling of changes like Tanel P├Áder snapper and other tools do without much effort.
    I like this particular inconsitency ;-)

    Comment by Martin Berger — February 5, 2011 @ 9:26 am BST Feb 5,2011 | 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,528 other followers