Monitoring the Performance of a Single Oracle Enterprise Scheduler Instance

You can monitor the performance of an Oracle Enterprise Scheduler instance, specifically current and historical performance data, as well as a summary of all performance data. Performance data displays in a chart set that you can save, delete, and reorder. You can also modify the time period for which performance data displays.

This section contains the following topics:

Viewing a Summary of Oracle Enterprise Scheduler Activity

The Oracle Enterprise Scheduler Performance Summary page displays current charts of job requests such as requests completed per hour, running requests, requests by processing time and requests by status.

To view a summary of Oracle Enterprise Scheduler activity:

  1. From the Scheduling Service menu, choose Performance > Service Summary.

    By default, this page displays job requests running during a selected time period in the following categories:

    • Requests completed per hour

    • Processing times, average, minimum and maximum

    • Running requests and maximum running requests

    • Requests over the past hour with the status SUCCESS, WARNING, ERROR or CANCEL.

    You can change the metrics displayed on the Service Summary performance page. Click the Show Metric Palette button to display the metric palette for Oracle Enterprise Scheduler.

  2. You can change the duration for which performance data display. See Selecting the Performance Time Period for more information.

  3. Optionally, you can change the display format of performance data on the page.

    Choose View > Grid to remove the grid display format from the charts.

    Click the Table View link to display the performance data in table format.

  4. You can overlay an additional scheduler service over the current service performance metrics.

    1. Choose Overlay > Another Scheduler Service.

      In the Search and Select: Targets window, enter the name of the target and host server and click Search to search for the relevant service.

    2. From the search results table, select the relevant service and click Select to choose the scheduler service to overlay.

  5. Additionally, you can take any of the following actions.

Viewing Current Oracle Enterprise Scheduler Activity

The Oracle Enterprise Scheduler Current Activity page displays pending and running requests by user and application.

To view current Oracle Enterprise Scheduler activity:

  1. From the Scheduling Service menu, choose Performance > Current Activity.
  2. You can view pending and running requests by user or application, or workload by work assignment.

    To view pending and running requests by user, choose View > Requests By User.

    To view pending and running requests by application, choose View > Requests By Application.

    To view workloads by work assignment, choose View > Workload By Work Assignment. For more information about work assignment details, see Creating or Editing a Work Assignment.

Viewing Historical Oracle Enterprise Scheduler Reports

The Oracle Enterprise Scheduler Historical Reports page displays completed job requests by user, application and work assignment.

To view historical Oracle Enterprise Scheduler reports:

  1. From the Scheduling Service menu, choose Performance > Historical Reports.
  2. From the View list, choose one of the following report views:

    • Completed Request Statistics By Job Name

    • Completed Request Statistics By User

    • Request Metrics By Work Assignment

    • Completed Request Statistics

  3. Adjust the filter criteria as required. The filter criteria vary depending on the report view you choose.

    Table 6-3 Completed Request Statistics by Job Name

    Filter Criterion What to Do...

    Application

    From the list, choose the application whose statistics you want to view.

    Minimum Run Time

    Enter the shortest run time period for jobs whose statistics you want to view. Use the text field to enter a number, and select a unit of time from the list: Seconds, Minutes, Hours or Days.

    Completed between

    Use the calendar buttons on either side of the text fields to select a start and end date and time.

    Table 6-4 Completed Request Statistics by User

    Filter Criterion What to Do...

    Application

    From the list, choose the application whose statistics you want to view.

    Minimum Total Run Time

    Enter the shortest total time period for jobs whose statistics you want to view. Use the text field to enter a number, and select a unit of time from the list: Seconds, Minutes, Hours or Days.

    Completed between

    Use the Calendar buttons on either side of the text fields to select a start and end date and time.

    Table 6-5 Request Metrics By Work Assignment

    Filter Criterion What to Do...

    Application

    From the list, choose the application whose statistics you want to view.

    Completed after

    Use the Calendar button to choose the date and time after which the work assignment has completed.

    Table 6-6 Completed Request Statistics

    Filter Criterion What to Do...

    Application

    From the list, choose the application whose statistics you want to view.

    Completed between

    Use the Calendar buttons on either side of the text fields to choose a start and end date and time.
  4. Click Go to search for and display the historical data.

Managing Chart Sets

You can save or delete the chart set displayed in the Oracle Enterprise Scheduler Performance Summary page. You can also re-organize the order of a chart and revert to an old chart set.

This section contains the following topics:

Saving a Chart Set

You can save the chart set displayed in the Oracle Enterprise Scheduler Performance Summary page. Saving a chart set allows preserving a specific set of metrics selected for display, as opposed to the default metrics.

To save a chart set:

  1. Display the Oracle Enterprise Scheduler Performance Summary page.
  2. Click the Save Charts button.
  3. In the Save Charts dialog box, enter a name for the chart set and click OK.
  4. After you have saved the chart set, you can display it by choosing Chart Set > My Chart Set.

Deleting a Chart Set

You can delete saved chart set files created in the Oracle Enterprise Scheduler Performance Summary page.

To delete a chart set:

  1. Display the Oracle Enterprise Scheduler Performance Summary page. Viewing a Summary of Oracle Enterprise Scheduler Activity
  2. Choose View > Delete Chart Sets.
  3. In the Delete Chart Sets dialog box, select the name of the chart set to be deleted and click OK.

Reordering Charts

You can organize the display of performance charts in the Oracle Enterprise Scheduler Performance Summary page. Charts can be moved up or down, or removed entirely.

To reorder chart sets:

  1. Display the Oracle Enterprise Scheduler Performance Summary page. Viewing a Summary of Oracle Enterprise Scheduler Activity
  2. Choose View > Reorder Charts.
  3. In the Reorder Charts popup window, select the chart you want to move and click Move Up or Move Down, respectively.

    To delete a chart from the Performance Summary page, select the chart and click Remove.

Reverting to an Old Chart Set

If you have re-organized your chart sets, you can revert to the chart set as you had originally saved it.

To revert chart sets:

  1. Display the Oracle Enterprise Scheduler Performance Summary page. Viewing a Summary of Oracle Enterprise Scheduler Activity
  2. From the Chart Set list, choose the chart you want to revert to its original display.
  3. Choose View > Revert Chart Set.

Selecting the Performance Time Period

In the Oracle Enterprise Scheduler Performance Summary page, you can change the time period for which the performance summary displays.

To select the performance time period:

  1. Display the Oracle Enterprise Scheduler Performance Summary page. Viewing a Summary of Oracle Enterprise Scheduler Activity
  2. Change the duration for which job requests display.

    • All: Click to display all job requests within a specified, finite period.

    • 15 minutes: Click to display all job requests within the past fifteen minutes.

    • Slider: Click to display a slider that enables scrolling horizontally to show job requests from a specified period. The slider defaults to whichever time segment is selected, "all," 2 hours, or 15 minutes.

    • Calendar: Click the Calendar button to select a time period for which you want to display job requests.