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
imo A, C, F – correct
Result cache has nothing to do with FTS
A,C,F
F is not correct.
https://blog.dbi-services.com/do-the-block-size-matter/
blocksize makes no difference for full tablescans.
The correct one, apart from A and C, would be E. You can benefit very much from parallel execution for those full scans.
Yep agree with A,C & E