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 |
Which environment variables are absolutely critical in order to run the OUI?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
how can you implement fine-grained auditing?
why we use cursors
Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
How do you open a cluster administrator? : sql server DBA
A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?
how do see how much space is used and free in a tablespace
If we issue alter database begin backup. What happens to database?
How would you force a log switch?
i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???
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)