Home » RDBMS Server » Server Administration » some doubt about the CKPT background process
some doubt about the CKPT background process [message #60755] Tue, 02 March 2004 21:53 Go to next message
cuihh6
Messages: 12
Registered: February 2004
Junior Member
 

In oracle's pdf,
The Checkpoint Process (CKPT) is responsible for updating database status
information in the control files and data files whenever changes in the buffer cache
are permanently recorded in the database.

I don't understand what kind of infomation can be called database status information, Can anyone give an example ?
And why the database status information should be updated after the data was permanently recorded in the database ?
Re: some doubt about the CKPT background process [message #60765 is a reply to message #60755] Wed, 03 March 2004 05:47 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Which Oracle pdf? Can you post the link to that document here ?

CKPT updates the controlfile during incremental checkpoints and all the datafile headers(with the checkpoint information) during the full checkpoints. This is required for recovery purposes.
Previous Topic: database open hangs
Next Topic: how long will my job take
Goto Forum:
  


Current Time: Tue Jan 07 23:35:35 CST 2025