Interested to Buy Any Domain ? << Click Here >> for more details...
What is the function of checkpoint(CKPT)?
- 4 Answers
- 9336 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 |
1.Explain the three levels with the help og a diagram.
What is the maximum number of Lock Processes used?
What is Database Buffers ?
how oracle will recognise its space is 100gb if 100gb is allocated for it...
What is the use of Oracle Control File?
What is Shared Pool?
What is an oracle database schema?
What is SGA?
What is Server Process?
What are functions of PMON?
Teradata: How can we know the indexed column in a table?
What is the maximum size of a row in oracle 9i?
4 Answers Baidu, HCL, Yashu Systems,
Oracle General 
