what is incremental checkpoint?
Answer / 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 |
What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?
the process of adding a cpu in sql server is called..?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
Give the stages of instance startup to a usable state where normal users may access it.
what is the difference between hot backup n rman backup?
hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Name three advisory statistics you can collect.
Which dictionary tables and/or views would you look at to diagnose a locking issue?
hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?
You're getting high "busy buffer waits" - how can you find what's causing it?
What are the recovery models for a database? : sql server DBA