RE: plan_table performance

From: Roberts, David (GSD - UK) <"Roberts,>
Date: Thu, 17 Dec 2009 15:49:25 +0000
Message-ID: <>

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!    


David Roberts
Senior Developer  

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-----
[] On Behalf Of K R Sent: 17 December 2009 15:36
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 <> 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 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 nao imprimindo este correio electronico.

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.

Received on Thu Dec 17 2009 - 09:49:25 CST

Original text of this message