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

From: <dgoulet_at_vicr.com>
Date: Sun, 24 Feb 2002 09:13:18 -0800
Message-ID: <F001.0041717F.20020224091318@fatcity.com>

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
 <FONT COLOR="#000000" SIZE=2

FACE="Arial">________________________________</FONT>

</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).

Received on Sun Feb 24 2002 - 11:13:18 CST