<ul><li>Amazon RDS for Oracle now supports the Oracle Multitenant configuration on versions 19c and 21c.</li><li>Oracle Multitenant can consolidate standalone databases by creating or migrating to PDBs.</li><li>Amazon RDS Performance Insights helps users visualize and analyze workload of individual PDBs in a CDB.</li><li>Performance Insights is automatically enabled at database creation, using only around 1% of a vCPU.</li><li>Performance Insights stores seven days of performance history in a rolling window.</li><li>By slicing database load by the PDB and SQL dimensions, users can identify top queries running on each PDB.</li><li>Users can monitor database load running at the PDB level through Performance Insights dashboard.</li><li>This feature is particularly useful for identifying the most loaded PDB to simplify the troubleshooting process.</li><li>Performance Insights is useful to identify individual PDB performance and quickly identify changes in the performance of a SQL query.</li><li>It is the only native AWS tool for looking at database level information.</li></ul>

Tune Amazon RDS for Oracle CDBs with Amazon Performance Insights

Discover more