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 |
You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
Which autogrowth database setting is good? : sql server DBA
i had backup last manday.now i need back monday to now ..how do get backup?
how can a session indicate its interest in receiving alerts?
If we issue alter database begin backup. What happens to database?
what is logical system in sap basis
How would you extract DDL of a table without using a GUI tool?
What does coalescing a tablespace do?
Explain what partitioning is and what its benefit is.
What is the difference between the SQL Loader and IMPORT utilities?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
Oracle (3253)
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)