snapshot too old, dbms_stats, and undo tablespace 2004-02-11 - By ryan.gaffuri@(protected)
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 (See ORA-12801.ora-code.com): error signaled in parallel query server P007, instance
bpdtw0085:t1bx27 (1)
ORA-01555 (See ORA-01555.ora-code.com): snapshot too old: rollback segment number 3 with name "_SYSSMU3$ "
too small
ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_STATS ", line 7781
ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_STATS ", line 9847
ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_STATS ", line 10000
ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_STATS ", line 10077
ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_STATS ", line 10054
ORA-06512 (See ORA-06512.ora-code.com): at line 1
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
