Re: Question about analyzing SQL statements

Adam Sandler wrote:
> Hello,
>
> Quite some time ago, a former colleague introduced a feature/
> capability of Oracle to me where a developer can see how their SQL
> statements are processed by the DB... which clauses are evaluated
> first, how things are run, orders of operations, etc. He mentioned
> there was even a whole book (I'm sure there's more than one; I just
> don't know where to start searching) about this capability.
>
> The problem is, I don't know what specifically this capability is
> called. And since I'm not using the correct jargon, Google searches
> aren't panning out (understandably so).
>
> I've got a rather involved SQL statement which is running very slow.
> I'd like to see how the DB is processing it and see if I can modify
> the SQL to increase performance.
>
> Thanks!

Explain Plan will do it:
http://www.psoug.org/reference/explain_plan.html

Autotrace will do it:
http://www.psoug.org/reference/autotrace.html

DBMS_XPLAN will do it:
http://www.psoug.org/reference/dbms_xplan.html

Tracing will do it:

http://www.psoug.org/reference/trace_tkprof.html#trtk
http://www.psoug.org/reference/dbms_support.html
http://www.psoug.org/reference/dbms_trace.html
http://www.psoug.org/reference/dbms_monitor.html

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org