which statement accurately describes when redo log file writes take place?

When using IORM, which statement accurately describes when redo log file writes take place?

When using IORM, which statement accurately describes when redo log file writes take place?

A.
Based on the priority of the user

B.
Immediately

C.
Based on the resource group of the user

D.
Based on the intradatabase resource plan

Explanation:
Whenever a transaction is committed, the corresponding redo entries temporarily
stored in redo log buffers of the system global area are written to an online redo log file.
Note:I/O Resource Manager =IORM
http://download.oracle.com/docs/cd/A58617_01/server.804/a58397/ch5.htm



Leave a Reply 4

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


Ziad Abuqasem

Ziad Abuqasem

Answer – B : Immediately
Redo writes and control file I/Os are critical to performance and are always prioritized above all user I/Os.
writes by the database writer process (DBWn) are scheduled at the same priority level as the user I/Os.

max

max

B ACD nonsense. redo log file writes get the highest priority from IORM automatically.