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

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

> 
> 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