Re: Initialization parameter transactions_per_rollback_segment, can you set this?

  • From: Vitalis Jerome <vitalisman@xxxxxxxxx>
  • To: ArnoldS@xxxxxxxx
  • Date: Wed, 17 Aug 2005 09:01:17 +0200

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: