Workload Metrics

To view Workload metrics:

  1. Open the Performance Hub page from the database details page, if not already open.

    Note

    For more information about how to navigate to the Performance Hub page, see:

  2. The Quick Select field helps you to quickly select from a set of predetermined time ranges (for example, Last Hour, Last 8 Hours, and so on) or set a different custom time range.

    You can adjust the time slider to select the time period for which performance data is displayed on the current tab.

  3. Click Workload to view the Workload tab. It displays four regions and their associated charts. All charts show data for the entire specified time range if within 24 hours.
    • The CPU Statistics region contains two charts, CPU Time and CPU Utilization (%).
      • Select CPU Time to display how much CPU time is being used by the foreground sessions per second. It identifies where the CPU time is mostly spent in the workload and pinpoints any unusual CPU spikes. When CPU time is selected optionally, click the Maximum Threads check box to show the maximum CPU time available. This shows the CPU time component of Average Active Sessions.

      • Select CPU Utilization (%) to display the CPU Utilization (%) chart. This chart indicates the percentage of CPU time aggregated by consumer group as calculated by the resource manager.

    • The Wait Time Statistics region contains a chart that displays the time used in different wait classes. To see the total average active sessions, select the DB Time check box. The activities are broken down by 13 wait classes.

    • The Workload Profile region contains a group of charts that indicate patterns of user calls, executions, transactions, and parses, as well as the number of running statements and queued statements. This region includes a menu that you can use to select the data to display.

      Click the menu and select the metrics that you want to view in the Workload Profile.
      • Select User Calls to display the combined number of logons, parses, and calls executed per second.

      • Select Executions to display the combined number of user and recursive calls that executed SQL statements per second.

      • Select Transactions to display the combined number of user commits and user rollbacks per second.

      • Select Parses to display the combined number of hard and soft parses per second.

      • Select Running Statements to display the number of running SQL statements, aggregated by consumer group.

      • Select Queued Statements to display the number of queued parallel SQL statements, aggregated by consumer group.

    • The Sessions region contains charts that show the number of current logons and sessions.

      Click the menu and select the metric that you want to view in the Sessions region.
      • Select Current Logons to display the number of current successful logons.

      • Select Sessions to display the number of sessions.

For more information about the Workload tab, its regions and the associated charts, see: