Interested to Buy Any Domain ? << Click Here >> for more details...
What is the function of checkpoint(CKPT)?
- 4 Answers
- 9510 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 a Control file ?
What is meant by recursive hints ?
What is an Oracle SYSTEM tablespace and when is it Created?
• What is oracle Architecture?
What is an Oracle Data Dictionary?
what is ORACLE MEMORY STRUCTURES
List the factors that can affect the accuracy of the estimations ?
How to find the SGA Size
How the log writer writes the data into database
What is the maximum number of Lock Processes used?
Name the ORACLE Background Process?
What are disadvanteges of having raw devices ?
Oracle General 
