Which three factors should you investigate to determine…

You recently joined a new team administering a database. You notice that full table scans
are performing poorly compared with full table scans on the databases you administered in a
previous job. You decide that performance problems are caused by a misconfiguration of
factors affecting full table scans. Which three factors should you investigate to determine
the cause of the poorly performing Full Table Scans (FTS)?(Choose three.)

You recently joined a new team administering a database. You notice that full table scans
are performing poorly compared with full table scans on the databases you administered in a
previous job. You decide that performance problems are caused by a misconfiguration of
factors affecting full table scans. Which three factors should you investigate to determine
the cause of the poorly performing Full Table Scans (FTS)?(Choose three.)

A.
value ofDB_FILE_MULTIBLOCK_READ_COUNT

B.
storing query results in the result cache

C.
setting of theDISK_ASYNC_IOparameter toTRUE

D.
setting of theOPTIMIZER_MODEparameter toALL_ROWS

E.
use of parallel queries

F.
block size of the tablespaces in which the tables being scanned are stored

G.
value of theOPTIMIZER_DYNAMIC_SAMPLINGparameter



Leave a Reply 4

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


vasya

vasya

imo A, C, F – correct
Result cache has nothing to do with FTS

Fonx

Fonx

Yep agree with A,C & E