Regarding CKPT

[bhavik]

What performs the Check point in the absence of CKPT process ?

[slimdave]

Very philisophical question that. Almost zen-like.

[JMac]

If it were possible to read between the lines of a one line post I'd guess that you're saying you are experiencing a Checkpoint-less instance?

In which case - I'm flummoxed.

[bolero]

LWGR

[adewri]

Originally posted by bolero
LWGR

CKPT is one of the mandatory database process and there can be no instance without a ckpt process. If this CKPT process dies the instance will crash. So what is that makes u think LGWR will do the check point in case CKPT dies ??

[Thomasps]

CKPT is one of the mandatory database process and there can be no instance without a ckpt process. If this CKPT process dies the instance will crash. So what is that makes u think LGWR will do the check point in case CKPT dies ??

There is no separate checkpoint process in 7.3 Database. By default LGWR will do the checkpoint. If you find the LGWR is over loaded you can enable separate checkpoint process by setting the parameter (checkpoint_process). 8.0 onwards, by default, the checkpoint process is separate from LGWR. see this

http://www.orafaq.com/parms/parm51.htm

[adewri]

Originally posted by Thomasps
There will be no separate checkpoint process in 7.3 Database. By default LGWR will do the checkpoint. If you find the LGWR is over loaded you can enable separate checkpoint process by setting the parameter (checkpoint_process). 8.0 onwards, by default, the checkpoint process is separate from LGWR. see this

http://www.orafaq.com/parms/parm51.htm

Hmmm... thats a nice thing to know that CKPT was optional before 8.0

[slimdave]

Originally posted by adewri
Hmmm... thats a nice thing to know that CKPT was optional before 8.0

Yes, I'll have to bear that in mind if i ever downgrade from 9.2