Interested to Buy Any Domain ? << Click Here >> for more details...
What is the function of checkpoint(CKPT)?
- 4 Answers
- 9125 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 are the components of SGA?
What is a Rollback segment entry ?
Can a Tablespace hold objects from different Schemes in Oracle?
How to define Data Block size in Oracle?
What is an oracle database schema?
What is the function of Lock (LCKn) Process?
How will you create multiple rollback segments in a database ?
What is the use of Oracle Control File?
How free extents are managed in Ver 6.0 and Ver 7.0 ?
What is hit ratio ?
What is meant by recursive hints ?
What are disadvanteges of having raw devices ?
Oracle General 
