Oracle-L: RE: Problem with Rollback segment getting locked

From: Glenn Travis <Glenn.Travis_at_sas.com>
Date: Mon, 25 Feb 2002 07:18:24 -0800
Message-ID: <F001.0041782B.20020225071824@fatcity.com>

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>
>
> 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
> FACE="Arial">________________________________
> 
>
> </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).

Received on Mon Feb 25 2002 - 09:18:24 CST