snapshot too old, dbms_stats, and undo tablespace
- From: <ryan.gaffuri@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 11 Feb 2004 9:23:43 -0500
I have the only process running on the server. I am using an undo tablespace
with 15 GBs of undo. I have undo retention set to 20000(I just upped it due to
the error) and I get the following error. There is a little blurb on metalink
about increasing undo retention. I got rid of degree but still got an error on
the parallel slave. The Rollback segment that gives me an error changes every
time. Any idea?
I get the error on PQ slave even when I remove Degree.
SQL> exec dbms_stats.gather_schema_stats(ownname=>'MY_SCHEMA',options=>'GATHER
AUTO');
BEGIN dbms_stats.gather_schema_stats(ownname=>'MY_SCHEMA',options=>'GATHER
AUTO'); END;
*
ERROR at line 1:
ORA-12801: error signaled in parallel query server P007, instance
bpdtw0085:t1bx27 (1)
ORA-01555: snapshot too old: rollback segment number 3 with name "_SYSSMU3$"
too small
ORA-06512: at "SYS.DBMS_STATS", line 7781
ORA-06512: at "SYS.DBMS_STATS", line 9847
ORA-06512: at "SYS.DBMS_STATS", line 10000
ORA-06512: at "SYS.DBMS_STATS", line 10077
ORA-06512: at "SYS.DBMS_STATS", line 10054
ORA-06512: at line 1
----------------------------------------------------------------
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:
- » snapshot too old, dbms_stats, and undo tablespace
