Oracle
1Z0-064 · Question #33
Identify two effects of the DB_FILE_MULTIBLOCK_READ_COUNT parameter on the optimizer. (Choose two.)
The correct answer is B. A full table scan can become cheaper than index scans if the database instance has a high E. Increasing the value of DB_FILE_MULTIBLOCK_READ_COUNT within OS limits lowers the cost. See the full explanation below for the reasoning.
Question
Identify two effects of the DB_FILE_MULTIBLOCK_READ_COUNT parameter on the optimizer. (Choose two.)
Options
- ADecreasing the value of DB_FILE_MULTIBLOCK_READ_COUNT from the default increases the
- BA full table scan can become cheaper than index scans if the database instance has a high
- CIncreasing the value of DB_FILE_MULTIBLOCK_READ_COUNT within OS limits lowers the
- DIn DSS workloads where full table scans may run in parallel and bypass the buffer cache,
- EIncreasing the value of DB_FILE_MULTIBLOCK_READ_COUNT within OS limits lowers the cost
How the community answered
(23 responses)- A4% (1)
- B83% (19)
- C4% (1)
- D9% (2)
Community Discussion
No community discussion yet for this question.