OraFAQ Forum: Server Administration » High Load on DB Server

Home » RDBMS Server » Server Administration » High Load on DB Server (Oracle DB 10.2.0.4, RHEL4.6ES 64bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

High Load on DB Server [message #450999]

Mon, 12 April 2010 01:19

mzainal
Messages: 54
Registered: March 2010
Location: Malaysia

Member

Hi,

This morning i feel my db server very slow to response. When i check, i saw db server got high load but low process.

http://img20.imageshack.us/img20/9987/highload.png

Please assist me.

Regards,
MzarM.

Report message to a moderator

Re: High Load on DB Server [message #451182 is a reply to message #450999]

Mon, 12 April 2010 22:42

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

Slow Response means..

1/ Select Query slow.
2/ Back up process slow.
3/ Insert/Update Query Slow.
4/ ???

Report message to a moderator

Re: High Load on DB Server [message #451194 is a reply to message #450999]

Tue, 13 April 2010 00:57

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It is up for 32 days. Reboot, if you can - perhaps it'll do some good.

Report message to a moderator

Re: High Load on DB Server [message #451200 is a reply to message #450999]

Tue, 13 April 2010 01:39

mzainal
Messages: 54
Registered: March 2010
Location: Malaysia

Member

Hi,

I think here is problem:

/etc/security/limits.conf
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft nofile 65536
oracle hard nofile 65536

Last time it reach about 64000 and my boss did something. But i don't know what he do.

Regards,
MzarM.

[Updated on: Tue, 13 April 2010 01:40]

Report message to a moderator

Re: High Load on DB Server [message #451208 is a reply to message #451200]

Tue, 13 April 2010 02:22

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Ask your boss, he knows.

Report message to a moderator

Re: High Load on DB Server [message #451219 is a reply to message #451208]

Tue, 13 April 2010 04:16

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

Littlefoot wrote on Tue, 13 April 2010 02:22

Ask your boss, he knows.

Indeed

Report message to a moderator

Previous Topic:	Oracle Advanced Security
Next Topic:	URGENT HELP PLEASE - drop index hangs on SAP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 18:18:49 CDT 2024