Thursday, October 22, 2009

Oracle DBA Views !

Ever wonder why some of those DBA_ views take so long to execute?
here is the view expansion of a query from SYS.DBA_ALL_TABLES joined to
SYS.DBA_OBJECTS

Simple huh?!

3 comments:

  1. It might be simple. Hard to tell when I can't see what it is! Can't you link to an enlarged image?

    ReplyDelete
  2. the image is too small to read...

    ReplyDelete
  3. Full size version here (blog seems to keep shrinking it)
    full size
    But if you are curious, just down load DB Optimizer at
    14 day trial version and give it a shot with any view you want

    ReplyDelete