Database Tuning (MOSC)

MOSC Banner

how to find out what process is taking up the kernal percentage?

edited Jan 31, 2012 7:37AM in Database Tuning (MOSC) 6 commentsAnswered
Today, our system just went so slow and everyone is calling.

I issued top and see the load is very high and the kernel percentage is also very high. There are also lots of db writer process running out there busier than usual. I know it is month end and the system is supposed to be busier than usual. But it would be nice if I can find out exactly what is taking up all the kernel percentages. I did identified one user has something running (3 session open), once I killed all his session, the problem seems to be gone. I just don't know whether he is the culprit or

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center