| Rollback Segments [message #51974] |
Mon, 24 June 2002 12:44  |
sonia
Messages: 22
Registered: March 2001
|
Junior Member |
|
|
I seem to either be getting a snapshot too old error or a max extents reached in a rollback segment. If I increase the optimal size I get a max extents reached because the rollabck segment does not shrink and if I decrease the optimal size I get a snapshot too old error.
Please Help. I'm on Oracle 8.0.5
|
|
|
|
| Re: Rollback Segments [message #51977 is a reply to message #51974] |
Mon, 24 June 2002 13:00  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
well, you can
1. Increase size of rollback segment which will
reduce the likelihood of overwriting rollback
information that is needed.
2. Add additional rollback segments. This will allow
the updates etc. to be spread across more rollback
segments thereby reducing the chances of
overwriting required rollback information.
3. Commit more frequently. so, that only less redo
is generated.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
