Oracle 查询 AWR 数据采样时间间隔及历史快照保留时间

一、查询方法：

col banner_full for a70
set lines 200
select banner_full from v$version;

col snap_interval for a20          
col retention for a20
col src_dbname for a20
set lines 200
select * from dba_hist_wr_control;

二、示例：

SQL> col banner_full for a70
SQL> set lines 200
SQL> select banner_full from v$version;

BANNER_FULL
----------------------------------------------------------------------
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.14.0.0.0
SQL> col snap_interval for a20            
SQL> col retention for a20
SQL> col src_dbname for a20
SQL> set lines 200
SQL> select * from dba_hist_wr_control;

   DB Id    SNAP_INTERVAL        RETENTION            TOPNSQL        CON_ID   SRC_DBID SRC_DBNAME
----------- -------------------- -------------------- ---------- ---------- ---------- --------------------
 1861158095 +00000 01:00:00.0    +00008 00:00:00.0    DEFAULT             0 1861158095 CDB$ROOT
SQL> 

解释：

SNAP_INTERVAL=+00000 01:00:00.0  表示采样间隔是 1 小时
RETENTION=+00008 00:00:00.0      表示采样数据保留期限是 8 天