You can analyze your host’s CPU and memory utilization by using the Host Capacity Planning application to view and compare detailed information across one or more hosts. For a complete view of CPU usage across all Operations Insights enabled hosts, click CPU under Hosts in the left navigation menu.

By default, you view comprehensive CPU usage information for each host. This lets you compare resource utilization between hosts and identify servers with underused or overused resources. If you have large numbers of hosts, you can search using the host display name, or sort them according the following categories:

• High Utilization
• Low Utilization
• 30 or 90 Day High Utilization Forecast
• 30 or 90 Day Low Utilization Forecast

The Insights table provides the following information:

• Platform Type: The following platforms are supported:
  • Linux
  • Solaris
  • Windows
  The following platforms are supported through hosts monitored by Enterprise Manager only:
  • zLinux
  • AIX
  To add Enterprise Manager targets into Operations Insights see: Adding Enterprise Manager Targets.
• Usage (CPU): 90th percentile value of the daily average CPU Usage and maximum allocation over the selected time period. CPU usage is Avg. Active CPUs over the time period.
• Capacity (CPU): Total host CPU capacity (number of CPUs)
• Utilization (%): Host utilization percentage for the 90th percentile value of the daily average CPU Usage over the selected time period.
• Allocation: Total host CPU capacity (number of CPU)
• Usage Change (%): Percentage change in the linear trend of CPU Usage over the selected time period.
• CPU Load Distribution: CPU Load Statistics (min, 25th percentile, average, 75th percentile, max) of the daily average over the selected time period. The column is sorted by max load value. See below for further explanation.
  Note
  
  CPU Load Distribution is not available for hosts monitored by Enterprise Manager. However, minimum, maximum, and average load values are still shown.

About CPU Load Distribution

The CPU Load Distribution column provides, at a glance, a comprehensive look at CPU load for each host enabled for Operations Insights.

Each host CPU load distribution chart provides essential statistical information and characterizes the distribution of data. At the opposite ends of the chart are the extreme minimum and maximum load values. You see a green, striped bar representing 50% of the collected data (load data falling between the first and third quartile) and shows you at a glance where the load data is compressed, or biased towards the minimum or maximum. A vertical line indicates the median value.

A wide striped bar around the median indicates there is a great deal of CPU load variability. A narrow striped bar around the median indicates a limited range of CPU load variability.

The CPU load distribution chart provides a comprehensive view of the load being place on a single host and gives you insight into optimizing CPU load for that host. When comparing multiple hosts in, for example, a RAC environment, the view lets you see how the load is distributed. If you see load anomalies, it indicates you may need to rebalance the workload across servers.

Analyze Trend and Forecast CPU Usage

Selecting a host from the CPU usage (Insights) table, you can view CPU utilization as well as the trend and usage forecast for that host. Alternatively, you can also specify the breakdown by Databases to view trend and forecast analysis for all databases running on that host.

By default, trending and forecasting are calculated using linear regression. For more advanced analysis, you can have Operations Insights use machine learning to perform the trending and forecasting.

Identify Top Processes

The Top Processes table lets you quickly identify the top five processes running at a particular point in time. You can view the details of a single process in order to trend this process over time.

The Top Processes table is initially empty. To populate the table, select a specific point in time from the Trend & Forecast table. The top five processes running at that point in time will appear in the table.

Top processes shown in the table are based on CPU usage. Data for the table is aggregated per command executed and is collected every minute. The top 10 processes are collected as the data may not be contiguous depending on the variability of the processes.

Note

Top processes collection is:

• Only available for Management Agent hosts and OCI Compute hosts
• Only available for single host analysis. This feature is not applicable when hosts are grouped

Top processes is not available for Enterprise Manager hosts or database cloud service (DBCS) nodes.

To analyze an individual process, click the Details button for that process located in the rightmost column. The Top Processes Trend page displays showing the Command Name and the Process Trend chart for the selected process.

Common Capacity Planning Charts

CPU charts analysis and usage are similar to those used elsewhere in the Capacity Planning application. For an in-depth discussion about Capacity Planning charts, see:

• Insights Table
• Trend and Forecast Chart
• Forecast Backtesting
• Compare CPU Utilization Between Hosts

Click CPU from the Resources list in the navigation pane to gain insight into individual hosts or click Aggregate to view storage utilization across multiple hosts.

The amount of CPU resources and the percentage change in the usage of CPU resources are represented visually, through the size and color of the cells, respectively. The cells that are larger in size use more CPU resources than the smaller cells. The largest cell would be that of the host using the most CPU resources. The color of the cells is determined by the percentage change in the CPU resources used by the hosts.

To analyze CPU utilization across a subset of hosts, use the Grouping menu to group hosts according to Platform Type, Utilization Level, VM Cluster, or Exadata. Click on a specific group to view the trend and forecast for CPU utilization for all hosts within the group. For more information on group tags see: Group by Tags.

For Operations Insights to forecast your resource utilization for a year, there must be at least 13 months of stored data. The forecast value is more accurate when there’s more data. You can use the current and forecast CPU utilization to plan your host capacity. Alternatively, you can also select the Databases option to view trend and forecast analysis for all databases running on that host or Top 5 Processes where the top 5 processes are shown based on CPU usage.

For a complete view of memory usage across all Operations Insights enabled hosts, click Memory under Resources in the left navigation menu.

By default, you view comprehensive memory usage for each host. Viewing the memory utilization for each host lets you compare resource utilization between hosts and identify underused or overused resources. For each host, you view the following:

• Platform Type: The following platforms are supported:
  • Linux
  • Solaris
  • Windows
  The following platforms are supported through hosts monitored by Enterprise Manager only:
  • zLinux
  • AIX
  To add Enterprise Manager targets into Operations Insights see: Adding Enterprise Manager Targets.
• Usage (GB): 90th percentile value of the daily average memory usage over the selected time period
• Capacity (GB): Maximum allocation of host memory
• Utilization (%):Utilization percentage for the 90th percentile value of the daily average memory usage over the selected time period
• Usage Change (%): Percentage change in the linear trend of Memory Usage over the selected time period.
• Memory Load Distribution (GB): Host Memory Load value in (GB) (min, 25th percentile, average, 75th percentile, max) of the daily average over the selected time period. Column sorted by max load value. See below for more information.
  Note
  
  The Memory Load Distribution metric is not available for hosts monitored by Enterprise Manager.
• HugePages Memory (MB): Host total HugePages memory used in MB. See below for more information.
  Note
  
  HugePages Memory is not available for hosts monitored by Enterprise Manager. However, minimum, maximum, and average load values are still shown.

About Memory Load Distribution

The Memory Load Distribution column provides, at a glance, a comprehensive look at the memory load for each host enabled for Operations Insights.

Each host memory load distribution chart provides essential statistical information and characterizes the distribution of data. At the opposite ends of the chart are the extreme minimum and maximum load values. You see a brown striped bar representing 50% of the collected data (load data falling between the first and third quartile) and shows you at a glance where the load data is compressed, or biased towards the minimum or maximum. A vertical line indicates the median value.

A wide striped bar around the median indicates there is a high amount of memory load variability. A narrow striped bar around the median indicates a limited range of memory load variability.

The memory load distribution chart provides a comprehensive view of the load being place on a single host and gives you insight into optimizing memory load for that host. When comparing multiple hosts in, for example, a RAC environment, the view lets you see how the load is distributed. If you see load anomalies, it indicates you may need to rebalance the workload across servers.

About HugePages Memory

HugePages is a feature integrated into the Linux kernel 2.6. Enabling HugePages makes it possible for the operating system to support memory pages greater than the default (usually 4KB). Using very large page sizes can improve system performance by reducing the amount of system resources required to access page table entries. HugePages is useful for both 32-bit and 64-bit configurations. HugePage sizes vary from 2MB to 256MB, depending on the kernel version and the hardware architecture. For Oracle Databases, using HugePages reduces the operating system maintenance of page states, and increases Translation Lookaside Buffer (TLB) hit ratio.

Analyze Trend and Forecast Memory Usage

Selecting a host from the memory insights table, you can view memory consumption as well as the trend and usage forecast for that host. Alternatively, you can also specify the breakdown by Databases to view trend and forecast analysis for all databases running on that host or Top 5 Processes where the top 5 processes are shown based on physical memory usage. Data for the Top 5 Processes is aggregated per command executed and is collected every minute. The top 10 processes are collected as the data may not be contiguous depending on the variability of the processes.

By default, trending and forecasting are calculated using linear regression. For more advanced analysis, you can have Operations Insights use machine learning to perform the trending and forecasting.

Memory charts analysis and usage are similar to those used elsewhere in the Capacity Planning application. For an in-depth discussion about Capacity Planning charts, see:

• Insights Table
• Trend and Forecast Chart
• Compare Memory Utilization Between Hosts

Click Memory from the Resources list in the navigation pane to gain insight into individual hosts or click Aggregate to view storage utilization across multiple hosts.

The amount of memory resources and the percentage change in the usage of memory resources are represented visually, through the size and color of the cells, respectively. The cells that are larger in size use more memory resources than the smaller cells. The largest cell would be that of the host using the most memory resources. The color of the cells is determined by the percentage change in the memory resources used by the hosts.

To analyze memory utilization across a subset of hosts, use the Grouping menu to group hosts according to Platform Type or Utilization Level. Click on a specific group to view the trend and forecast for memory utilization for all hosts within the group.

For Operations Insights to forecast your resource utilization for a year, there must be at least 13 months of stored data. The forecast value is more accurate when there’s more data. You can use the current and forecast memory utilization to plan your host capacity. Alternatively, you can also select the Databases option to view trend and forecast analysis for all databases running on that host or Top 5 Processes where the top 5 processes are shown based on physical memory usage.