ORA-600 [ktspNextL1:4] from SYS.DBMS_SPACE / SYS.DBMS_ADVISOR/WRI$_ADV_OBJSPACE_TREND_DATA
(Doc ID 841158.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.4 to 22.214.171.124 [Release 10.2 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 05-Dec-2014***
We get the errors below in alert.log:
ORA-06512: at "SYS.PRVT_ADVISOR", line 1624
ORA-06512: at "SYS.DBMS_ADVISOR", line 186
ORA-06512: at "SYS.DBMS_SPACE", line 1500
ORA-06512: at "SYS.DBMS_SPACE", line 1566
], , , , , , , 
From the trace file, we see that the failing statement was an INSERT operation:
insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_alloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, NULL, NULL, 'FALSE', :5, 'FALSE'))
In the trace file, in the PL/SQL Call Stack section, we can find the following Oracle packages:
0xa7b85db8 1834 package body SYS.DBMS_SPACE
0xa82a0BB8 344 SYS.RI$_ADV_OBJSPACE_TREND_T
0xa82a0BB8 1485 SYS.RI$_ADV_OBJSPACE_TREND_T
0xa79b07c8 1535 package body SYS.PRVT_ADVISOR
In the trace file, in Call Stack Trace section, we can find one or more of these functions:
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