Improve company productivity with a Business Account.Sign Up

x
?
Solved

Red Hat Linux

Posted on 2009-06-30
8
Medium Priority
?
1,817 Views
Last Modified: 2013-12-06
Hello,

As there is a process in red hat database (oracle )server kblock which is showing high utilization due to which itr shows high load average . . Kindly please tell me how to deal with this situation

Looking forward to your quick reply
0
Comment
Question by:prashantchauhan
6 Comments
 
LVL 29

Assisted Solution

by:Michael Worsham
Michael Worsham earned 200 total points
ID: 24760061
We are going to need alot more information than what was stated. We need to know what version of RedHat you are running, version of Oracle, type of hardware you are running it upon, etc. It might even be nice if you provide a screen shot of the problem so we can investigate it a bit further.
0
 
LVL 82

Assisted Solution

by:arnold
arnold earned 400 total points
ID: 24760160
How big is/are the database/s.
Specs on the hardware: CPU, memory, Storage type SAN, local drives in RAID, etc.
Are you using raw, ocfs/2, asm etc for the storage where the oracle databases reside?  is this a RAC setup?

kblockd would tend to suggest that your system is swapping memory.
0
 
LVL 36

Accepted Solution

by:
Mark Geerlings earned 600 total points
ID: 24762844
If this process is busy swapping memory, it could be because the Oracle SGA (System Global Area) is not properly sized for the hardware (physical RAM).  The SGA size is controllable via an init file for Oracle.  But like the others mentioned, we need a lot more information from you before we can make a specific recommendation.  In addition to the types of information the others requested, can you also tell us if this is the only Oracle database instance on this server, or if there are multiple Oracle instances, and tell us if this server is dedicated to running Oracle, or if it is a multi-purpose server that also has other tasks or programs running that may be competing for memory.
0
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

 
LVL 20

Assisted Solution

by:Gns
Gns earned 800 total points
ID: 24763878
If the process (along with some of the others lgwr etc) are doing a lot of I/O, or attempting a lot of I/O, it may spend a significant time in state "D". This will (per process in this state) add one (unconditional) point to your load average. But it may be quite normal and nothing to worry about at all. Add to that that a multicore machine would likely "survive" a higher LA, for example a LA of 4 would be optimal on a 4-way SMP/core machine (in the sense that all processors has a run queue of 1 at all times), and the picture may not be that dreary at all.

To be able to tell IF you have a problem, I'd recommend using vmstat, iostat and sar from the linux side of things, to get a grip on how "stressed" your system really is.

From the Oracle side of things, assuming you have a supported version (and not legacy 9i or prior), you should be able to get the advisories in OEM to tell you exactly how stressed (and where) oracle is.

In short: Load average is a really bad performance metric. Don't rely on it for real performance tuning.

Cheers
-- Glenn
0
 
LVL 20

Assisted Solution

by:Gns
Gns earned 800 total points
ID: 24763914
... And, to add anotgher nice tool from Oracle, I'd suggest you implement statspack... and do some snapshots over a reasonable workload, so that the spreport can show where you spend time (in the DB), and provide some sane tuning recommendations.

Cheers
-- Glenn
0
 

Author Closing Comment

by:prashantchauhan
ID: 31598252
many Thanks
0

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to recover a database from a user managed backup

606 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question