RE: plan_table performance

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@xxxxxxxxx> To:Oracle-L@xxxxxxxxxxxxx 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-l


Other related posts: