What is the effect of this setting on the database?

Your database supports an OLTP workload. Examine the output of the query: Exhibit: What
is the effect of this setting on the database?

Your database supports an OLTP workload. Examine the output of the query: Exhibit: What
is the effect of this setting on the database?

A.
Automatic checkpoint tuning is disabled.

B.
The frequency of log switches is increased.

C.
The overhead on database performance is increased because of frequent writes to disk.

D.
The MTTR advisor is disabled.

Show Hint

Leave a Reply 3

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

yogui

yogui

sorry A: Automatic checkpoint tuning is disabled.
Automatic checkpoint tuning is in effect if the FAST_START_MTTR_TARGET database initialization parameter is unset. So if is set is disabled..

Reply

Caesar

Caesar

yogui, yogui – not A:

Automatic Checkpoint Tuning in Oracle 10g (Doc ID 265831.1)
Automatic Checkpoint Tuning (Doc ID 270571.1)

Automatic checkpoint tuning is in effect if the FAST_START_MTTR_TARGET database initialization parameter is set to a nonzero value, or if fast_start_mttr_target is not set at all.

Reply