Heavy I/O causes servers to become unusable

We have Oracle databases and applications running on IBM
servers -- SLES8
on our apps server and SLES9 on our db servers.

We have our development servers setup with RAID 5.

We find that when I perform heavy I/O such as copying a
database or
applying patches or upgrades, the servers become unusable. 
TOP will show
CPU idle of 35 - 50 % but a load average or 10 - 15.  This
happens on
internal disks as well as disks on our EMC Clarion so we
suspect it is more
of a server or OS issue.

I have been a dba for 12 years and have performed the same
operations on HP
and Sun Solaris. On Sun and HP, I would see the server
become slow, but not
unusable.

Does anyone have any suggestions?

Angie


-- 
To unsubscribe, email: suse-oracle-unsubscribesuse.com
For additional commands, email: suse-oracle-helpsuse.com
Please see http://www.suse.com/oracl
e/ before posting

What is DB version? Are you upto date with SLES9 Service
Packs i.e. SP3 + on-line updates

Is server swapping under heavy load? Please post brief
output of vmstat, iostat and top under I/O load.

-Arun

>>> On 5/9/2007 at 11:58 AM, <AMeekszpc.zodiac.com> wrote:

> We have Oracle databases and applications running on
IBM servers -- SLES8
> on our apps server and SLES9 on our db servers.
> 
> We have our development servers setup with RAID 5.
> 
> We find that when I perform heavy I/O such as copying a
database or
> applying patches or upgrades, the servers become
unusable.  TOP will show
> CPU idle of 35 - 50 % but a load average or 10 - 15. 
This happens on
> internal disks as well as disks on our EMC Clarion so
we suspect it is more
> of a server or OS issue.
> 
> I have been a dba for 12 years and have performed the
same operations on HP
> and Sun Solaris. On Sun and HP, I would see the server
become slow, but not
> unusable.
> 
> Does anyone have any suggestions?
> 
> Angie
> 





--
To unsubscribe, email: suse-oracle-unsubscribesuse.com
For additional commands, email: suse-oracle-helpsuse.com
Please see http://www.suse.com/oracl
e/ before posting

You could always swap it out for an HP server? 

Heehee! Kidding!

-----Original Message-----
From: AMeekszpc.zodiac.com [mailto:AMeekszpc.zodiac.com] 
Sent: Wednesday, May 09, 2007 1:59 PM
To: suse-oraclesuse.com
Subject: [suse-oracle] Heavy I/O causes servers to become
unusable


We have Oracle databases and applications running on IBM
servers --
SLES8 on our apps server and SLES9 on our db servers.

We have our development servers setup with RAID 5.

We find that when I perform heavy I/O such as copying a
database or
applying patches or upgrades, the servers become unusable. 
TOP will
show CPU idle of 35 - 50 % but a load average or 10 - 15. 
This happens
on internal disks as well as disks on our EMC Clarion so we
suspect it
is more of a server or OS issue.

I have been a dba for 12 years and have performed the same
operations on
HP and Sun Solaris. On Sun and HP, I would see the server
become slow,
but not unusable.

Does anyone have any suggestions?

Angie


--
To unsubscribe, email: suse-oracle-unsubscribesuse.com
For additional
commands, email: suse-oracle-helpsuse.com Please see
http://www.suse.com/oracl
e/ before posting


--
To unsubscribe, email: suse-oracle-unsubscribesuse.com
For additional commands, email: suse-oracle-helpsuse.com
Please see http://www.suse.com/oracl
e/ before posting