Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Initialization parameter transactions_per_rollback_segment, can you set this?
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.
I am getting snapshot too old errors for a transaction that is committing after each record is inserted or updated. I cannot increase my undo tablespace to the size it is advising me so I thought if I could decrease the number of rollback segments it would allow more space for each rollback segment.
The version of Oracle that I am working with is 10.1.0.4 on a Solaris 64bit platform.
Any thoughts?
Thanks,
Sandra Arnold
Senior DBA
NCI Oak Ridge, TN
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 16 2005 - 09:50:20 CDT
![]() |
![]() |