Oracle
1Z0-338 · Question #83
You are measuring the I/O savings provided by storage indexes for Table A. One of your scripts displays the I/O sayings as a result of the storage indexes. Which two statements are true? (Choose two.)
The correct answer is D. The storage index data is not on the Cell Server's region index memory structures yet because this. Explanation/Reference:
Monitoring and Managing Exadata
Question
You are measuring the I/O savings provided by storage indexes for Table A. One of your scripts displays the I/O sayings as a result of the storage indexes. Which two statements are true? (Choose two.)
Exhibit
Options
- AThe accumulated I/O saved by the storage index is 1.68 MB.
- CSince the database was started, no queries were run against this table with the same predicate.
- DThe storage index data is not on the Cell Server's region index memory structures yet because this
- EThe storage indexes were disabled by using the DISABLE_STORAGE_INDEX parameter.
How the community answered
(33 responses)- A3% (1)
- C12% (4)
- D82% (27)
- E3% (1)
Explanation
Explanation/Reference:
Topics
#storage indexes#I/O savings#Cell Server#region index memory
Community Discussion
No community discussion yet for this question.
