Re: Getting the Execution Plan?

From: greg.burris <greg.burris_at_MCI2000.com>
Date: 1997/02/02
Message-ID: <01bc1146$97821980$LocalHost@gburris-lap>#1/1

Matthieu Exbrayat <exbrayat_at_lisiflory.insa-lyon.fr> wrote in article <32F1E511.41C67EA6_at_lisiflory.insa-lyon.fr>...
> I wonder myself is it possible to get the execution plan
> of a query, and then to understand it...
> Is this documented?
> Is it possible to get the plan of a query without executing it?
> (our aim is to study the plan to get a parallel execution plan
> via a 2 phases optimisation)
>
> Thanks for help
>

Depending on the version you are running, you will have a Performance Tuning Guide, or a section on performance tuning in the Server Administrator's Guide. There is a detailed descriptioin of the Explain Plan, Oracle Trace, and/or TKPROF utilities in these manuals.

Also, there are several good third party performance tuning books that can assist in this area.

Good luck,

-- 
Gregory A. Burris
Practice Manager, Performance and Architecture Group
Oracle Services Central Area
Troy, MI  810-614-5029

Received on Sun Feb 02 1997 - 00:00:00 CST