Interested to Buy Any Domain ? << Click Here >> for more details...
What is the function of checkpoint(CKPT)?
- 4 Answers
- 9523 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 an Oracle Data Block?
Which parameter in Storage clause will reduce no. of rows per block?
What is a Control file ?
When Does DBWR write to the database?
What is an Oracle Data Segment?
What is the function of ARCH?
How will you swap objects into a different table space for an existing database?
How will you force database to use particular rollback segment?
What are functions of PMON?
Can a Tablespace hold objects from different Schemes in Oracle?
What is Server Process?
What is the functionality of SYSTEM table space ?
Oracle General 
