5 Administer Exadata Cloud Service Target
After the discovery of Exadata Cloud Service target, you can perform the following administration tasks:
Navigate to Individual Targets
You can drill down to a component target of the Exadata Cloud Service (such as clusters, a database instance, or an Exadata Storage Server).
-
From the Targets menu, select Exadata.
Enterprise Manager displays the Oracle Exadata Database Machines and Cloud Services page showing all the available Exadata targets.
-
From the Oracle Exadata Database Machines and Cloud Services page, select the Exadata Cloud Service target whose components you want to view.
Enterprise Manager displays the Oracle Exadata Cloud Service page showing an General, Members, and Incidents section for the selected cloud target.
-
From Oracle Exadata Cloud Service page, use the left navigation icon
to view the navigation panel. Expand the list of available targets that
comprise the Exadata Cloud Service.
-
Click the target to which you want to navigate.
View Cloud Target Alerts
You can view alerts on Exadata Cloud Service and drill down to details about each alert. These alerts may be performance/configuration metrics or hardware faults.
View Metrics of the Individual targets
You can view the performance metrics of the dependent targets of Exadata Cloud Service by following these steps:
Delete a Target Using the UI
You can delete the cloud target or any of its member targets by using UI.
If you want to delete the cloud target and its member targets using the UI, then first delete the member targets individually using the following steps. After deleting the member targets, delete the cloud target.
-delete_members option
with the delete_target command. See Delete the Cloud Target and Its Member Targets.
Manage Exadata Storage Server Metrics and Alert Settings
To access the settings for Exadata Storage Server metrics/alert:
- To change a setting, click Monitoring, then Metric and Collection Settings from the Exadata Storage Server menu. The default View option "Metrics with thresholds" is displayed. You can modify the following parameters:
-
Warning Threshold
-
Collection Schedule - click the link to set a collection schedule.
-
Click the Edit icon
for advanced settings.
-
Accessing Oracle Analytics Server Reports
Access the Oracle Analytics Server to run the Exadata report Exadata Cloud Service Capacity Planning Report to understand the health and utilization of your Exadata portfolio.
-
To access the Exadata reports, you will need a Standalone Oracle Analytics Server. See Standalone Oracle Analytics Server in Oracle Enterprise Manager Cloud Control Administrator's Guide.
-
Expand the Exadata Reports tree.
The link to Exadata Cloud Service Capacity Planning Report is displayed. This is the capacity planning report for Oracle Exadata Cloud.
-
Click the link on the report to view it. In the resulting report page, you can optionally obtain the report in PDF, HTML, RTF, Excel or PowerPoint formats.
Exadata Cloud Service Capacity Planning Report
The Capacity Planning Report enables you to analyze and visualize the utilization and health of Exadata resources like storage, CPU, memory, and IO. It also helps to plan for upcoming resource requirements.
Some of the benefits of monitoring your resources:
- Optimum Resource Usage: Helps you to fine tune the size and number of resources to ensure that you are getting optimum output
- Cost Efficiency: You pay for the exact amount of resources that you will use
- Predictive Capacity Planning: Based on the past performance of your configuration, you can plan your resources for future requirements
- Improved IT Management: Helps you to keep a close watch on the performance and health parameters of your resources
Configuration
This section reports the name of the Exadata Cloud Service target for which the capacity planning report is generated. It also lists the various hosts and their corresponding host types associated with the configuration. The host type can be Database Node or Storage Cell.
Global Summary
This section summarizes the key metrics of your configuration for the time ranges like Last 24 hours, Last 7 Days, Last 31 Days, and Last 365 Days. The same key metrics are analyzed in greater details in the following sections of the report.
The metrics for Last 24 Hours time range are calculated based on the metric collection frequency.
The metrics for the Last 7 Days time range are calculated based on the hourly aggregated data.
The metrics for the Last 31 Days and Last 365 Days time ranges are calculated based on the daily aggregated data.
This is an example global summary of an Exadata Cloud Service:
Storage Capacity Planning Details
As an administrator, you can use Storage Capacity Planning Details section to diagnose and resolve issues in your storage systems, thus resulting in better performance of not only the storage systems but also the applications relying on them. This section displays the current and historical storage space usage information for all the disk groups.
The current space usage is reported based on the data that was last collected. The following parameters are tabulated for each disk group:
- Redundancy
- Used (%)
- Total Size (GB) - Raw
- Free Space (GB) - Raw
- Used Space (GB) - Raw
- Total Size (GB) - Usable
- Free Space (GB) - Usable
- Used Space (GB) - Usable
The historical report is generated based on the data available for the selected time range. The following parameters are tracked and plotted in a line chart along the X-axis against time which is on Y-axis:
- Historical Space Usage By Disk Group (GB) - Usable
- Historical Space Usage By Disk Group (%) - Usable
- Historical Total Space Usage (GB) - Raw
- Historical Total Space Usage (GB) - Usable
- Historical Space Usage by the Top 5 Serviced Databases - As seen daily
Following is an example of the graph for Historical Space Usage by Disk Group (%) - Usable:
CPU and Memory Capacity Planning Details
Your CPU and Memory utilizations should not be at critical limits during normal load hours. You should determine CPU and Memory utilizations based on your application needs, including CPU and Memory cycles for peak usage. If your CPU and Memory utilizations are optimized at 100% during normal load hours, you have no capacity to handle a peak load. A mismatch between the capacity and the demands can result in unsatisfactory utilization of resources.
In the CPU and Memory Capacity Planning Details section, CPU Utilization and Memory Utilization parameters of each database node are measured and plotted in line charts for the time ranges Last 24 Hours, Last 7 Days, Last 31 Days, and Last 365 Days.
Following is an example of the CPU Utilization metric for the 7 days time range:
Following is an example of the Memory Utilization metric for the 24 hours time range:
IO Capacity Planning Details
The IO Capacity Planning Details section displays the current and historical IO, throughput and disk utilization aggregated across all the storage servers for the selected Exadata Cloud Service target. It summarizes the amount of data being stored in the disks, the read/write throughput rate, and load handling in response to normal and peak demands. Use this report to optimize your disk resources and to plan for future demands.
The following parameters of Cell Disk and Flash are measured and plotted in line charts for the time ranges Last 24 Hours, Last 7 Days, Last 31 Days, and Last 365 Days:
- Average Cell Disk Utilization
- Aggregate Cell Disk Read and Write throughput
- Disk Read Throughput
- Disk Read Throughput
- Aggregate Cell Disk IOPS
- Read IOPS
- Write IOPS
- Total IOPS
- Average Cell Disk Load
- Average Cell Disk Response Time
- Average Flash Utilization
- Aggregate Flash Read and Write throughput
- Flash Read Throughput
- Flash Read Throughput
- Aggregate Flash IOPS
- Read IOPS
- Write IOPS
- Total IOPS
- Average Flash Load
- Average Flash Response Time
Following is an example of the average utilization of Flash over a 7-day time range:
Following is an example of the various IO capacity metrics of Flash over a 7-day time range:
Following is an example of the average utilization of Cell Disk over a 24-hour time range:
Following is an example of the various IO capacity metrics of Cell Disk over a 24-hour time range:
