Home icon

Tune Amazon RDS for Oracle CDBs with Amazon Performance Insights

Database Blog

The article discusses how to utilize Amazon RDS Performance Insights to monitor and analyze the performance of pluggable databases (PDBs) within an Oracle Container Database (CDB) on Amazon RDS for Oracle.

Specifically, the article covers:

  • Overview of Oracle Multitenant architecture with CDBs and PDBs on Amazon RDS for Oracle
  • Limitations of Amazon CloudWatch and Enhanced Monitoring for analyzing PDB-level performance
  • How Amazon RDS Performance Insights can visualize and analyze PDB-level load and resource-intensive SQL queries
  • Considerations for enabling and using Performance Insights on RDS for Oracle CDBs
  • Step-by-step guide on using the Performance Insights dashboard to analyze PDB performance metrics, top SQL queries, and wait events
  • Conclusion highlighting the benefits of using Performance Insights for Oracle CDB performance tuning
Go to article

The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.

Related articles

Nov 7
2024
Amazon RDS for Oracle now supports October 2024 Release Update
Dec 17
2024
Migrating Oracle Databases from Exadata to Amazon RDS for Oracle: Addressing Performance Considerations
Oct 4
2024
Analyze Amazon RDS for Oracle database object dependencies
Oct 24
2024
Amazon RDS for Oracle now supports Oracle Application Express (APEX) Version 24.1

The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.