Re: plan_table performance

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Thu, 17 Dec 2009 15:33:15 -0700
Message-Id: <200912172233.nBHMXUpT004581_at_mail97c0.megamailservers.com>

Is it the parsing, i.e. creating t he explain plan, that is slow or displaying a plan from the plan_table? Given the waits you show I am inclined to assume the former. That also would explain why adding an index to plan_table didn't do anything for performance.

At 08:35 AM 12/17/2009, K R wrote:
>These are the waits i am observing
>
>library cache lock lock address 100*mode+namespace
>row cache lock cache id request
>
>On Thu, Dec 17, 2009 at 7:25 AM, K R
><<mailto:kp0773_at_gmail.com>kp0773_at_gmail.com> wrote:
>All,
>
>In one of the database when I run the explain plan it takes a while
>before I get the plan output . so I created a index on statement_id
>. but still no luck.
>Anyone have any idea on how to resolve this .
>
>Appreciate any suggestions!
>
>TIA
>
>Kar
>

Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Dec 17 2009 - 16:33:15 CST