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;
