Anjo,
I usually advise in the strongest possible words against setting
"optimal". May logic is that if rollback segment
extends occasionally then
we
should leave the space allocated to a) prevent the dynamic disk
space
management and b) to make room for large queries. The
space will be
consumed anyhow.
What's
your take on the "optimal" parameter?
-----Original Message-----
From: Anjo Kolk [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 22, 2002 8:53 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Problem with Rollback segment getting locked
What lock ? And did you specify optimal ?Viral Amin wrote:
Hi All,
I have about 12 Rollback segmennts in my database & 25 concurrent users logged in. I am continuously facing problems of oracle just keep locking couple of Rollback segments. other people have to wait till Oracle releses the locks on this rollback segments.
My Query is..Why Oracle is just using the few rollback segments from the avilable 12 & then others have to wait till the locks on the rollback segments are released.
Pls help..This is URGENT!!
Regards,
Viral Amin
________________________________
