Which three statements are true about Statspack usage?

Which three statements are true about Statspack usage? (Choose three.)

Which three statements are true about Statspack usage? (Choose three.)

A.
If both Statspack and AWR are used, they cannot be scheduled to capture snapshots at the same time.

B.
Time Model data cannot be captured by Statspack unless the STATISTICS_LEVEL parameter is set to ALL.

C.
Both Statspack and AWR can be used on the same database only if the Database Diagnostics pack is present.

D.
Statspack can be used to generate a report for a specific instance as well as a specific SQL statement in an instance.

E.
For best performance when running the performance reports, optimizer statistics should be gathered on the Statspack schema.



Leave a Reply 0

Your email address will not be published. Required fields are marked *