 | | | high context switching and high load averages slowing down sy stem | high context switching and high load averages slowing down sy stem 2005-07-28 - By Rafael Ferreira
Back
I would suggest posting some vmstat / iostat for the system while under
heavy load.
-- --Original Message-- --
From: taroon-list-bounces@(protected) [mailto:taroon-list-bounces@(protected)]
On Behalf Of Magnus Andersen
Sent: Thursday, July 28, 2005 12:51 PM
To: ttsig@(protected)
Cc: Discussion of Red Hat Enterprise Linux 3 (Taroon)
Subject: Re: high context switching and high load averages slowing down
system
I'm running Oracle 9.2.0.6 with the following patches:
Installed Patch List:
=====================
1) Patch 3208258 applied on Mon May 30 12:12:12 EDT 2005
[ Base Bug(s): 3016968 ]
2) Patch 3238244 applied on Mon May 09 09:24:10 EDT 2005
[ Base Bug(s): 3238244 ]
There are around 50 users logged into the database and around 200
processes running on the server at all times. The high loads seems to
appear when I have more then 5 two-tier connection to Oracle running
at the same time. The memory usage doesn't really change. I am
pre-paging my SGA. The load happens when Oracle is more busy, but I
find it hard to believe that the server wouldn't keep up. This
database used to run on a L2000, 2 CPU HP-UX server with the same
amount of memory without these issues.
Since I don't know what is going on I'm not sure what information is
needed. I'll provide any information needed if asked. I just don't
know what to post...
Thanks,
Magnus
On 7/28/05, Tom Sightler <ttsig@(protected)> wrote:
> On Wed, 2005-07-27 at 21:07 -0400, Magnus Andersen wrote:
> > Hi All,
> >
> > I have a HP DL 580 with 4 3 GHz CPUs and 4 GB RAM. I'm running Oracle
> > on it. Throughout the day I am getting high load averages (6 - 18)
> > and at the same time I see context switching go over 300,000.
> > Sometimes over 500,000. This is slowing the system down to a crawl.
> >
> > My OS is RHEL 3 AS Update 4 with the 2.4.21-32.0.1.ELsmp kernel.
> >
> > Any ideas on why this is happening and how to fix it?
>
> I would have to say that you have not provided near enough information
> here. What version of Oracle? What patches? How many concurrent
> users? What's the Oracle system doing during these high load periods?
> Is the load caused by Oracle, perhaps the system is just that busy?
> What's memory look like during these same periods?
>
> Provide some more detail and we might be able to help.
>
> Tom
>
>
>
--
Magnus Andersen
Systems Administrator / Oracle DBA
Walker & Associates, Inc.
--
Taroon-list mailing list
Taroon-list@(protected)
http://www.redhat.com/mailman/listinfo/taroon-list
--
Taroon-list mailing list
Taroon-list@(protected)
http://www.redhat.com/mailman/listinfo/taroon-list
Earn $52 per hosting referral at Lunarpages.
|
|
|