Re: plan_table performance

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:

> 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
>

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