Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Initialization parameter transactions_per_rollback_segment, can you set this?

RE: Initialization parameter transactions_per_rollback_segment, can you set this?

From: Arnold, Sandra <ArnoldS_at_osti.gov>
Date: Wed, 17 Aug 2005 12:53:13 -0400
Message-ID: <26D5949E6EABA442A75AB8351393E20B9DAD2B@ostimail2.osti.gov>


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_at_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 <ArnoldS_at_osti.gov> 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
Received on Wed Aug 17 2005 - 11:56:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US