Re: plan_table performance
- From: K R <kp0773@xxxxxxxxx>
- To: "Roberts, David (GSD - UK)" <david.h.roberts@xxxxxxxxxx>
- Date: Thu, 17 Dec 2009 07:57:48 -0800
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@xxxxxxxxxx> 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@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *K R
> *Sent:* 17 December 2009 15:36
> *To:* Oracle-L@xxxxxxxxxxxxx
> *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@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
>
>
>
> 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.
>
Other related posts:
