-
Hi ,
I got the ORA-01555 Snapshot too old error yesterday, as a solution i increased the OPTIMAL value of the rollback segments and recreated them. However, the process fell over again today with the same error...As a result i tryed to increase the minextents to 20 as suggested by Oracle..when i ran the sql, the statement was processed...however,looking at dba_rollback_segs for new rsb; it show min_extents as 1?? I checked usin OEM and got the same result???Can anyone shed any light on this??
Thanks..
Chucks_k
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
|