| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re:RE: Problem with Rollback segment getting locked
Now who would use PUBLIC rollback segments? Their such a pain!!!
Dick Goulet
____________________Reply Separator____________________ Author: Glenn Travis <Glenn.Travis_at_sas.com> 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:Glenn.Travis_at_sas.com]
> 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: dgoulet_at_vicr.com [mailto:dgoulet_at_vicr.com]
> > 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 <Viral.Amin_at_originindia.com>
> > 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: dgoulet_at_vicr.com
> >
> > 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: ListGuru_at_fatcity.com (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: Glenn.Travis_at_sas.com
>
> 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: ListGuru_at_fatcity.com (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: Glenn.Travis_at_sas.com 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: ListGuru_at_fatcity.com (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: dgoulet_at_vicr.com 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: ListGuru_at_fatcity.com (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).Received on Mon Feb 25 2002 - 10:53:35 CST
 |
 |