Viral,
Why do you have 12 rollback segments with only 25 users? I normally run
that kind of load with only 5 & have not had any difficulty for over 10 years.
My question to you would be, are these segments online? You can have all the
rollback segments you want, but it their NOT in the rollback_segment parameter
of your init file or else brought online by some other mechanism then you might
as well not have them because as far as the database is concerned their just not
usable.
Dick Goulet
____________________Reply Separator____________________
Author: Viral Amin <[EMAIL PROTECTED]>
Date: 2/22/2002 4:28 AM
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
________________________________
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>Problem with Rollback segment getting locked</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2 FACE="Arial">Hi All,</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial"> 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.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">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.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">Pls help..This is<B> URGENT!!</B></FONT>
</P>
<P><FONT COLOR="#000000" SIZE=2 FACE="Arial">Regards,</FONT>
</P>
<P><B><FONT COLOR="#0000FF" SIZE=2 FACE="Comic Sans MS">Viral Amin</FONT></B>
<BR><FONT COLOR="#000000" SIZE=2
FACE="Arial">________________________________</FONT>
</P>
</BODY>
</HTML>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
