What should you do to accomplish this task?

A new report process containing a complex query is written, with high impact on the
database. You want to collect basic statistics about query, such as the level of parallelism,

total database time, and the number of I/O requests. For the database instance
STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and the
CONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING.
What should you do to accomplish this task?

A.
Execute the query and view Active Session History (ASH) for information about the
query.

B.
Enable SQL trace for the query.

C.
Create a database operation, execute the query, and use the
DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the report.

D.
Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor
query execution and view the information from the V$SESSION_LONGOPS view.