7 Viewing Key Indicators for an Environment

Viewing Environment Performance

The Performance Dashboard allows you to review host and database metrics for the selected environment. Depending on the data collected for the selected host, each record in the host metrics table may show information about:

• the average number of jobs waiting for I/O in the last interval

• the amount of CPU being used in SYSTEM mode as a percentage of the total CPU processing power or the percentage of time the process threads spent executing code in privileged mode

• the amount of CPU being used in USER mode as a percentage of the total CPU processing power or the percentage of time the processor spends in USER mode

• the amount of CPU utilization as a percentage of the total CPU processing power available or the percentage of time the CPU spends to execute a non-idle thread

• the amount of used memory as a percentage of the total memory

• the number of pages paged in (read from disk to resolve fault memory references) per second or the rate at which pages are read from disk to resolve hard page faults

• the number of pages written out (per second) by the virtual memory manager or the rate at which pages are written to disk to free up space in physical memory

• the average number of processes in memory and subject to be run in the last interval

• the percentage of swapped memory in use for the last interval or the percentage of page file instance used

• the total number of processes currently running on the system

The database metrics table on the Performance Dashboard at Environment Level allows you to check:

• the current number of logons

• the average time that the current request (CR) block was received, measured in 100ths of a second

• the total number of bytes sent and received through the SQL Net layer to and from the database

• the number of data blocks written to the disk per second during this sample period

• the utilization of the process resource against the values (percentage) specified by the threshold arguments

• the utilization of the session resource against the values (percentage) specified by the threshold arguments

• the number of logical reads per second during the sample period

• the total amount of memory used, in MB

Viewing Environment Availability

The Availability Dashboard at Environment Level shows records for unplanned outages and service interruptions for the selected environment over the specified period of time

For each unplanned outage or service interruption record, the Environment Availability List shows the unplanned outage or service interruption description, the service the unplanned outage or service interruption is associated with, the environment the unplanned outage or service interruption is associated with, the change request or service request number entered in My Oracle Support, the date and time when the outage started, and the duration of the outage.

Viewing Environment Storage

The Storage Dashboard at Environment Level shows information about storage growth and historical storage usage for each of your organization's Managed Cloud and Technology Cloud instances.

This screen displays information about the following metrics:

• the Storage: Growth report shows the growth in total storage, Oracle-owned storage, and customer-owned storage for your organization's production and nonproduction Managed Cloud instances, or the growth in used storage and allocated storage for your organization's production and nonproduction Technology Cloud instances, over the specified time interval. Use this report to better understand if the current usage fits into the usual usage over time or if there are some increases or decreases in the storage usage for some areas.

• the Storage: Usage table shows the storage usage and allocation by resource, mount point and host across all your organization's Managed Cloud and Technology Cloud instances, based on the latest collected data. Use this report to get a list of all relevant mount points being mounted on the set of hosts which are mapped to the environment, and to determine whether the storage device being used for the mount point is owned by Oracle or by the customer, even if it is hosted in an Oracle data center.

• the Tablespace Usage: Growth report shows the storage usage growth for the tablespaces available in your organization's production and nonproduction environments over the specified time interval. Use the reporting of the tablespace usage inside the database to investigate how the change your project may implement impacts the overall usage inside the database. The reporting can provide both short-term and longer-term growth data. The chart version provides the growth focused on the tablespaces using approximately 80% of the total usage, while the table version includes all tablespaces as they are defined in the database.

• the Tablespace Usage: Projection report shows the overall usage and the projected growth in the amount of storage space used by the tablespaces available in your organization's production and nonproduction environments, based on the data collected during the last month, the last quarter and the last year. Use this report to get an idea of how the expected growth over time will be, based on the growth data for the tablespaces within the environment collected during the last month, the last quarter or the last year.

Viewing Environment Transactions

The Transactions Dashboard at Environment Level shows all transactions that are being monitored for an environment.

For each batch job or user interaction record, the Transactions Dashboard at Environment Level shows the transaction and service name, the instance running the job, the status of the latest request for the job, and the performance details. BTM also shows the response time of the last request for the batch job.

Click the hyperlinked Run By value for any E-Business Suite batch job transaction record to open a new page, showing the following detailed metrics for batch jobs at system level:

• the Latest Requests Dashboard, which is displayed by default, shows a breakdown of the statuses assigned to the processes that execute the requests, as well as all the batch job executions in order of execution for the selected instance:

  • the EBS Status Breakdown report shows a breakdown of the statuses assigned to the processes that execute the requests.

  • the Top Longest Batch Requests Run by <instance name> report shows all the batch job executions in order of execution for the selected instance.

• the Historical Requests Dashboard shows the top concurrent programs for the batch job, listed by run time, during the period between the specified dates and times:

  • the Top Concurrent Programs by Run Time report shows the batch job programs with the highest number of concurrent requests.

  • the Top Concurrent Programs by Count report shows the batch jobs with the greatest number of concurrent requests during the report interval.

Click the hyperlinked Status value for any E-Business Suite batch job transaction record to see the following recent and historical status reports for a specific batch job:

• the Current View Dashboard shows the number of concurrent programs that have completed with a Success status and those that have completed within the median, 75th percentile, and 95th percentile of the runtime of the jobs completed successfully in the last 31 days.

• the Last 24 Hours Dashboard shows the number of concurrent programs that have completed with a Success status and those that have completed within the median, 75th percentile, and 95th percentile of historical runtime.

• the Last 31 Days Dashboard shows the number of concurrent programs that have completed with a Success status and those that have completed within the median, 75th percentile, and 95th percentile of historical runtime in the previous 31 days.

• the Historical Requests Dashboard shows the requests that completed with error, the long pending requests, the pending requests, the requests that completed with warning, as well as the requests that completed with success over the 24 hours before the specified date (CST time zone).

Click the hyperlinked Run By value for any PeopleSoft batch job transaction record to open a new page, showing the following detailed metrics for batch jobs at system level:

• the Current Status Dashboard provides information on what is happening within the job system at a particular time:

  • the Process Status Breakdown report provides a list of the processes that execute the requests and their assigned statuses, offering a starting point from where to analyze a batch issue.

  • the Jobs in Alert State report shows the jobs that have failed, the jobs that have had the InitiatedPendingJobs, InPostingJobs, UnableToPostJobs or QueuedPendingJobs status for more than 30 minutes, or the jobs that are running for more than 10% of the average run time.

  • the Jobs in Alert State History - last 7 Days report shows a 7-day history of the Jobs in Alert State report, allowing you to look at the history of the jobs that have failed, the jobs that have had the InitiatedPendingJobs, InPostingJobs, UnableToPostJobs or QueuedPendingJobs status for more than 30 minutes, or the jobs that are running for more than 10% of the average run time over the last 7 days and providing historical context to the current report.

• the Process Scheduler Dashboard shows the jobs that are currently queued in the job system, providing important details on the scheduling processes.

• the 24HR Summary Dashboard shows the number of job requests of various statuses within the last 24 hours, allowing you to determine whether a slowdown in the system performance is related to a certain scheduled process or to a process occuring during regular working hours.

Click the hyperlinked Status value for any PeopleSoft batch job transaction record to see the following recent and historical status reports for a specific batch job:

• the Request History Dashboard shows the last 10 runs of a specific job, as well as the runs of each status of a specific job in the last 24 hours and 31 days:

  • the Request Summary - Latest report shows the last 10 runs of each status of a specific job.

  • the Request Summary History - Last 24 Hours report shows the runs of each status of a specific job in the last 24 hours.

  • the Request Summary History - Last 31 Days report shows the runs of each status day by day for the last 31 days, with the count of jobs and the time based on the start time.

• the Error History Dashboard shows the errors reported on a specific day for a specific job.

Click the hyperlinked Last Response value for any user interaction or Login Transaction Management (LTM) transaction to open a detailed report of the transaction's performance. The performance chart shows the response time for the user interaction over the specified reporting interval, allowing you to determine when the performance issue started, as well as the user zone affected by the issue. The performance threshold and the historical median are included on the chart for reference. The performance threshold is the longest acceptable response time set for the user interaction or the LTM transaction. You can set the threshold in Enterprise Manager in consultation with your Oracle SDM. The historical median is the value lying at the midpoint of the range of response times measured.

Viewing Environment Incidents

The Incidents functionality at Environment Level shows records for the open and closed service requests created for the selected environment in the specified date range.

For each open or closed service request record, the Environment Incidents List shows the service request description, including the SR number, summary, and contact, the service request status and substatus, the product version the service request is associated with, the date and time when the service request was created, the date and time when the service request was last updated, and the priority level.

Viewing Environment Changes

The Changes functionality at Enviroment Level shows records for the open and closed change requests created for the selected environment in the specified date range.

For each open or closed change request record, the Environment Changes List shows the change request description, including the RFC number, summary, and contact, the change request status and substatus, the start and end date and time the change request is scheduled for, the duration of the change request execution, the date and time when the change request was created, the date and time when the change request was last updated, and the priority level.