Re: rbs' maxextents in LMT

From: Arup Nanda <arupnanda_at_hotmail.com>
Date: Mon, 06 Jan 2003 15:14:07 -0800
Message-ID: <F001.00528120.20030106151407@fatcity.com>

Guang,

You should use LMTs with UNFORM extent allocation of some size So create the tablespaces and the rollback segments but not the INITIAL or NEXT.

I am not sure what you meamn by runaway processes. If a transaction needs rollback segment space, it will need to extend it. You can still specify MAXEXTENTS to limit the number of extents.

HTH Arup

>From: "Guang Mei" <zlmei_at_hotmail.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: rbs' maxextents in LMT Date: Mon, 06 Jan 2003 13:33:53 -0800
>MIME-Version: 1.0
>Received: from newsfeed.cts.com ([209.68.248.164]) by
>mc3-f32.law16.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Mon, 6 Jan
>2003 14:06:48 -0800
>Received: from fatcity.UUCP (uucp_at_localhost)by newsfeed.cts.com
>(8.9.3/8.9.3) with UUCP id OAA03860;Mon, 6 Jan 2003 14:05:48 -0800 (PST)
>Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 00527F5F;
>Mon, 06 Jan 2003 13:33:53 -0800
>Message-ID: <F001.00527F5F.20030106133353_at_fatcity.com>
>X-Comment: Oracle RDBMS Community Forum
>X-Sender: "Guang Mei" <zlmei_at_hotmail.com>
>Sender: root_at_fatcity.com
>Errors-To: ML-ERRORS_at_fatcity.com
>Organization: Fat City Network Services, San Diego, California
>X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman
>Precedence: bulk
>Return-Path: root_at_fatcity.cts.com
>X-OriginalArrivalTime: 06 Jan 2003 22:06:48.0984 (UTC)
>FILETIME=[E8E2F180:01C2B5CF]
>
>Hi:
>
>Oracle 8173 on Sun Solaris 2.8.
>
>I am in the process of converting rollback segments from DMT to LMT (to see
>how much performance we can get, if any). The tablespace size is 8G and I
>used to create rbs like:
>
>create rollback segment RBS00X storage(initial 2048K next 2048K minextents
>20 maxextents 800) tablespace rbs;
>
>I set maxextents to avoid "run away transaction". But now with rbs in LMT,
>there is no way to set maxextents, how can we avoid "run away transaction"
>in this situation?
>
>Thanks.
>
>Guang Mei
>
>
>_________________________________________________________________
>Add photos to your e-mail with MSN 8. Get 2 months FREE*.
>http://join.msn.com/?page=features/featuredemail
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Guang Mei
> INET: zlmei_at_hotmail.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>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).

---

Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: arupnanda_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Jan 06 2003 - 17:14:07 CST