PLAN_TABLE gotcha in 10g
- From: Daniel Fink <Daniel.Fink@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 05 May 2004 15:08:03 -0600
I've been working with some sql in a new 10g db doing the
typical 'explain plan for ' syntax. Today, I decided to preserve
some of the plans, so I set statement_ids and commited them. Lo
and behold, they were not there when I went back later in the
day. In 10g, a PLAN_TABLE$ table is created and given the PUBLIC
synonym PLAN_TABLE. Convenient, now I don't have to run utlxplan
for every user. Just be disciplined and use distinct
statement_ids. Unfortunately, the PLAN_TABLE$ is a global
temporary table, so my records are deleted when the session
ends! ARGH! FYI, this table is created with the catplan.sql
script that is called by catalog.sql.
Okay, Pete. Where's the doc on this one? ;)
Daniel
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
