Sunday, April 3, 2011

ORA-00600: internal error code

ORA-00600: internal error code, arguments: [15735], [2244], [2152], [], [], [], [], []

solution:

alter system set parallel_execution_message_size=4096 scope=spfile;
shut immediate
startup



On most platforms, the default value is 2148 bytes if parallel_automatic_tuning is set to FALSE, and 4096 bytes if parallel_automatic_tuning = TRUE. The default value is adequate for most applications. Larger values require a larger shared pool. Larger values result in better performance at the cost of higher memory use. For this reason, replication gets no benefit from increasing the size.

When parallel_automatic_tuning = TRUE, message buffers are allocated out of the large pool. In this case, the default is generally higher.

No comments:

Post a Comment

Followers