Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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