Oracle AWR reports generating hourly in Standard Edition 12.1
Hi,
We are a standard edition company and recently found out that AWR is generating snapshots hourly on our databases and I dont understand why.
SQL> col systimestamp form a35
SQL> col most_recent_snap_time form a25
SQL> col snap_interval form a17
SQL> select systimestamp, most_recent_snap_time, snap_interval from wrm$_wr_control where dbid = (se
lect dbid from v$database);
SYSTIMESTAMP MOST_RECENT_SNAP_TIME SNAP_INTERVAL
----------------------------------- ------------------------- -----------------
11-FEB-20 17.06.44.092000 +00:00 11-FEB-20 17.00.55.015 +00000 01:00:00.0
SQL>
SQL> col instance_number form 999 head INST
SQL> col begin_interval_time form a25
SQL> col flush_elapsed form a17
SQL> col status form 999