What is checkpoint?

Answers were Sorted based on User's Feedback



What is checkpoint?..

Answer / sudarsan

check point is a background process(chk process name),when
ever any transaction takes place oracle create an check
point for that particular transaction and that is saved
into the controlfile header as well as datafile header.

Is This Answer Correct ?    7 Yes 0 No

What is checkpoint?..

Answer / sreeramch9

Check Point(CKPT) is a Background Processor, which update latest SCN to datafile header and control file by using online redolog file.

Is This Answer Correct ?    0 Yes 0 No

What is checkpoint?..

Answer / kittu_chintu2005

A checkpoint is a mandatory background process which signals to DBWn

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More DB Administration Interview Questions

what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  


what functionality does oracle provide to secure sensitive information?

0 Answers   Oracle,


Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

1 Answers  


What is the difference between LMT & DLT?

1 Answers   CTS,


How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers  






What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers  


How would you extract DDL of a table without using a GUI tool?

0 Answers  


I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

0 Answers  


What does coalescing a tablespace do?

1 Answers  


What is dcl? : sql server DBA

0 Answers  


any body know about orawaves do they really provide placements in their unique placement program

1 Answers   TCS,


Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  


Categories