ora-600 [15735] [2164] [2152]



select *from receipt_master
             *
ERROR at line 1:
ORA-00600: internal error code, arguments: [15735], [2164], [2152], [], [], [], [], []





If the Known Issues section below does not help in terms of identifying
  a solution, please submit the trace files and alert.log to Oracle
  Support Services for further analysis.

  This error relates to parallel execution management and to the INIT parameter
  parallel_execution_message_size

  The current parallel_execution_message_size setting will be reflected in Arg [b] of the
  ORA-600 error message. Note that the default value is 2152.

  The value needed to ensure success for the operation being performed is reflected in
  Arg [a] of the ORA-600 error message.

  Therefore, to workaround this error, set the INIT parameter parallel_execution_message_size
  to a value greater than that reported in Arg [a] of the ORA-600 error message.

  For example:

      SQL> alter system set parallel_execution_message_size = 4096 scope=spfile;

  Generally, a value of 4096 (4K) should be sufficient.
 

Post a Comment

And that's all there is to it!

If anyone has any other questions or requests for future How To posts, you can either ask them in the comments or email me. Please don't feel shy at all!

I'm certainly not an expert, but I'll try my hardest to explain what I do know and research what I don't know.

Previous Post Next Post