From oracle-l-bounce@freelists.org Wed Aug 17 11:56:19 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j7HGuJMS007810 for ; Wed, 17 Aug 2005 11:56:19 -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 j7HGuCIP007795 for ; Wed, 17 Aug 2005 11:56:13 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 55B221DFDD6; Wed, 17 Aug 2005 11:56:04 -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 01878-10; Wed, 17 Aug 2005 11:56:04 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D201D1DFEF5; Wed, 17 Aug 2005 11:56:03 -0500 (EST) X-Server-Uuid: 340E54C2-F7B0-4117-BD97-5B6B39BEEDD9 X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 content-class: urn:content-classes:message MIME-Version: 1.0 Subject: RE: Initialization parameter transactions_per_rollback_segment, can you set this? Date: Wed, 17 Aug 2005 12:53:13 -0400 Message-ID: <26D5949E6EABA442A75AB8351393E20B9DAD2B@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: AcWi+XHmctgUG6CFTPy9h4zFjBeAtgAUo5Ow From: "Arnold, Sandra" To: "Vitalis Jerome" Cc: "Oracle-L" X-WSS-ID: 6F1DB4F316S12276-01-01 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis X-archive-position: 24133 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.6 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 Thanks. I was able to change this parameter through Database Control. I still have to bounce the database since I was waiting for my indexes to sync. Sandra -----Original Message----- From: Vitalis Jerome [mailto:vitalisman@gmail.com] Sent: Wednesday, August 17, 2005 3:01 AM To: Arnold, Sandra Cc: Oracle-L Subject: Re: Initialization parameter transactions_per_rollback_segment, can you set this? On 8/16/05, Arnold, Sandra wrote: > 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. You can use (assuming an spfile): alter system set transactions_per_rollback_segment=10 scope=spfile; and restart the instance. Jerome -- http://www.freelists.org/webpage/oracle-l