Re: plan_table performance

From: K R <kp0773_at_gmail.com>
Date: Thu, 17 Dec 2009 07:57:48 -0800
Message-ID: <39a33df90912170757i6b6ded27n3ad6b27f8a9bcfdd_at_mail.gmail.com>

I truncated the table and tried . and getting the same waits issue. the plan is taking somewhere around 20-30 sec to come out. I did a stats too but it do not seem to be helping .

Normally I do the explain plan in TOAD but to rule out any slowness caused by TOAD I tried doing it in sqlplus in database server but it still the same .

it is a bit puzzling .

On Thu, Dec 17, 2009 at 7:49 AM, Roberts, David (GSD - UK) < david.h.roberts_at_logica.com> wrote:

> How many rows are there currently in the plan_table?
>
>
>
> Have statistics been gathered on the plan_table?
>
>
>
> Not that I’m necessarily advising you to analyze the table, I’m wondering
> if the current statistics, if they exist actually reflect the current
> contents of the table!
>
>
>
>
>
> Dave
>
>
>
> *David Roberts*
> Senior Developer
>
> _________________________________________
>
> www.logica.com
>
>
>
> Logica UK Limited
> Registered in England and Wales (registered number *947968*)
> Registered office: 250 Brook Drive, Green Park, Reading RG2 6UA, United
> Kingdom
>
> -----Original Message-----
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *K R
> *Sent:* 17 December 2009 15:36
> *To:* Oracle-L_at_freelists.org
> *Subject:* Re: plan_table performance
>
>
>
> 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:
>
> 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
>
>
>
> Please help Logica to respect the environment by not printing this email /
> Pour contribuer comme Logica au respect de l'environnement, merci de ne pas
> imprimer ce mail / Bitte drucken Sie diese Nachricht nicht aus und helfen
> Sie so Logica dabei, die Umwelt zu schützen. / Por favor ajude a Logica a
> respeitar o ambiente não imprimindo este correio electrónico. This e-mail
> and any attachment is for authorised use by the intended recipient(s) only.
> It may contain proprietary material, confidential information and/or be
> subject to legal privilege. It should not be copied, disclosed to, retained
> or used by, any other party. If you are not an intended recipient then
> please promptly delete this e-mail and any attachment and all copies and
> inform the sender. Thank you.
>

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

Received on Thu Dec 17 2009 - 09:57:48 CST