12 Replies Latest reply on Jul 28, 2015 9:30 AM by John Stegeman

    TABLE SYS.WRP$_REPORTS: ADDED INTERVAL PARTITION

    Prakasam R

      Dear All,

       

      After upgade 11gR2 to 12c database, we got this line "TABLE SYS.WRP$_REPORTS: ADDED INTERVAL PARTITION SYS_P1778 (2034) VALUES LESS THAN (TO_DATE(' 2015-07-28 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))" in the alert log for every day. This is information or error. Please suggest me.

       

       

      Alert log:

      ==================================================================

      Mon Jul 27 00:04:50 2015

      Incremental checkpoint up to RBA [0x6d.19e72f.0], current log tail at RBA [0x6d.19fd74.0]

      Mon Jul 27 00:24:51 2015

      Incremental checkpoint up to RBA [0x6d.1a0343.0], current log tail at RBA [0x6d.1a04e9.0]

      Mon Jul 27 00:44:52 2015

      Incremental checkpoint up to RBA [0x6d.1a0a01.0], current log tail at RBA [0x6d.1a0b70.0]

      Mon Jul 27 01:04:54 2015

      Incremental checkpoint up to RBA [0x6d.1a0f55.0], current log tail at RBA [0x6d.1a2455.0]

      Mon Jul 27 01:12:32 2015

      TABLE SYS.WRP$_REPORTS: ADDED INTERVAL PARTITION SYS_P1778 (2034) VALUES LESS THAN (TO_DATE(' 2015-07-28 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

      TABLE SYS.WRP$_REPORTS_DETAILS: ADDED INTERVAL PARTITION SYS_P1779 (2034) VALUES LESS THAN (TO_DATE(' 2015-07-28 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

      TABLE SYS.WRP$_REPORTS_TIME_BANDS: ADDED INTERVAL PARTITION SYS_P1782 (2033) VALUES LESS THAN (TO_DATE(' 2015-07-27 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

      Mon Jul 27 01:24:55 2015

      Incremental checkpoint up to RBA [0x6d.1a357d.0], current log tail at RBA [0x6d.1a3788.0]

      Mon Jul 27 01:44:56 2015

      Incremental checkpoint up to RBA [0x6d.1a3cb2.0], current log tail at RBA [0x6d.1a3e22.0]

      Mon Jul 27 02:04:58 2015

      Incremental checkpoint up to RBA [0x6d.1a4232.0], current log tail at RBA [0x6d.1a58c3.0]

      Mon Jul 27 02:24:59 2015

      Incremental checkpoint up to RBA [0x6d.1a5e6d.0], current log tail at RBA [0x6d.1a600c.0]

      ==================================================================================

       

       

      Thanks and Regards,

      Prakasam R