Um, in the catplan.sql script? :) = Pete = "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook = "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] = On Behalf Of Daniel Fink Sent: Thursday, 6 May 2004 7:08 AM To: oracle-l@xxxxxxxxxxxxx Subject: PLAN_TABLE gotcha in 10g 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------