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 of DB_FILE_MULTIBLOCK_READ_COUNT
B.
storing query results in the result cache
C.
setting of the DISK_ASYNC_IO parameter to TRUE
D.
setting of the OPTIMIZER_MODE parameter to ALL_ROWS
E.
use of parallel queries
F.
block size of the tablespaces in which the tables being scanned are stored
G.
value of the OPTIMIZER_DYNAMIC_SAMPLING parameter