DB Optimizer: Oracle DBA Views !

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:

GrahamOctober 23, 2009 at 7:06 AM
It might be simple. Hard to tell when I can't see what it is! Can't you link to an enlarged image?
ReplyDelete
Replies
yoyochenOctober 25, 2009 at 8:59 PM
the image is too small to read...
ReplyDelete
Replies
Kyle HaileyOctober 29, 2009 at 9:25 AM
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
Replies

Add comment

Kyle Hailey

I'm Kyle Hailey and I'm the designer and product manager behind Embarcadero's

DB Optimzer

Before working at Embarcadero I redesigned the performance pages in Oracles OEM 10g (see a before and after example). I am on the patent from the team for our tuning methodology (Patents: 20060059205) . I freely provide graphical monitoring tools such as ASHMON (TCL/TK) as well as scripts to profile database load such as S-ASH ie Simulated ASH (PLSQL). S-ASH, ASHMON and more are available at my old site http://ashmasters.com/ . I have made available C code to directly read profiling data out of Oracle's memory structures, called Direct Memory Access. I speak at conferences and give classes around the world.This blog has some of my new ideas on Visual SQL Tuning (VST), work on DB Optimizer, possibly some past material on DB performance monitoring as well as lots of references and pointers to other information on the web that I find important and worth emphasizing.

DB Optimizer

Thursday, October 22, 2009

Oracle DBA Views !

3 comments:

The Oaktable

Oracle "deep dive" search by T. Pystynen

My Blog List

Facebook

Kyle Hailey