From oracle-l-bounce@freelists.org Tue Aug 16 09:50:20 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j7GEoKaB013057 for ; Tue, 16 Aug 2005 09:50:20 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j7GEoCIP013037 for ; Tue, 16 Aug 2005 09:50:13 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D09F11DF31F; Tue, 16 Aug 2005 09:50:08 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 18919-04; Tue, 16 Aug 2005 09:50:08 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 46A6D1DF16B; Tue, 16 Aug 2005 09:50:08 -0500 (EST) X-Server-Uuid: A695E085-8CB7-4DFA-91B6-2B4C74DBA34F X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 content-class: urn:content-classes:message MIME-Version: 1.0 Subject: Initialization parameter transactions_per_rollback_segment, can you set this? Date: Tue, 16 Aug 2005 10:47:31 -0400 Message-ID: <26D5949E6EABA442A75AB8351393E20B9DAD23@ostimail2.osti.gov> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Initialization parameter transactions_per_rollback_segment, can you set this? Thread-Index: AcWicW6Btl2isuN1QcCe7agmzAIIog== From: "Arnold, Sandra" To: "Oracle-L" X-WSS-ID: 6F1F23091AW4349-01-01 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5A271.6E6A5070" X-archive-position: 24049 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: ArnoldS@osti.gov Precedence: normal Reply-To: ArnoldS@osti.gov X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.1 required=5.0 tests=AWL,BAYES_00,HTML_60_70, HTML_FONTCOLOR_UNKNOWN,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5A271.6E6A5070 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Is there a way to set the transactions_per_rollback_segment to a higher number than the default? I would like to increase this so that I do not have 74 rollback segments created. Instead I would like to increase it to 10 so that I can have 37 rollback segments created. =20 I am getting snapshot too old errors for a transaction that is committing after each record is inserted or updated. I cannot increase my undo tablespace to the size it is advising me so I thought if I could decrease the number of rollback segments it would allow more space for each rollback segment. =20 The version of Oracle that I am working with is 10.1.0.4 on a Solaris 64bit platform. Any thoughts? Thanks, Sandra Arnold Senior DBA NCI Oak Ridge, TN =20 ------_=_NextPart_001_01C5A271.6E6A5070 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: quoted-printable

Is there a way to set the transactions_per_rollback_segment= to a higher number than the = default? I would like to increase this so that I do not have 74 rollback segments created. Instead I would like to increase it to 10 so that I can = have 37 rollback segments created.

I am getting snapshot too old = errors for a transaction that is committing after each record is inserted or = updated. I cannot increase my undo tablespace to the size it is advising me so I = thought if I could decrease the number of rollback segments it would allow more = space for each rollback segment.

The version of Oracle that I am = working with is 10.1.0.4 on a Solaris 64bit = platform.

Any thoughts?

Thanks,

Sandra Arnold

Senior = DBA

NCI

Oak Ridge, TN

------_=_NextPart_001_01C5A271.6E6A5070-- -- http://www.freelists.org/webpage/oracle-l