| Oracle® Pulse User's Guide Release 19.4 E89716-10 |
|
 Previous |
 Next |
Use the Performance menu in the navigation menu to review host and database metrics for the selected environment, as explained in the following sections:
|
Note: The host and database metrics listed here are correct at the time of writing. Owing to the highly flexible and dynamic nature of Oracle Pulse, the host and database metrics in the live app may differ. |
The Performance menu ( 
) provides information about the hosts associated with your environments.
When you first access the Performance dashboard, a message will be displayed asking you to select an environment to report metrics for. To do this, follow the steps in the Personalizing Environments section in Chapter 3, "Working with Oracle Pulse".
By default, host and database metric reports on the Performance dashboard are generated in the GMT time zone. However, you can identify potential issues in your own time zone by changing the time zone in which the reports are generated, as explained in the Changing the Timezone of Your Reports section in Chapter 3, "Working with Oracle Pulse". This allows you to easily relate performance metrics reflected by individual host and database charts and metric comparison charts to anomalies occurring across the selected environment.
To access the Performance dashboard:
Sign in to Oracle Pulse as explained in the Accessing Oracle Pulse section in Chapter 1, "Introduction".
The Pulse Dashboard is displayed by default.
Click Performance in the navigation menu.
The Performance page opens.
Oracle Pulse shows key metrics for each host in the selected environment. Host metrics are shown by default when you select an environment using the Select environment icon ( 
).
Depending on the data collected for the selected host, each record in the table may show the following information:
Max CPU (I/O Wait1 %): This metric represents the average number of jobs waiting for I/O in the last interval. The table shows the maximum number of such jobs over the last 24 hours.
Max CPU (Sys Mode %): For UNIX-based platforms, this metric represents the amount of CPU being used in SYSTEM mode as a percentage of the total CPU processing power. The table shows the maximum amount of CPU over the last 24 hours.
For Windows, this metric represents the percentage of time the process threads spent executing code in privileged mode. The table shows the maximum percentage over the last 24 hours.
Max CPU (User Mode %): For UNIX-based platforms, this metric represents the amount of CPU being used in USER mode as a percentage of the total CPU processing power. The table shows the maximum amount of CPU over the last 24 hours.
For Windows, this metric represents the percentage of time the processor spends in USER mode. This metric displays the average busy time as a percentage of the sample time. The table shows the maximum percentage over the last 24 hours.
Avg CPU (Util %): For UNIX-based platforms, this metric represents the amount of CPU utilization as a percentage of the total CPU processing power available. The table shows the average CPU utilization over the last 24 hours.
For Windows, this metric represents the percentage of time the CPU spends to execute a non-idle thread. CPU (Util %) is the primary indicator of processor activity. The table shows the average percentage over the last 24 hours.
Max Mem (Util %): This metric represents the amount of used memory as a percentage of the total memory. The table shows the maximum amount of used memory over the last 24 hours.
Max Paged In (per sec): For UNIX-based systems, this metric represents the number of pages paged in (read from disk to resolve fault memory references) per second. This metric checks the number of pages paged in for the CPU(s) specified by the Host CPU(s) parameter, such as cpu_stat0 or * (for all CPUs on the system). The table shows the maximum number of pages paged in over the last 24 hours.
For Windows, this metric is the rate at which pages are read from disk to resolve hard page faults. Hard page faults occur when a process refers to a page in virtual memory that is not in its working set or elsewhere in physical memory, and must be retrieved from the disk. When a page is faulted, the system tries to read multiple contiguous pages into memory to maximize the benefit of the read operation. The table shows the maximum page reading rate over the last 24 hours.
Max Paged Out (per sec): For UNIX-based systems, this metric represents the number of pages written out (per second) by the virtual memory manager. This statistic represents the amount of real I/O initiated by the virtual memory manager. This metric checks the number of pages paged out for the CPU(s) specified by the Host CPU(s) parameter, such as cpu_stat0 or * (for all CPUs on the system). The table shows the maximum number of pages written out over the last 24 hours.
For Windows, this metric is the rate at which pages are written to disk to free up space in physical memory. Pages are written back to disk only if they are changed in physical memory, so they are likely to hold data, not code. A high rate of pages output might indicate a memory shortage. Windows writes more pages back to the disk to free up space when physical memory is in short supply. The table shows the maximum page writing rate over the last 24 hours.
Max Run Q Length (5 min avg, per core): This metric represents the average number of processes in memory and subject to be run in the last interval. It checks the run queue. The table shows the maximum number of processes over the last 24 hours.
|
Note: This metric is not available on Windows. |
Max Swap (Util %): For UNIX-based platforms, this metric represents the percentage of swapped memory in use for the last interval. The table shows the maximum percentage over the last 24 hours.
For Windows, this metric represents the percentage of page file environment used. The table shows the maximum percentage over the last 24 hours.
Max Total Processes: This metric represents the total number of processes currently running on the system. It checks the number of processes running on the system. The table shows the maximum number of processes over the last 24 hours.
|
Note: For more information, see 1.2.1 How to Analyze Host Metrics in the >Oracle Fusion Applications Performance and Tuning Guide. |
Use the table to:
sort the records, as explained in the Sorting Records section in Chapter 3, "Working with Oracle Pulse".
display graphical representations of host metrics, as explained in Using Host Metrics Charts.
compare metrics for up to five hosts, as explained in Comparing Host Metrics.
The Performance dashboard also displays graphical representations with detailed information about the corresponding host metric. By default, the chart corresponding to the first metric and host for which there is available data is displayed. However, charts cannot be displayed for metrics and hosts marked with NA, for which there is no data available.
Chart View: The chart view provides a visual representation of the data collected for the host metric, over the specified time interval:
Custom Timeframe: Use this option to show the data collected over a time interval of your choice for a period of up to 3 full months, as explained in the Using the Widget Time Selector section in Chapter 3, "Working with Oracle Pulse".
Last 24 hours: Use this option to show the data collected over the last 24 hours. By default, data is collected every 5 minutes.
This is the default option. Click the other tabs to see the data collected for your desired time interval.
Last 7 days: Use this option to show the data collected over the last 7 days. By default, data is collected every hour.
Last 30 days: Use this option to show the data collected over the last 30 days. By default, data is collected every day, at the same time.
Last 90 days: Use this option to show the data collected over the last 90 days.
Click the legend items to control the information subject to the report.
Click the Open Table View icon ( 
) in the lower right corner of the chart to open the table view in expanded mode.
Table View: The table view provides detailed information about the selected metric:
Date: Specifies the date and time (GMT time zone, by default) when the data was collected from Oracle® Enterprise Manager.
|
Note: For the Last 24 hours report, this column is called Date & Time. |
Host: Specifies the host the data was collected for.
|
Note: For the Last 24 hours report, this column is called Host Name. |
Metric: Specifies the name of the metric.
Value: Specifies the metric value at the date and time when the data was collected from Oracle® Enterprise Manager.
|
Note: This column is only available for the Last 24 hours report. |
Avg.: Specifies the average metric value across the selected time interval.
|
Note: This column is only available for the Last 7 days, Last 30 days, and Last 90 days reports, as well as for reports generated for a custom time period. |
Max.: Specifies the maximum metric value recorded across the selected time interval.
|
Note: This column is only available for the Last 7 days, Last 30 days, Last 90 days reports, as well as for reports generated for a custom time period. |
Min.: Specifies the minimum metric value recorded across the selected time interval.
|
Note: This column is only available for the Last 7 days, Last 30 days, and Last 90 days reports, as well as for reports generated for a custom time period. |
Std. Deviation: Specifies the amount of variation or dispersion of a set of data values.
|
Note: This column is only available for the Last 7 days, Last 30 days, Last 90 days reports, as well as for reports generated for a custom time period. |
Use the table to:
sort the records, as explained in the Sorting Records section in Chapter 3, "Working with Oracle Pulse".
export the data, as explained in the Exporting Data section in Chapter 3, "Working with Oracle Pulse".
Oracle Pulse allows you to review the same metric for up to five different hosts, making it possible for you to compare load on different hosts. Metrics for which there is no data available for a specific time interval can be added for comparison, as data may be available for at least one of the available time intervals.
To compare metrics across different hosts:
Click a host metric for which there is data available.
Click Compare.
The Metric Comparison window opens, showing the metric and the host you have selected.
In the Select Hosts (Max 5) section, select the check boxes corresponding to the hosts that you would like to include in the comparison.
Click Submit.
The comparison chart for the selected metric and hosts is displayed.
By default, the comparison chart shows data for one day. Click any of the 1 Week, 1 Month or 3 Months to display a comparison between the maximum values for the selected hosts over the specified time interval.
(Optional) If you would like to display the comparison chart for a metric other than the one you have selected, use the Metric list to specify the desired metric.
To change the hosts for which you would like to display the comparison chart, expand the Select Hosts (Max 5) section, select the desired hosts, then click Submit.
Click 
to return to the Performance dashboard.
Click the legend items to control the hosts subject to the report.
Click the Open Table View icon ( ) in the lower right corner of the chart to open the table view in expanded mode.
Table View: The table view provides detailed information about the compared metrics:
Date & Time: Specifies the date and time (GMT time zone, by default) when the data was collected from Oracle® Enterprise Manager.
Host: Specifies the host the data was collected for.
Metric: Specifies the name of the metric.
Value: Specifies the metric value at the date and time when the data was collected from Oracle® Enterprise Manager.
|
Note: This column is only available for the Last 24 hours report. |
Max.: Specifies the maximum metric value recorded across the selected time interval.
|
Note: This column is only available for the Last 7 days, Last 30 days, Last 90 days reports, as well as for reports generated for a custom time period. |
Use the table to:
sort the records, as explained in the Sorting Records section in Chapter 3, "Working with Oracle Pulse".
export the data, as explained in the Exporting Data section in Chapter 3, "Working with Oracle Pulse".
Oracle Pulse shows key metrics for each database in the selected environment. To see database metrics for the environment, select Database from the list in the upper left corner of the Performance dashboard.
Each record in the table shows the following information for the corresponding database:
Avg Current Logons Count: This metric represents the current number of logons. The table shows the average number of logons over the last 24 hours.
Avg Global Cache Avg CR Block Req Time (centisec): This metric represents the average time that the current request (CR) block was received, measured in 100ths of a second. The table shows the average time over the last 24 hours.
|
Note: This metric is available only for RAC node databases. |
Avg Network Bytes (per sec): This metric represents the total number of bytes sent and received through the SQL Net layer to and from the database. The table shows the average number of bytes over the last 24 hours.
Avg Physical Writes (per sec): This metric represents the number of data blocks written to the disk per second during this sample period. The table shows the average number of data blocks over the last 24 hours.
Avg Process Limit Util (%): This metric checks for the utilization of the process resource against the values (percentage) specified by the threshold arguments. The table shows the average utilization over the last 24 hours.
Avg Session Limit Util (%): This metric checks for the utilization of the session resource against the values (percentage) specified by the threshold arguments. The table shows the average utilization over the last 24 hours.
Avg Session Logical Reads (per sec): This metric represents the number of logical reads per second during the sample period. The table shows the average number of reads over the last 24 hours.
Avg Total Mem Util (MB): This metric displays the total amount of memory used, in MB. The table shows the average amount of memory over the last 24 hours.
|
Note: For more information, see 1.2.1 How to Analyze Host Metrics in the >Oracle Fusion Applications Performance and Tuning Guide. |
Use the table to:
sort the records, as explained in the Sorting Records section in Chapter 3, "Working with Oracle Pulse".
display graphical representations of database metrics, as explained in Using Database Metrics Charts.
The Performance dashboard also displays graphical representations with detailed information about the corresponding database metric. By default, the chart corresponding to the first metric and database for which there is available data is displayed. However, charts cannot be displayed for metrics and databases marked with NA, for which there is no data available.
Chart View: The chart view provides a visual representation of the data collected for the database metric, over the specified time interval:
Custom Timeframe: Use this option to show the data collected over a time interval of your choice for a period of up to 3 full months, as explained in the Using the Widget Time Selector section in Chapter 3, "Working with Oracle Pulse".
Last 24 hours: Use this option to show the data collected over the last 24 hours. By default, data is collected every 5 minutes.
This is the default option. Click the other tabs to see the data collected for your desired time interval.
Last 7 days: Use this option to show the data collected over the last 7 days. By default, data is collected every hour.
Last 30 days: Use this option to show the data collected over the last 30 days. By default, data is collected every day, at the same time.
Last 90 days: Use this option to show the data collected over the last 90 days.
Click the legend items to control the information subject to the report.
Click the Open Table View icon ( ) in the lower right corner of the chart to open the table view in expanded mode.
Table View: The table view provides detailed information about the selected metric:
Date & Time: Specifies the date and time (GMT time zone) when the data was collected from Oracle® Enterprise Manager.
Database Environment: Specifies the database the data was collected for.
Metric: Specifies the name of the metric.
Value: Specifies the metric value at the date and time when the data was collected from Oracle® Enterprise Manager.
|
Note: This column is only available for the Last 24 Hours report. |
Avg.: Specifies the average metric value across the selected time interval.
|
Note: This column is only available for the Last 7 days, Last 30 days, and Last 90 days reports, as well as for reports generated for a custom time period. |
Max.: Specifies the maximum metric value recorded across the selected time interval.
|
Note: This column is only available for the Last 7 days, Last 30 days, and Last 90 days reports, as well as for reports generated for a custom time period. |
Min.: Specifies the minimum metric value recorded across the selected time interval.
|
Note: This column is only available for the Last 7 days, Last 30 days, and Last 90 days reports, as well as for reports generated for a custom time period. |
Std. Deviation: Specifies the amount of variation or dispersion of a set of data values.
|
Note: This column is only available for the Last 7 days, Last 30 days, and Last 90 days reports, as well as for reports generated for a custom time period. |
Use the table view to:
sort the records, as explained in the Sorting Records section in Chapter 3, "Working with Oracle Pulse".
export data, as explained in the Exporting Data section in Chapter 3, "Working with Oracle Pulse".
Oracle Pulse lets you create groups of services for which to generate your reports. To do this:
Click the Service Group icon ( 
) in the upper right corner of the page.
The Service Group side pane opens.
Select the check boxes corresponding to the services you want to include in your service group.
Click Apply to save your changes and create your service group. The data on the Performance Dashboard is refreshed to show data only for the services you have selected, and the Service Group icon ( ), along with the number of selected services, is displayed in the upper part of the dashboard.
For more information about the Service Group feature, see the Working with Service Groups section in Chapter 3, "Working with Oracle Pulse".
