| rollback segment [message #6204] |
Thu, 03 April 2003 02:34  |
S
Messages: 27
Registered: December 2001
|
Junior Member |
|
|
|
If a transaction is very large, and the rollback segment is not able to hold the rollback information, then will the transaction span across different rollback segments or will it terminate ?
|
|
|
|
| Re: rollback segment [message #6210 is a reply to message #6204] |
Thu, 03 April 2003 05:57  |
utsav
Messages: 94
Registered: March 2003
|
Member |
|
|
Hi,
I dont know if it will terminate or not, but one transaction can in no way span different roll back segments.
On rollback segment is used per transaction.
utsav.
|
|
|
|
| Re: rollback segment [message #6233 is a reply to message #6210] |
Fri, 04 April 2003 15:42 |
Adrian Billington
Messages: 139
Registered: December 2002
|
Senior Member |
|
|
If it needs to (i.e. cannot wrap), your rollback segment will expand until a) there is no tablespace left or b) until maxextents is reached. If you have the OPTIMAL setting, Oracle will shrink the rollback segment back down at a later stage, but if OPTIMAL is set to zero then your rollback segment will stay at its new size until you manually shrink it.
Regards
Adrian
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
