Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Red Hat Linux

Posted on 2009-06-30
8
Medium Priority
?
1,814 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 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 79

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
PowerShell Core for Advanced Linux Administrators

Understand advanced principals around Powershell Core with a focus on the Linux Administrator.  This course covers how to administer numerous environments across multiple platforms including Linux, Azure, AWS, and Google Cloud from a single shell instance.

 
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

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

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

This article will explain how to establish a SSH connection to Ubuntu through the firewall and using a different port other then 22. I have set up a Ubuntu virtual machine in Virtualbox and I am running a Windows 7 workstation. From the Ubuntu vi…
The purpose of this article is to demonstrate how we can upgrade Python from version 2.7.6 to Python 2.7.10 on the Linux Mint operating system. I am using an Oracle Virtual Box where I have installed Linux Mint operating system version 17.2. Once yo…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Suggested Courses

722 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