Database Administration (MOSC)

MOSC Banner

Small spikes in CPU

edited Jan 26, 2010 10:49PM in Database Administration (MOSC) 1 commentAnswered
 I see very small CPU spikes (20% usage) for every 15 mins on the database server. Looks like these are caused whenever Oracle intelligent (dbsnmp.exe) runs. That checks whether sufficient space is available on the system.

When I took stats report it shows the queries of dbsnmp.exe along with other queries runs against the DB. I also see "controlfile sequential read" wait event during the time when there is a spike.

This is the same setup which runs on all the other databases. But I could not find such spikes on the other. What might be causing this?

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