RE: PLAN_TABLE gotcha in 10g
- From: Pete Sharman <peter.sharman@xxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 6 May 2004 07:16:22 +1000
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
-----------------------------------------------------------------
Other related posts:
