What is checkpoint?
Answers were Sorted based on User's Feedback
Answer / sudarsan
check point is a background process(chk process name),when
ever any transaction takes place oracle create an check
point for that particular transaction and that is saved
into the controlfile header as well as datafile header.
| Is This Answer Correct ? | 7 Yes | 0 No |
Check Point(CKPT) is a Background Processor, which update latest SCN to datafile header and control file by using online redolog file.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kittu_chintu2005
A checkpoint is a mandatory background process which signals to DBWn
| Is This Answer Correct ? | 0 Yes | 4 No |
How can you control the amount of free space in your index pages? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What column differentiates the V$ views to the GV$ views and how?
How will u copy the objects of one schema to another schema in datapump & export/import?
What questions might be they ask in managerial round in capgemini.
What is the default port no on which sql server listens? : sql server DBA
What is the importance of a recovery model? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
Compare and contrast TRUNCATE and DELETE for a table.
how can you schedule a job in database?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)