RE: Problem with Rollback segment getting locked

[Babich , Sergey]

Title: Problem with Rollback segment getting locked

Hi, Viral, Are these RB segments public? Regards, Sergey   -----Original Message----- From: Viral Amin [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 7:29 AM To: Multiple recipients of list ORACLE-L Subject: Problem with Rollback segment getting locked   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 ________________________________