OraFAQ Forum: Server Administration » ORA-06512 in AlertLog

Home » RDBMS Server » Server Administration » ORA-06512 in AlertLog

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-06512 in AlertLog [message #197094]

Tue, 10 October 2006 00:48

thiyagaraj
Messages: 41
Registered: August 2006

Member

Hi
I have an automated schema statistics gathering running in DBMS_jobs and it runs in the basis of one day of interval.It ran well for the past two months,suddenly
yesterday and also today it throws an error message in alertlog file as follws,

AlertLog Error Stack:

Errors in file /u01/app/oracle/product/9.2.0/admin/XXX/bdump/XXX_j000_9615.trc:
ORA-00600: internal error code, arguments: [16515], [D], [31], [25542], [15], [0], [], []
Mon Oct 9 16:02:07 2006
Errors in file /u01/app/oracle/product/9.2.0/admin/XXX/bdump/XXX_j000_9615.trc:
ORA-00600: internal error code, arguments: [16515], [D], [31], [25542], [15], [0], [], []
ORA-06512: at "SYS.DBMS_STATS", line 9136
ORA-06512: at "SYS.DBMS_STATS", line 9616
ORA-06512: at "SYS.DBMS_STATS", line 9800
ORA-06512: at "SYS.DBMS_STATS", line 9854
ORA-06512: at "SYS.DBMS_STATS", line 9831
ORA-06512: at "SYS.STAT", line 9
ORA-06512: at line 1

XXX_j000_9615.trc Error Stack:

ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [16515], [D], [31], [25542], [15], [0], [], []
Current SQL statement for this session:
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN stat; :mydate := next_date; IF
broken THEN :b := 1; ELSE :b := 0; END IF; END;
----- PL/SQL Call Stack -----
object line object
handle number name
38630f288 232 package body SYS.DBMS_STATS
38630f288 3092 package body SYS.DBMS_STATS
38630f288 8923 package body SYS.DBMS_STATS
38630f288 9067 package body SYS.DBMS_STATS
38630f288 9616 package body SYS.DBMS_STATS
38630f288 9800 package body SYS.DBMS_STATS
38630f288 9854 package body SYS.DBMS_STATS
38630f288 9831 package body SYS.DBMS_STATS
386458da8 9 procedure SYS.STAT
3817bb828 1 anonymous block

Can anyone provide me with the exact cause of this problem and the solution.

Thanks
Raaj Embarassed