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 1

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


L. Zhu

L. Zhu

A is wrong. why not
B is wrong. typical

C. D. E.