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 is grd?
Can you redefine a table online?
Explain about your sql server dba experience? : sql server DBA
Explain materialized views and how they are used.
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
when does an alert gets signaled?
What are statistics, under what circumstances they go out of date, how do you update them?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
What is transparent data encryption? : sql server DBA
internal architecture
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
what is the role of dip user in our database?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
