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

n..._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 ?

This forum is called comp.databases.oracle.server, not comp.databases.oracle.riddles.
No version info, no init.ora info about incremental checkpointing, basically you are just *dumping* a ps display without even disclosing how long the database has been running?
What do you expect?
Do you need a clairvoyant or someone who does your work (for free)?

-- 
Sybrand Bakker
Senior Oracle DBA