My Oracle Support Banner

ORA-600 [KEWRSP_SPLIT_PARTITION_2] During AWR Auto Purge (Doc ID 2017715.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

Next error is reported in the alert log during auto purge of AWR data by MMON process:

ORA-00600: internal error code, arguments: [kewrsp_split_partition_2], [87], [3955215248], [108952], [], [], [], [], [], [], [], []


The trace file shows characteristics like:

*** SERVICE NAME:(SYS$BACKGROUND) 2015-06-03 09:29:25.097
*** MODULE NAME:(MMON_SLAVE) 2015-06-03 09:29:25.097
*** ACTION NAME:(Auto-Purge Slave Action) 2015-06-03 09:29:25.097

 

++++++++++++++++++++++++++++++
Call stack:
++++++++++++++++++++++++++++++
[06]: kewrsgp_split_glob_partn [AWR]<-- Signaling
[07]: kewrsap_split_all_partitions [AWR]
[08]: kewrasad_auto_split_all_dbids [AWR]
[09]: kewraps_auto_purge_slave [AWR]
[10]: kebm_slave_main [MMON]
[11]: ksvrdp [ksv_trace]
[12]: opirip []
[13]: opidrv []
[14]: sou2o []
[15]: opimai_real []
[16]: ssthrdmain []
[17]: main []
[18]: _start []

 

Changes

Upgraded to 11gR2 or 12.1.0.1 from previous version, since this functionality is introduced 11gR2 and above.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.