What is checkpoint?
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / kittu_chintu2005
A checkpoint is a mandatory background process which signals to DBWn
Is This Answer Correct ? | 0 Yes | 4 No |
what is the last version,the release date of that version and fix pack of ibm db2 udb?
what functionality does oracle provide to secure sensitive information?
Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?
What is the difference between LMT & DLT?
How will u copy the objects of one schema to another schema in datapump & export/import?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How would you extract DDL of a table without using a GUI tool?
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
What does coalescing a tablespace do?
What is dcl? : sql server DBA
any body know about orawaves do they really provide placements in their unique placement program
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.