Re: Table Lock [message #35807] |
Tue, 16 October 2001 13:03 |
jack
Messages: 123 Registered: September 2000
|
Senior Member |
|
|
So, increase the size of the rollback segements. This sounds reasonable to me.
Can I also address this issue with the frequency of the commits? To avoid the "snapshot too old" problem should I be commiting more often or less often? I don't have the eduction to know where to find the happy medium.
If you have the time I have a curious question. If it is due to the rollback segement sizing why doesn't this happen everytime I reach a limit. This only happens once in ten or so runs.
Thank you for your expertise, Jack
----------------------------------------------------------------------
|
|
|