Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Question: Is is safe to move a 'plan table' to a temp tablespace???

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

From: BD <bobby_dread_at_hotmail.com>
Date: 1 Jun 2006 13:54:25 -0700
Message-ID: <1149195265.097581.181410@g10g2000cwb.googlegroups.com>


Hey, all.

I've got a non-managed standby database, which I am hoping to release as a reporting database.

I'm trying to determine what I can and can't do with this db. Clearly, as it can only be opened in read only mode, I can't modify anything.

I am trying an explain plan on a SQL statement (something I'm sure the developers would like for testing) and get an error:

RA-01552: cannot use system rollback segment for non-system tablespace

My current impression as to why this is happening is that explain plan writes to the plan_table, which is stored in a permanent tablespace.

Can I not run explain plans in a read-only standby, then? Or is there some mechanism of moving the plan_table to a temp tablespace? Sounds like a bad idea, but otherwise, I see no way of using explain plan for tuning in a read-only db...

Thanks for all comments,

BD. Received on Thu Jun 01 2006 - 15:54:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US