|
-
Re: ORA-01555 - 9i Automatic Undo Management
You had a query that took 4736 seconds, and your UNDO_RETENTION is 900 seconds. If you increase it to 5000, you will not probably see that error but can you afford to have so big UNDO tablespace? You will need in this case to increase the size of the UNDO tablespace.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: [email protected]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote