> 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@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