Oracle
1Z0-054 · Question #140
Which three statements are true about Statspack usage? (Choose three.)
The correct answer is C. Both Statspack and AWR can be used on the same database only if the Database Diagnostics D. Statspack can be used to generate a report for a specific instance as well as a specific SQL E. For best performance when running the performance reports, optimizer statistics should be. See the full explanation below for the reasoning.
Question
Which three statements are true about Statspack usage? (Choose three.)
Options
- AIf both Statspack and AWR are used, they cannot be scheduled to capture snapshots at the same
- BTime Model data cannot be captured by Statspack unless the STATISTICS_LEVEL parameter is
- CBoth Statspack and AWR can be used on the same database only if the Database Diagnostics
- DStatspack can be used to generate a report for a specific instance as well as a specific SQL
- EFor best performance when running the performance reports, optimizer statistics should be
How the community answered
(21 responses)- A14% (3)
- B5% (1)
- C81% (17)
Community Discussion
No community discussion yet for this question.