RDS Oracle の Performance Insights(PIs) は AWR や ASH を使っていない。
なぜなら、
AWR や ASH のない SE2 でも使える
This post discusses the Oracle performance analysis offerings available within Oracle SE. We can use Oracle Statspack, an option pack in Oracle SE, in place of Oracle Automatic Workload Repository (AWR) and Oracle Active Session History (ASH) reports provide performance insights for Amazon RDS for Oracle at no cost in Oracle SE. You can use Statspack in place of ASH and AWR reports. You can also use SQLT, which is an add-on action for response analysis.
Analyzing performance management in Oracle SE using Amazon RDS for Oracle | AWS Database Blog
EE で AWR 使うには CONTROL_MANAGEMENT_PACK_ACCESS をDIAGNOSTIC か DIAGNOSTIC+TUNING にしないといないが、有効にしなくても PIs を使える
To gather performance data and generate reports, Oracle recommends Automatic Workload Repository (AWR). AWR requires Oracle Database Enterprise Edition and a license for the Diagnostics and Tuning packs. To enable AWR, set the CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter to either DIAGNOSTIC or DIAGNOSTIC+TUNING.
Performing common database tasks for Oracle DB instances - Amazon Relational Database Service
から
知らんけど。
そういうことやで、カズ
