Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TABLE SYS.WRP$_REPORTS: ADDED INTERVAL PARTITION

Prakasam RJul 27 2015 — edited Jul 28 2015

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 25 2015
Added on Jul 27 2015
12 comments
9,177 views