We are pleased to announce the General Availability (GA) of Metrics and Performance Hub feature for Exadata Cloud Service and Database Cloud Service in all OCI commercial regions.These capabilities empower customers to monitor their database instances and get comprehensive database performance analysis and management capabilities, natively within the OCI console for ExaCS and DBCS.
Key Customer Benefits
◉ Database metrics help users monitor useful quantitative data, such as CPU and storage utilization, the number of successful and failed database logon and connection attempts, database operations, SQL queries, and transactions, etc. Users can use metrics data to diagnose and troubleshoot problems with their databases.
◉ Performance Hub provides in-depth diagnostics capability for doing Oracle database performance analysis and tuning. With this capability, users can have a consolidated view of real-time and historical performance data.
In order to use Metrics and Performance Hub features for ExaCS and DBCS, users need to enable Database Management Service on their databases. There are two management options (Basic and Full) to choose from. Details about Management options are here.
OCI Console Experience for ExaCS and DBCS
From the Bare Metal, VM, and Exadata service home page, navigate to Exadata VM Cluster → Database (for ExaCS) and navigate to DB Systems → Database (for DBCS). On the Database Details page, click 'Enable' for the label Database Management. Provide the details required and along with that choose between Full Management and Basic Management. There is an option to disable or edit the Database management option as well.
While enabling the Database Management, you will provide user credentials, private endpoint, and choose a management option. There are two management options to choose from: Basic Management and Full Management.
Once the Database Management is enabled, you can view database metrics by clicking on 'Metrics' under section 'Resources'. On the database details page, you can view six of the database metrics: CPU Utilization, Storage Utilization, Execute Count, Block Changes, Parse Count (Total), Current Logons. The additional metrics can be viewed by going to the OCI Database Management service or OCI Monitoring Service.
Once the Database Management is enabled, you can click on the 'Performance Hub' tab on the database details page to view real-time and historical performance data.
When Full management is enabled, Database Management Service-specific features such as Fleet Summary, Advanced Performance Hub features, AWR Explorer, Database Groups, Scheduled Jobs, etc can be accessed by navigating to Observability & Management → Database Management. Some of these features are charge options. Please check with your Oracle Sales Representative.
Considerations
◉ Database Metrics feature is available via OCI console and API, whereas Performance Hub is available via OCI console only.
◉ Database Metrics and Performance Hub feature is available for container databases (CDBs) on ExaCS and DBCS. The support for pluggable databases (PDBs) is being worked on as a roadmap item.
◉ Full Management option of Database Management is an extra-cost option.
Scope
This announcement is applicable for ExaCS and DBCS. Support for Gen2 Exadata Cloud@Customer is on the roadmap.
Availability
Support for Metrics and Performance Hub is available for ExaCS and DBCS in all OCI commercial regions.
Source: oracle.com
Posts
0 comments:
Post a Comment