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

From: EscVector <Junk_at_webthere.com>
Date: 5 Dec 2006 13:07:53 -0800
Message-ID: <1165352872.994383.163990@j44g2000cwa.googlegroups.com>

Brian Peasland wrote:
> sybrandb wrote:
> > 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?
>
> Looks to me like the database has been running since November 18th. ;)
>
>
> Cheers,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

   (7) It is always something

        (7a) (corollary). Good, Fast, Cheap: Pick any two (you can't have all three).

                       Request for Comments: 1925 - The Twelve

Networking Truths - R. Callon, Editor Received on Tue Dec 05 2006 - 15:07:53 CST