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…

Question

Options

• AExecute the query and view Active Session History (ASH) for information about the query.
• BEnable SQL trace for the query.
• CCreate a database operation, execute the query, and use the DBMS_SQL_MONITOR.REPORT_SQL_
• DUse the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution

• A
  7% (2)
• B
  11% (3)
• C
  79% (22)
• D
  4% (1)

Explanation

The REPORT_SQL_MONITOR function is used to return a SQL monitoring report for a specific Not A: Not interested in session statistics, only in statistics for the particular SQL query. Not B: We are interested in statistics, not tracing. Not D:SET_SESSION_LONGOPS Procedure This procedure sets a row in the V$SESSION_LONGOPS view. This is a view that is used to indicate the on-going progress of a long running operation. Some Oracle functions, such as parallel execution and Server Managed Recovery, use rows in this view to indicate the status of, for example, a database backup. Applications may use the SET_SESSION_LONGOPS procedure to advertise information on the progress of application specific long running tasks so that the progress can be monitored by way of the V$SESSION_LONGOPS view.

No community discussion yet for this question.