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