Oracle AWR reports generating hourly in Standard Edition 12.1 — oracle-mosc

Database Administration (MOSC)

MOSC Banner

Oracle AWR reports generating hourly in Standard Edition 12.1

edited Mar 5, 2020 11:31AM in Database Administration (MOSC) 16 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center