rc wrote:
> Hi
>
> We use Oracle 8.1.7.4 on Solaris 8 Sparc
>
> When the database is under heavy load i.e. 10s of thousands of record
> are being inserted I get a lot of 'undo header contention'.
>
> My rollback tablespace and most of the redo logs are in a RAID 5
> strip.
>
> I have 9 rollback segments including the system one.
>
> Would I get any improvement if I move the rbs tablespace and some of
> the redo logfile to a RAID 10 disk set? (sorry if this question
> sounds like a how log is a bit of string)
>
> Thanks
Follow Mark Powell's advice but ... RAID5 on an OLTP database on
Solaris? That had "really bad idea" written all over it. It is only
with a single RAID array currently marketed by a different vendor
that I would even consider RAID5.
--
Daniel A. Morgan
Relational theory is not something that is simply a nice-to-have.
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed May 25 2005 - 10:12:20 CDT
