Home » RDBMS Server » Server Administration » Sun solaris - Oracle server Load Average is too High at specific days (Oracle 11.2.0.1.0 )
Sun solaris - Oracle server Load Average is too High at specific days [message #479340] Sat, 16 October 2010 03:26 Go to next message
chennsk
Messages: 1
Registered: October 2010
Location: chennai, india
Junior Member
Hi,

My problem is only on Some Saturday's my Oracle server's Load average goes high (more than 300 ).

-- oracle version 11.2.0.1.0
-- runs on Sun solaris 10
-- Sun fire V 440
-- Sun storEdge 3315 connected to the server.

Same setup is working find with higher volumes without any problem but only on saturday's, that too not on all saturdays, some specific saturdays the load average goes high.

At the time nothing will be processed from the application side and the cpu utilisation goes high upto 95 %.

can somebody help on getting it resolved.

I am sending necessary information as follows.

thanks in advance.
--sivakumar





vmstat 6 10
kthr memory page disk faults cpu
r b w swap free re mf pi po fr de sr s0 s1 s3 s4 in sy cs us sy id
3 0 0 28660024 6513408 285 212 2044 2 2 0 0 0 17 0 42 830 3469 1380 22 5 74
125 0 0 29027480 6156256 2 6 34 0 0 0 0 0 5 0 10 791 53770 30278 83 17 0
125 0 0 29027680 6157496 29 140 21 1 1 0 0 0 5 0 9 786 52756 30309 83 17 0
116 0 0 29031600 6159896 24 125 0 0 0 0 0 7 3 0 5 819 54081 31069 83 17 0
126 0 0 29027992 6158040 34 60 20 0 0 0 0 0 4 0 15 744 53556 30679 84 16 0
118 0 0 29018520 6152864 39 202 1 3 3 0 0 0 4 0 14 814 54006 30873 84 16 0
116 0 0 29016192 6150208 3 51 4 0 0 0 0 0 11 0 8 774 54217 31422 83 17 0
100 0 0 29021968 6154136 17 7 44 0 0 0 0 0 3 0 5 823 57491 32827 85 15 0
102 0 0 29021832 6154464 2 3 22 0 0 0 0 3 10 0 5 795 57058 32945 85 15 0
119 0 0 29018992 6153768 47 143 1 0 0 0 0 0 3 0 7 790 54870 31225 84 16 0
#

ps -ef |grep -i pmon
oracle 1555 1 0 Oct 09 ? 21:40 ora_pmon_titan
#
# uname -an
SunOS TITAN 5.10 Generic_141444-09 sun4u sparc SUNW,Sun-Fire-V440
#

Time to Connect : 12 seconds.

~Database Version : 11.2.0.1.0
~Database Up Since : 09:56:20 PM, October 9 2010
~Statistics Level : TYPICAL
~Undo Management : AUTO
~Buffer Cache Hit Ratio : 99.278
~Library Cache Miss Ratio : 0.038
~Dictionary Cache Miss Ratio : 0.2878

[Shared Pool Usage] Exec Time 9 seconds
~ Total Mb Unused : 224.19
~ Total Mb Used : 1151.81
~ Total Mb : 1376
~ Shared Pool Percent Used : 83.71


[Archive Log Mode Info] Exec Time 1 seconds
~ Archiver : STARTED
~ Log Mode : ARCHIVELOG
~ log_archive_start (init.ora param) = TRUE

[Archive Log Info] Exec Time 3 seconds
~ Average Log Switches Per Day : 10.47
~ Hard Drive Storage (in Mb) for this many archive logs : 5235.1

Report message to a moderator

Re: Sun solaris - Oracle server Load Average is too High at specific days [message #479380 is a reply to message #479340] Sat, 16 October 2010 09:36 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I am sending necessary information as follows.
If above were a true statement, you would not be asking for assistance in solving your mystery.

>My problem is only on Some Saturday's my Oracle server's Load average goes high (more than 300 ).
Why so many processes?
What are they doing?

What clues exist in AWR while heavy load exists?

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

[Updated on: Sat, 16 October 2010 12:19]

Report message to a moderator

Previous Topic: ORA-01033: ORACLE initialization or shutdown in progress
Next Topic: segment space managent is auto
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 15 14:42:23 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.