RE: plan_table performance
From: Daniel W. Fink <daniel.fink_at_optimaldba.com>
Date: Thu, 17 Dec 2009 10:42:05 -0600
Message-ID: <20091217164205.3924.qmail_at_optimaldba.com>
What version of Oracle are you using? The plan_table changed from a 'regular' table to a global temporary table in 10g.
Date: Thu, 17 Dec 2009 10:42:05 -0600
Message-ID: <20091217164205.3924.qmail_at_optimaldba.com>
What version of Oracle are you using? The plan_table changed from a 'regular' table to a global temporary table in 10g.
Are you using the explain plan for statement or dbms_xplan?
Daniel Fink
OptimalDBA http://www.optimaldba.com
Oracle Blog http://optimaldba.blogspot.com
Lost Data? http://www.ora600.be/
- Original Message ------- Date: 12/17/2009 3:25 PM From: K R <kp0773_at_gmail.com> To:Oracle-L_at_freelists.org Subject: plan_table performance
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!TIAKar
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 17 2009 - 10:42:05 CST