Now who would use PUBLIC rollback segments? Their such a pain!!! Dick Goulet
____________________Reply Separator____________________ Author: Glenn Travis <[EMAIL PROTECTED]> Date: 2/25/2002 7:38 AM Check that last sentence - should be: Remember, if they are P*R*I*V*A*T*E rollback segments, they must be specified in the rollback_segments parameter to be brought online. > -----Original Message----- > From: Glenn Travis [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 25, 2002 10:18 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Problem with Rollback segment getting locked > > > Check out Metalink Note ID: 1075644.6 > > If you DON'T specify the rollback_segments parameter in the > init.ora file... > > Oracle calculates the number of [PUBLIC] rollback segments to > bring online by calculating; > TRANSACTIONS/TRANSACTIONS_PER_ROLLBACK_SEGMENT. Do a 'show > parameter trans' to find out what these are. Remember, if > TRANSACTIONS is NOT specified, it is derived from SESSIONS, > which is derived from PROCESSES, and can be very high. > > Remember, if they are PUBLIC rollback segments, they must be > specified in the rollback_segments parameter to be brought online. > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > Sent: Sunday, February 24, 2002 12:13 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Re:Problem with Rollback segment getting locked > > > > > > 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). > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Glenn Travis > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis 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). -- 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).
