Question 5
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.)
value of DB_FILE_MULTIBLOCK_READ_COUNT
storing query results in the result cache
setting of the DISK_ASYNC_IO parameter to TRUE
setting of the OPTIMIZER_MODE parameter to ALL_ROWS
block size of the tablespaces in which the tables being scanned are stored
value of the OPTIMIZER_DYNAMIC_SAMPLING parameter
Correct answer: ABC