Re: a database has very high accumulated CPU time for CKPT

niy38_at_hotmail.com wrote:
> oracle 4497646 1.3 0.0 60816 32964 - A Nov 18 911:51
> ora_ckpt_prod
> oracle 4595964 0.0 0.0 53760 26020 - A Nov 18 20:33
> ora_smon_prod
> oracle 4116580 0.0 0.0 57300 29496 - A Nov 18 14:37
> ora_dbw0_prod
> oracle 4702444 0.0 0.0 55468 27624 - A Nov 18 10:49
> ora_lgwr_prod
> oracle 4673758 0.0 0.0 56616 28848 - A Nov 18 5:06
> ora_arc1_prod
> oracle 4509946 0.0 0.0 56616 28836 - A Nov 18 4:59
> ora_arc0_prod
>
> what does this mean ?
>

All the above means is that your checkpoint process has been busy. From the above, you cannot tell if it has causing you problems. Someone else's background processes may look different:

   oracle 17396     1  0   Dec 01 ?        7:28 ora_smon_gasp
   oracle 17389     1  0   Dec 01 ?       98:13 ora_lgwr_gasp
   oracle 17392     1  0   Dec 01 ?        1:23 ora_ckpt_gasp
   oracle 17400     1  0   Dec 01 ?        0:00 ora_reco_gasp
   oracle 17385     1  0   Dec 01 ?       175:59 ora_dbw0_gasp
   oracle 17381     1  0   Dec 01 ?        6:33 ora_pmon_gasp

The above does not imply that anything is wrong or needs attention.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown