Monday 22 July 2013

Oracle RAC 10g: ORA-00600: internal error code

  dbms_stats.gather_schema_stats(
        ownname => 'POWERCARD',
        estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE ,
        degree => DBMS_STATS.DEFAULT_DEGREE,
        granularity => 'AUTO' ,
        cascade => TRUE );
end;
/
  3    4    5    6    7    8    9 
begin
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [15735], [2184], [2152], [], [], [],
[], []

Solution: Set the set parallel_execution_message_size=xxxx where xxxx is
greater than the 2nd argument of the ORA-00600.  Again as per example :-
==============================================================================
SQL> show parameter parallel_execution_message_size


NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
parallel_execution_message_size      integer     2152

SQL> ALTER SYSTEM SET parallel_execution_message_size=2156 SCOPE=SPFILE SID='*';

System altered.

SQL>
SQL>
SQL> shutdown immediate;
Database closed.
Database dismounted.
startup;

No comments:

Post a Comment

Number of Visitors