Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Solaris - DBWR process chewing up CPU Time
This could be because you are
doing too much writing and are
also running async I/O.
It would help if you could quantify
'chewing up' as a percentage of
CPU.
Look at v$filestat for the number of
writes per file, look at alert log
for frequency of checkpoints,
look at db_files compared to actual
number of files.
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Badesha Singh wrote in message
<942935541.14233.0.nnrp-08.c1ed3ca6_at_news.demon.co.uk>...
>We have Oracle 8i on Sun Sparc Solaris 2.6 and are finding that the DBWR
>process (and CKPT) is chewing up the CPU time on the machine. Anyone had
>this problem or know how we can try to track the problem down.
>
>Does anyone know which commands/utilities will help us track the problem
>down (could it be a swapping problem?).
>
>Thanks
>
>Badesha
>
>
Received on Thu Nov 18 1999 - 13:12:04 CST