RE: Initialization parameter transactions_per_rollback_segment, can you set this?
- From: "Arnold, Sandra" <ArnoldS@xxxxxxxx>
- To: "Vitalis Jerome" <vitalisman@xxxxxxxxx>
- Date: Wed, 17 Aug 2005 12:53:13 -0400
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@xxxxxxxxx]
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@xxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
