[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Red Hat Linux

Posted on 2009-06-30
8
Medium Priority
?
1,816 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 81

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 35

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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

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

Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This installment of Make It Better gives Media Temple customers the latest news, plugins, and tutorials to make their Grid shared hosting experience that much smoother.
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
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses
Course of the Month10 days, 20 hours left to enroll

612 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