odd number of rollback segments
- From: "Nick Keighley" <nick_keighley_nospam@xxxxxxxxxxx>
- Date: 31 Aug 2006 07:36:10 -0700
Hi,
I gather questions about Rollback Segments are quite common...
I'm running Oracle 8, and no I'm not going to be able to upgrade soon.
My system seems to be using a lot of disc space with ARC files. It's
generating
about 10 ARC files /min. I understand this is Bad and may indicates
too few
(or too small) rollback segments. Today I got an ORA-01555 for slowish
transaction.
Again this is probably related to RBSs.
Only two public rbs appear to be specifically created by the startup
SQL.
So presumably Oracle created the rest. There are 7 (RBS0-RBS6).
I've dug back though various configuration parameters
processes=50 (sounds big for my environment)
sessions=60
transactions=66
transactions_per_rollback_buffer=5 (TPR)
hence Oracle should allocate transactions/TPR=13.2 public RBS
and not a measly 7. Why?
What do I have to do to change the number of processes? Update the
init.ora
and restart the database?
My rollback segments are all 2M except for number 6 which is 4M. Why?
--
Nick Keighley
.
- Follow-Ups:
- Re: odd number of rollback segments
- From: Brian Peasland
- Re: odd number of rollback segments
- From: Nick Keighley
- Re: odd number of rollback segments
- Prev by Date: Re: Insert-Select much slower than same select on its own
- Next by Date: Re: Insert-Select much slower than same select on its own
- Previous by thread: Insert-Select much slower than same select on its own
- Next by thread: Re: odd number of rollback segments
- Index(es):
Relevant Pages
|
