Interested to Buy Any Domain ? << Click Here >> for more details...
What is the function of checkpoint(CKPT)?
- 4 Answers
- 9163 Views
- I also Faced
- E-Mail Answers
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 is advantage of having disk shadowing/ Mirroring ?
What is the function of Lock (LCKn) Process?
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 dictionary cache ?
How will you swap objects into a different table space for an existing database?
What is an oracle database schema?
what is ORACLE MEMORY STRUCTURES
What is an Oracle Rollback Segment?
What is the function of ARCH?
What is meant by free extent ?
What is meant by recursive hints ?
What is a Control file ?
Oracle General 
