Database Administration (MOSC)

MOSC Banner

high CPU DBW process

in Database Administration (MOSC) 9 commentsAnswered ✓

On a 19.16 database on Solaris Sparc64 we have the following:

One of the databases running on that machine, is taking huge amounts of CPU time.

The database is up for about 2 weeks, but the Database Writer proces ( ora_dbw0_$ORACLE_SID ) has taken more than 1000 minutes of CPU time (which is more than 16 hours).

The process itself (v$processes) cannot be linked to a session (v$session), because it's a special one.

But my question is now obviously: what is it doing ? How do I find why it is taking this amount of time ?

If you calculate, it is taking 71 minutes of CPU time per day.

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