Database DataWarehousing (MOSC)

MOSC Banner

[11gR2]: ORA-12801: error signaled in parallel query server Pxxx & ORA-01555: snapshot too old: roll

edited Jul 9, 2013 4:52AM in Database DataWarehousing (MOSC) 4 commentsAnswered
Hi,


I have implemented parallelism in Oracle 11gr2  by using following  commands at session-level

execute immediate 'alter session set PARALLEL_DEGREE_POLICY=AUTO';
execute immediate 'alter session force PARALLEL QUERY';

but this error is encountered:

ERROR: ORACLE execute error: ORA-12801: error signaled in parallel query server P015
ORA-01555: snapshot too old: rollback segment number string with name "string" too small

I have increased UNDO_RETENTION from 900 to 2400 but error still remain ... why ?

Thanks for help.

GD.



Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center