ORA-6502 , ORA-6512 From Segment Space Advisor (Doc ID 1524010.1)

Last updated on JULY 21, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]
Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.1.0.6 [Release 11.1]
Information in this document applies to any platform.
***Checked for relevance on 21-Jul-2017***

Symptoms

The following error occurs when trying to call Segment Space Advisor either Manually or using Auto Task Jobs :

ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.DBMS_ADVISOR", line 201
ORA-06512: at "SYS.DBMS_SPACE", line 2276
ORA-06512: at "SYS.DBMS_SPACE", line 2538

 The P/L/SQL call stack reported last call to SYS.DBMS_ASSERT:

 ----- PL/SQL Call Stack -----
    object      line  object
    handle    number  name
  37DCDD40       317  package body SYS.DBMS_ASSERT
  37DCDD40       364  package body SYS.DBMS_ASSERT
  33566BBC       512  SYS.WRI$_ADV_OBJSPACE_TREND_T
  33566BBC       564  SYS.WRI$_ADV_OBJSPACE_TREND_T
  33566BBC      1950  SYS.WRI$_ADV_OBJSPACE_TREND_T
  37FD1518       545  package body SYS.PRVT_ADVISOR
  37FD1518      2613  package body SYS.PRVT_ADVISOR
  335BA634       241  package body SYS.DBMS_ADVISOR
  335BA634       196  package body SYS.DBMS_ADVISOR

 



Changes

 Table with User Defined Type that is configured to have a Lob Data type part of this user Defined Datatype :

For eg:

  

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms