23ai数据库通过SQLcl生成AWR报告

‌1. 查看现有快照

SQL> awr list snap;

   SNAP_ID          DBID BEGIN_INTERVAL_TIME                END_INTERVAL_TIME                  FLUSH_LEVEL
__________ _____________ __________________________________ __________________________________ ______________
       793    1475623016 05-SEP-25 04.28.49.548000000 AM    05-SEP-25 04.38.58.339000000 AM    TYPICAL

‌2. 创建新快照命令
SQL> awr create snapshot
Snapshot taken, ID: 794
SQL> awr list snap;

   SNAP_ID          DBID BEGIN_INTERVAL_TIME                END_INTERVAL_TIME                  FLUSH_LEVEL
__________ _____________ __________________________________ __________________________________ ______________
       793    1475623016 05-SEP-25 04.28.49.548000000 AM    05-SEP-25 04.38.58.339000000 AM    TYPICAL
       794    1475623016 05-SEP-25 05.32.53.656000000 AM    05-SEP-25 05.58.51.296000000 AM    TYPICAL

SQL> awr create snapshot
Snapshot taken, ID: 795

3.再次查看现有快照

SQL> awr list snap;

   SNAP_ID          DBID BEGIN_INTERVAL_TIME                END_INTERVAL_TIME                  FLUSH_LEVEL
__________ _____________ __________________________________ __________________________________ ______________
       793    1475623016 05-SEP-25 04.28.49.548000000 AM    05-SEP-25 04.38.58.339000000 AM    TYPICAL
       794    1475623016 05-SEP-25 05.32.53.656000000 AM    05-SEP-25 05.58.51.296000000 AM    TYPICAL
       795    1475623016 05-SEP-25 05.58.51.296000000 AM    05-SEP-25 06.01.01.692000000 AM    TYPICAL

‌4. 生成awr报告

生成快照为794-795‌的HTML格式awr报告

SQL> awr create html 794 795
Report written to: awr_FREE_2025-09-05-05.32.53_2025-09-05-06.01.01.html

当然用原来老的方式也还是可以的

SQL> @?/rdbms/admin/awrrpt

不过用新的命令方式相对来说比较简便一些，感觉少了很多交互，输出的结果内容还是一样的。