Re: Question: Is is safe to move a 'plan table' to a temp tablespace???

> Can I not run explain plans in a read-only standby, then?

Why would you? The Optimizer takes things into account like the load on the system (in 10g). The load in your read-only system will differ from your production system, so that can lead to different execution plans. And unless you guarantee that every other configuration item is identical in the two systems, tuning a query on your read-only database may not yield the same results on your production database.

 > Or is there
> some mechanism of moving the plan_table to a temp tablespace?

Sorry but no. The PLAN_TABLE is a permanent segment and you can only have temporary segments in the TEMP tablespace.

HTH,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown