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

From: Kimberly Smith <ksmith2_at_myfirstlink.net>
Date: Sun, 24 Feb 2002 10:03:20 -0800
Message-ID: <F001.004171B4.20020224100320@fatcity.com>

Oracle will try and put four users per rollback by default. So based on that most of your segments will go unused. It will not move to another rollback just cause someone is already using the one.

-----Original Message-----
dgoulet_at_vicr.com
Sent: Sunday, February 24, 2002 9:13 AM
To: Multiple recipients of list ORACLE-L

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kimberly Smith
  INET: ksmith2_at_myfirstlink.net

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 - 12:03:20 CST