Workload

The Queries subtab displays top normalized queries executed on the database instance during the selected time range. By default, the table is sorted by total duration in descending order.

Columns in the Workload > Queries table include:

• Query: Normalized query text with literal values obfuscated.

• Executions: Number of times the database engine ran this query in the specified time range.

• Total duration: Cumulative time the database spent executing this query across all runs in the selected time window. A high value indicates a query that contributes significantly to the overall database workload time.

• Avg. duration: Average execution time for a single run of the query. A high value indicates a slow query.

• Total CPU time: Cumulative CPU time consumed by the query across all runs. A high value indicates a CPU-intensive query.

• Avg. active sessions: Average number of concurrent database sessions running this query. Use this value to identify queries that cause blocking or high concurrency issues.

• Wait states: Color-coded bar that shows the average active sessions breakdown by wait states. Hover over the bar to see the wait events where the query spent its time.

The Query Samples subtab lists samples of queries running on the database platform instance for the selected time interval, sorted by duration in descending order. Samples are collected every 10 seconds by default. Use this subtab to find specific slow runs and trace them back to the originating application.

Columns in the Workload > Query Samples table include:

• Timestamp: Exact date and time the query execution occurred.

• Query: SQL text of the executed query.

• Client address: IP address or hostname of the application server or client that initiated the query.

• User: Database user account used to run the query.

• Session ID: Unique database session identifier for the execution.

• Duration: Total execution time for this run.

The Stored Procedures subtab displays performance metrics for reusable, named database objects of type procedure that were executed during the selected time range.

A stored procedure is a collection of queries and logic that is stored directly within a database engine. It serves as a discrete unit of execution for performance monitoring and observability.

Columns in the Workload > Stored Procedures table include:

• Stored Procedure: Name of the stored procedure.

• Procedure ID: Unique identifier of the stored procedure in the database dictionary.

• Executions: Number of times the database engine ran this stored procedure in the specified time range. For Oracle Database, stored procedure execution count is a best-effort estimate.

• Total duration: Cumulative time spent by the database executing this stored procedure across all runs in the selected time window.

• Avg. duration: Average time for a single execution of the stored procedure. A high value indicates a slow stored procedure.

• Total CPU time: Cumulative CPU time consumed by the stored procedure across all runs.

• Avg. active sessions: Average number of concurrent sessions running the stored procedure.

• Wait states: Color-coded bar that shows the average active sessions breakdown by wait states during the procedure's execution.

The Blocking Sessions subtab helps you identify lock contention where one database session is holding resources required by other sessions.

The subtab includes the following view toggles:

• Active Blocks: Shows sessions currently blocking other transactions in real time. Select any session to see the exact queries it contains plus a map of blocking and blocked queries, the explain plan, and metadata.

  

• Historical Blocks: Shows past blocking events that occurred during the selected time range. Select a query to view a flyout with a mapping view of blocked and blocking queries.

  

Columns in the Workload > Blocking Sessions table include:

• Query ID: Unique identifier of the blocking query.

• Query Text: SQL text of the query holding the lock.

• Blocking Duration: Cumulative time this query blocked other database sessions.

• Waiting Duration: Time this query spent waiting on other resources, if applicable.

• Affected Sessions: Number of database sessions that were stalled or blocked by this query.