Database Administration (MOSC)

MOSC Banner

high CPU DBW process

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center