Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: HELP In Regard to DBWR

Re: HELP In Regard to DBWR

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 19 Jan 1999 20:23:27 -0000
Message-ID: <916778049.13995.1.nnrp-05.9e984b29@news.demon.co.uk>


It sounds as if have either created small redo log files, or set the log_checkpoint_interval too low.

Look in your alert log for

    checkpoint not complete message
and for the average time between checkpoints.

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

Ramesh Ganesan wrote in message <77vf0l$m8l_at_bgtnsc03.worldnet.att.net>...
>Guys
>
>Environment : HP9000 - HPUX10.20 , Database resifding on a Disk array
>configured as RAID5.
>
>I find my Unix processes halting at times. Monitoring the Process doesn't
>show that the processes are being pushed or swapping taking place. The DBWR
>Checkpoints statistics however seems high. Would it help if I increase the
>DB writers - The Disk array has one controller but two bus channels and
>enough Cache.
>
>
>
Received on Tue Jan 19 1999 - 14:23:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US