Re: db-writers and UNIX

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 14 May 1999 15:50:22 +0100
Message-ID: <926693715.9766.0.nnrp-02.9e984b29@news.demon.co.uk>

The multiple db writers are the ora_dbNN_SID processes.

It is not surprising that the only process showing much time on ps is DBWR - it does the block gathering from the dirty list and distributes them to the dbNN - this uses CPU, the dbNN write them - this uses very little CPU, just wait time.

So yes, it is normal.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

>> Scott <scott_at_scott.com> wrote in message news:373B2898.953BA47C_at_scott.com...
>> > We have a 7.3.3.5 Oracle instance that has db_writers=4. Upon startup,
>> > there is only 1 dbwr writer process.
>> > There are some processes called ora_db01_SID, ora_db02_SID,
ora_db03_SID
>> > and ora_db04_SID also. Are
>> > these the db_writer processes. UNIX ps shows very little time on the
>> > dbxx process and much time on the
>> > DBWR process after a days uptime. Shouldn't multiple db_writers be
>> > called DBW0, DBW1, etc.? Any ideas
>> > why this would happen? Is it normal?
Received on Fri May 14 1999 - 09:50:22 CDT