Mailing List
Home
Forum Home
Oracle List - by freelists.org
Oracle on SUSE Linux - Runing Oracle on SUSE Linux
Oracle database error code ...
www.freelists.org
Subjects
ORA 12540: TNS:internal limit restriction exceeded
ORA 12838 please : Is possible to append two times to the same table befo
ORA 12838 please : Is possible to append two times to the same table before
ora 04031
ora 12500 on windows
ORA 32004: obsolete and/or deprecated parameter(s) specified
ORA 01925: maximum of 30 enabled roles exceeded
ORA 01925: maximum of 30 enabled roles exceeded
ora 12500 on windows
ORA 01650, one idea
ORA 01650
ORA 4030
ORA 12838 please : Is possible to append two times to thesametable before do
ORA 12838 please : Is possible to append two times to thesame table before d
ORA 01536
ORA 03113 end of file on communication channel
ORA 32004: obsolete and/or deprecated parameter(s) specified
ORA 00600:
ORA 00020: maximum number of processes (%s) exceeded
ORA 01925: maximum of 30 enabled roles exceeded
ORA 3113 while creating a cluster database 9201 RAC on Linux with OCFS
ora 12500 on windows
ora 12500 on windows
ora 12500 on windows
ORA 01650, one idea
ora 12500 on windows
ora 12500 on windows
ora 12500 on windows
ORA 2000 Error Using DBMS STATS GATHER SCHEMA STATS
ORA 01650, one idea
ORA 01650, one idea
ORA 01650, one idea
ORA 01650
ORA 01650
ORA 01031
ORA 4030
ORA 4030
ORA 06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
ORA 01722 invalid number
 
Heavy I/O causes servers to become unusable

Heavy I/O causes servers to become unusable

2007-05-09       - By Fahrenfort, Keith (PSS Americas Oracle)

 Back
Reply:     1     2     3     4  

You could always swap it out for an HP server?

Heehee! Kidding!

-- --Original Message-- --
From: AMeeks@(protected) [mailto:AMeeks@(protected)]
Sent: Wednesday, May 09, 2007 1:59 PM
To: suse-oracle@(protected)
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-unsubscribe@(protected) For additional
commands, email: suse-oracle-help@(protected) Please see
http://www.suse.com/oracle/ before posting


--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting