What is the function of checkpoint(CKPT)?
Answers were Sorted based on User's Feedback
Answer / shiva prasad
A checkpoint is an event that flushes the modified data
from buffer cache to disk and updates control files and
data files
Thanks,
Shiva
Is This Answer Correct ? | 9 Yes | 2 No |
Answer / ashok
it updates datafileheaders and controlfile with latest scn
no
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / kd
checkpoint updates control file and datafile headers and
signals DBWn to write data blocks to disk.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / duttaravi.
when ever a commited data is written from the buffer cache
to the datafile , a checkpoint occurs.
Is This Answer Correct ? | 0 Yes | 9 No |
What constitute an ORACLE Instance?
What is meant by recursive hints ?
How to implement the multiple control files for an existing database ?
How to define Data Block size in Oracle?
how oracle will recognise its space is 100gb if 100gb is allocated for it...
What is a Parallel Server option in ORACLE?
What is meant by Redo Log file mirrorring ? How it can be achieved?
• What is oracle Architecture?
How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?
What is hit ratio ?
What is User Process?
What is a Multi-threaded Server Configuration?