Saturday, June 22, 2013

undo retention for ORA-01555

1) alter system set undo_retention = 1500 scope=both;

2) Check undot tablespace size

3) Disk size where datafile of tablespaces are located

4) Query optimiztion if required which causes this issue

No comments:

Post a Comment