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" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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@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: <[EMAIL PROTECTED]>
X-Comment: Oracle RDBMS Community Forum
X-Sender: "Guang Mei" <[EMAIL PROTECTED]>
Sender: [EMAIL PROTECTED]
Errors-To: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
