Showing posts with label dboptimizer. Show all posts
Showing posts with label dboptimizer. Show all posts

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?!