Solved

Red Hat Linux

Posted on 2009-06-30
8
1,808 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
8 Comments
 
LVL 29

Assisted Solution

by:Michael W
Michael W earned 50 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 77

Assisted Solution

by:arnold
arnold earned 100 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 35

Accepted Solution

by:
Mark Geerlings earned 150 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
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 
LVL 20

Assisted Solution

by:Gns
Gns earned 200 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 200 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Linux Filesystems reporting faster growth than actual file growth... 7 56
Use CRON to save a copy of an open file 1 39
awk file 6 47
pl/sql - query very slow 26 57
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
It’s 2016. Password authentication should be dead — or at least close to dying. But, unfortunately, it has not traversed Quagga stage yet. Using password authentication is like laundering hotel guest linens with a washboard — it’s Passé.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

816 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now