Which three components would you consider for further investigation based on this information?

You query the V$SYSSTAT view and notice a significantly high value for the redo log space requests statistic.
Which three components would you consider for further investigation based on this information? (Choose three.)

You query the V$SYSSTAT view and notice a significantly high value for the redo log space requests statistic.
Which three components would you consider for further investigation based on this information? (Choose three.)

A.
LGWR

B.
checkpoints

C.
archiver activity

D.
size of the log buffer

E.
size of the redo log files

Show Hint

Leave a Reply 1

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

vasya

vasya

The V$SYSSTAT statistic redo log space requests indicates how many times a server process had to wait for space in the online redo log, not for space in the redo log buffer. Use this statistic and the wait events as an indication that you must tune checkpoints, DBWR, or archiver activity, not LGWR. Increasing the size of the log buffer does not help.

Reply