Oracle
1Z0-064 · Question #7
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…
The correct answer is A. value of DB_FILE_MULTIBLOCK_READ_COUNT C. setting of the DISK_ASYNC_IO parameter to TRUE F. block size of the tablespaces in which the tables being scanned are stored. See the full explanation below for the reasoning.
Question
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.)
Options
- Avalue of DB_FILE_MULTIBLOCK_READ_COUNT
- Bstoring query results in the result cache
- Csetting of the DISK_ASYNC_IO parameter to TRUE
- Dsetting of the OPTIMIZER_MODE parameter to ALL_ROWS
- Euse of parallel queries
- Fblock size of the tablespaces in which the tables being scanned are stored
- Gvalue of the OPTIMIZER_DYNAMIC_SAMPLING parameter
How the community answered
(50 responses)- A84% (42)
- B8% (4)
- D2% (1)
- E2% (1)
- G4% (2)
Community Discussion
No community discussion yet for this question.