What must take place before the block can be written to disk?

You connect to a database instance and execute a DML command that changes one data block.
The block is read from the buffer cache, modified, and modified, and marked as dirty. You commit
the transaction. What must take place before the block can be written to disk?

You connect to a database instance and execute a DML command that changes one data block.
The block is read from the buffer cache, modified, and modified, and marked as dirty. You commit
the transaction. What must take place before the block can be written to disk?

A.
The buffer must be written to flash cache.

B.
A log writer (LGWR) must write all redo entries that have been copied into the buffer since the
last time it wrote.

C.
The modified data block must be moved from the LRU list to the write queue.

D.
The database must advance the checkpoint.



Leave a Reply 1

Your email address will not be published. Required fields are marked *