Re: plan_table performance
Date: Thu, 17 Dec 2009 22:39:45 -0800
Hi Wolfgang ,
Yes you are absolutely right . The delay is at the parsing stage . because trying to display the plan is very quick
On Thu, Dec 17, 2009 at 2:33 PM, Wolfgang Breitling <breitliw_at_centrexcc.com>wrote:
> 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 <kp0773_at_gmail.com> wrote:
> 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
> Anyone have any idea on how to resolve this .
> Appreciate any suggestions!
> Wolfgang Breitling
> Centrex Consulting Corporation