Home » RDBMS Server » Server Administration » some doubt about the CKPT background process
some doubt about the CKPT background process [message #60756] 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 ?

Report message to a moderator

Re: some doubt about the CKPT background process [message #60766 is a reply to message #60756] Wed, 03 March 2004 05:47 Go to previous messageGo to next message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
answered.

Report message to a moderator

Re: some doubt about the CKPT background process [message #60809 is a reply to message #60756] Mon, 08 March 2004 03:40 Go to previous message
Pradeep George
Messages: 6
Registered: March 2004
Junior Member
CKPT porcess updates datafile and control file headers with current SCN. That means upto that point the database is in consistent state.

Report message to a moderator

Previous Topic: Oracle Migration Question
Next Topic: Oracle online Help For Server Setup.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 12:54:27 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.