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 |
From the database level, how can you tell under which time zone a database is operating?
How to start SQL Server in minimal configuration mode?
how does an oracle clusterware manage crs resources?
What are the commands used in dcl? : sql server DBA
How can we see the database version in os level
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
How would you determine who has added a row to a table?
What is dbcc? : sql server DBA
what do you understand by fine-grained auditing?
What type of index should you use on a fact table?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
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)