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
________________________________
