Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / shwetha
During normal running of database, dirty buffers are added
to checkpoint queue.Also when a block is first modified it
is entered in the checkpoint queue.The RBA of redo record
is also added.Every 3 sec CKPT records the RBA from
checkpoint queue.In case of instance failure RBA gives the
location from where recovery has to start( Checkpoint
position). During log switch CKPT updates contrl file and
data file headers.
| Is This Answer Correct ? | 4 Yes | 7 No |
Post New Answer View All Answers
Which autogrowth database setting is good? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is the difference between dropping a database and taking a database offline? : sql server DBA
how can you create a user-defined lock?
What is replication? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
How can you control the amount of free space in your index pages? : sql server DBA
What happens on checkpoint? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
what is ora 24313?what is the procedure to exclude that error?
Why does Oracle not permit the use of PCTUSED with indexes?
What is the default port no on which sql server listens? : sql server DBA
what functionality does oracle provide to secure sensitive information?
