Re: plan_table performance
- From: K R <kp0773@xxxxxxxxx>
- To: Oracle-L@xxxxxxxxxxxxx
- Date: Thu, 17 Dec 2009 07:35:39 -0800
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@xxxxxxxxx> 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
>
Other related posts:
