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;