Skip Headers

Oracle® Enterprise Manager Metric Reference Manual
10g Release 1 (10.1)
Part No. B12015-01
  Go To Table Of Contents
Contents

Previous Next  

14 Reports Server

You can use Oracle Enterprise Manager to monitor and manage Oracle Reports Server.

14.1 Cluster Information

Provides information about the cluster under which various Reports Servers might be running.

14.1.1 Current Jobs

Provides the total number of currently running jobs in the Reports Server Cluster Job Queue.

14.1.2 Failed Jobs

Provides the total number of jobs for the listed Reports Server cluster that were stopped before completion. This includes cancelled jobs as well as those terminated with error.

14.1.3 Finished Jobs

Provides the total number of finished jobs currently in the Reports Server cluster.

14.1.4 Response Time (ms)

Provides the average number of milliseconds it takes for the listed Reports Server cluster to process a request from the client.

14.1.5 Scheduled Jobs

Provides the total number of scheduled jobs currently in the listed Reports Server Cluster Job Queue.

14.2 Current Jobs

Provides information about the currently running jobs in the Reports Server.

14.2.1 Job Name

If you specified a job name in the command line you used to run this job, that name is listed here. Otherwise, it is the name of the job provided for the "report=" or "module=" parameter of the job request.

14.2.2 Output Format

Provides the output format (desformat) specified for this job at runtime.

14.2.3 Output Type

Provides the destination type (destype) specified for this job at runtime.

14.2.4 Owner

Provides the user ID under which this job is running.

14.2.5 Queued At

Provides the date and time this job request was placed in the Job Queue.

14.2.6 Started At

Provides the date and time this job started running.

14.2.7 Status

Provides the status of the current job.

14.3 Engine Information

Provides the types and numbers of currently running engines on the selected Reports Server.

14.3.1 Engines

Provides the total number of this type of engine that is currently running on the selected Reports Server.

14.3.2 Running

Provides the number of engines currently running (active) in the Reports Server processing requests.

14.4 Failed Jobs

Provides the total number of jobs currently in the selected Reports Server's Job Queue that were stopped before completion. This includes cancelled jobs as well as those terminated with error. When this number is higher than 0, it links to the Failed Jobs Queue, where you can get detail on why a job failed, view the job's trace file, and resubmit the job.

14.4.1 Finished At

Provides the date and time this job was cancelled or terminated with error.

14.4.2 Job Name

If you specified a job name in the command line you used to run this report, that name is listed here. Otherwise, it is the name of the job provided for the "report=" or "module=" parameter of the report request.

14.4.3 Output Format

Provides the destination format (desformat) specified for this report at runtime.

14.4.4 Output Type

Provides the destination type (destype) specified for this job at runtime.

14.4.5 Owner

Provides the user ID under which this job was run.

14.4.6 Queued At

Provides the date and time this job request was placed in the Job Queue.

14.4.7 Started At

Provides the date and time this job started running.

14.4.8 Status

Provides the status of the job. Status will either indicate that the job was cancelled by the user or provide some information on why the job was terminated with error.

14.5 Finished Jobs

Provides a detailed look at all successfully completed jobs in the Job Queue on the selected Reports Server.

14.5.1 Finished At

Provides the date and time this job completed.

14.5.2 Job Name

If you specified a job name in the command line you used to run this report, that name is listed here. Otherwise, it is the name of the job provided for the "report=" or "module=" parameter of the job request. Job Name is linked to the output of this job. Click Job Name to see a Web version of this job's output (fetched from the Reports Server cache).

14.5.3 Output Format

Provides the destination format (desformat) specified for this job at runtime.

14.5.4 Output Type

Provides the destination type (destype) specified for this job at runtime.

14.5.5 Owner

Provides the user ID under which this job was run.

14.5.6 Queued At

Provides the date and time this job request was placed in the Job Queue.

14.5.7 Started At

Provides the date and time this job started running.

14.5.8 Status

Provides the finished status of the job. In the Finished Job Queue, Status is always Finished Successfully.

14.6 Response

Provides the average number of milliseconds it takes for the selected Reports Server to process a request from the client.

14.6.1 Server Status

Indicates whether the server is up or down.

14.6.1.1 Metric Summary

The following table shows how often the metric's value is collected and compared against the default thresholds. The 'Consecutive Number of Occurrences Preceding Notification' column indicates the consecutive number of times the comparison against thresholds should hold TRUE before an alert is generated.

Table 14-1 Metric Summary Table

Target Version Evaluation and Collection Frequency Upload Frequency Operator Default Warning Threshold Default Critical Threshold Consecutive Number of Occurrences Preceding Notification Alert Text
All Versions Every 5 Minutes After Every Sample =
Not Defined 0 1 Not Defined

14.7 Scheduled Jobs

Provides a detailed look at all jobs scheduled to run on the selected Reports Server and supplies the means of cancelling a scheduled job.

14.7.1 Job Name

Provides a detailed look at all jobs currently running on the selected Reports Server and supplies the means of cancelling a currently running job.

14.7.2 Last Run At

Provides the time the current job was processed.

14.7.3 Next Run At

Provides the time when the current job will run again.

14.7.4 Output Format

Provides the output format (desformat) specified for this job at runtime.

14.7.5 Output Type

Provides the destination type (destype) specified for this job at runtime.

14.7.6 Owner

Provides the user ID under which this job is running.

14.7.7 Repeat Interval

Provides the frequency at which the current job is scheduled to run. For example, daily, monthly, and so on. This setting only appears on the Reports Server Scheduled Job Queue page.

14.8 Server Information

Provides information about the Reports Server, number of engines, and other parameters related to the Reports Server. This information looks at the entire lifecycle of the Reports Server for all the requests handled by the Reports Server, while the Server Performance Data metrics measure the performance of the Reports Server on a real time basis where the metrics generated are based on the requests handled by the Reports Server in last 5 minutes.

14.8.1 Active Engines

Provides the number of engines currently running on the selected Reports Server.

14.8.2 Average Elapsed Time (ms)

Provides the time the current job has been running in the Reports Server and has not yet finished. This metric will be non-zero when a currently running job has been running longer than the default Elapsed Time Limit (currently at 3 minutes). The Elapsed Time Limit can be modified by configuring the Reports Server target from Oracle Enterprise Manager (Grid Control).

14.8.3 Average Response Time (ms)

Provides the average number of milliseconds it takes for the selected Reports Server to process a request from the client.

14.8.4 Cluster Name

If the selected Reports Server is a member of a server cluster, the cluster name is listed here.

14.8.5 Current Jobs

Provides the total number of currently running jobs in the Job Queue.

14.8.6 Failed Jobs

Provides the total number of jobs currently in the Job Queue that were stopped before completion. This includes cancelled jobs as well as those terminated with error.

14.8.7 Failed Ratio (%)

Indicates the health of the Reports Server. This is the ratio of failed jobs to current jobs (failed jobs / (past jobs + failed jobs)).

14.8.8 Finished Jobs

Provides the total number of jobs that have finished running successfully. When this number is higher than 0, it links to the Finished Jobs Queue, where you can get more detail on the finished job, view the job's trace file, view the job result from cache, and resubmit the job.

14.8.9 Scheduled Jobs

Provides the total number of jobs currently in the Scheduled Jobs Queue. When this number is greater than 0, it links to the Scheduled Jobs Queue, where you can view details and canceled the scheduled job.

14.8.10 Since (Start Time)

Provides the date and time the selected Reports Server was last started.

14.8.11 Trace File Name

Provides the Reports Server trace file name.

14.8.12 Trace Mode

Provides the trace mode specified in the Reports Server configuration file for the trace log file, either Replace (the default) or Append. Trace Replace replaces the existing text in the trace log file with new information. Trace Append appends new information to the end of existing trace log file.

14.8.13 Transferred Jobs

In a clustered server environment, provides the total number of jobs transferred between the selected Reports Server and other cluster members. For example, if the selected Reports Server receives a request for a job that was run earlier on another cluster member, the request is transferred to the cluster member that provided the earlier result and the result is delivered to the client from the cluster member's cache. Such a transaction would be counted as one transfer within the cluster.

14.8.14 Version

Provides the current version of the Reports Server.

14.9 Server Performance Data

Provides metrics for the jobs processed/requested for the last 5 minutes. Server Performance Data metrics are similar to Server Information metrics; the Server Information metrics are examined to generate metrics numbers for the jobs processed/requested for the last 5 minutes.

14.9.1 Active Engines

Provides the number of engines currently running on the selected Reports Server.

14.9.1.1 Metric Summary

The following table shows how often the metric's value is collected.

Target Version Collection Frequency
All Versions Every 5 Minutes

14.9.2 Average Elapsed Time to date (ms)

Provides the averaged elasped time for all jobs that have run in the Reports Server in the last 5 minutes. This metric will be non-zero when any running job runs longer than the default Elapsed Time Limit (currently at 3 minutes). The Elapsed Time Limit can be modified by configuring the Reports Server target from Oracle Enterprise Manager (Grid Control).

14.9.2.1 Metric Summary

The following table shows how often the metric's value is collected.

Target Version Collection Frequency
All Versions Every 5 Minutes

14.9.3 Cluster Name

If the selected Reports Server is a member of a server cluster, the cluster name is listed here.

14.9.3.1 Metric Summary

The following table shows how often the metric's value is collected.

Target Version Collection Frequency
All Versions Every 5 Minutes

14.9.4 Current Job Load

Provides the number of jobs (failed, successful, and currently running) in the Reports Server for a period of time (5 minutes).

14.9.4.1 Metric Summary

The following table shows how often the metric's value is collected.

Target Version Collection Frequency
All Versions Every 5 Minutes

14.9.5 Current Jobs

Provides the total number of currently running jobs in the Job Queue.

14.9.5.1 Metric Summary

The following table shows how often the metric's value is collected.

Target Version Collection Frequency
All Versions Every 5 Minutes

14.9.6 Failed Jobs

Provides the total number of jobs currently in the Job Queue that were stopped before completion. This includes cancelled jobs as well as those terminated with error.

14.9.6.1 Metric Summary

The following table shows how often the metric's value is collected.

Target Version Collection Frequency
All Versions Every 5 Minutes

14.9.7 Job Load

Provides the number of failed and successful jobs processed by the Reports Server in the last 5 minutes.

14.9.7.1 Metric Summary

The following table shows how often the metric's value is collected.

Target Version Collection Frequency
All Versions Every 5 Minutes

14.9.8 Scheduled Jobs

Provides the total number of jobs currently in the Scheduled Jobs Queue. When this number is greater than 0, it links to the Scheduled Jobs Queue, where you can view details and canceled the scheduled job.

14.9.8.1 Metric Summary

The following table shows how often the metric's value is collected.

Target Version Collection Frequency
All Versions Every 5 Minutes

14.9.9 Since (Start Time)

Provides the date and time the selected Reports Server was last started.

14.9.9.1 Metric Summary

The following table shows how often the metric's value is collected.

Target Version Collection Frequency
All Versions Every 5 Minutes

14.9.10 Successful Jobs

Provides the number of successful jobs processed by the Reports Server in the last 5 minutes.

14.9.10.1 Metric Summary

The following table shows how often the metric's value is collected.

Target Version Collection Frequency
All Versions Every 5 Minutes

14.9.11 Trace File Name

Provides the Reports Server trace file name.

14.9.11.1 Metric Summary

The following table shows how often the metric's value is collected.

Target Version Collection Frequency
All Versions Every 5 Minutes

14.9.12 Trace Mode

Indicates the trace mode specified in the Reports Server configuration file for the trace log file, either Replace (the default) or Append. Trace Replace replaces the existing text in the trace log file with new information. Trace Append appends new information to the end of existing trace log file.

14.9.12.1 Metric Summary

The following table shows how often the metric's value is collected.

Target Version Collection Frequency
All Versions Every 5 Minutes

14.9.13 Transferred Jobs

In a clustered server environment, provides the total number of jobs transferred between the selected Reports Server and other cluster members. For example, if the selected Reports Server receives a request for a job that was run earlier on another cluster member, the request is transferred to the cluster member that provided the earlier result and the result is delivered to the client from the cluster member's cache. Such a transaction would be counted as one transfer within the cluster.

14.9.13.1 Metric Summary

The following table shows how often the metric's value is collected.

Target Version Collection Frequency
All Versions Every 5 Minutes

14.9.14 Version

Provides the current version of the Reports Server.

14.9.14.1 Metric Summary

The following table shows how often the metric's value is collected.

Target Version Collection Frequency
All Versions Every 5 Minutes