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
What are the different types of upgrades that can be performed in sql server? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
Why does Oracle not permit the use of PCTUSED with indexes?
How can you control the amount of free space in your index pages? : sql server DBA
what is the use of ocr?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
suppose you want to audit specific activities on sensitive data. How can you achieve that?
what is grd?
how can you find out if a table can be redefined?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
How do you troubleshoot errors in a sql server agent job? : sql server DBA
