ORA-00600: internal error code, arguments: [ksu_register_tac-1]

The Problem

When running an alter table command to add a constraint in parallel, the error below was received:

ADD CONSTRAINT p_risk_key_fk
FOREIGN KEY (product_risk_key)
REFERENCES product_details(product_details_key);

ORA-00600: internal error code, arguments: [ksu_register_tac-1], [], [], [], [], [], [], []

ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [skgmrf_release+2236] [PC:0x5631150] [ADDR:0x3ED0] [UNABLE_TO_WRITE] []

The Cause

I looked around on Metalink and found a few references to some Oracle bugs related to this – 839178.1 and 344803.1. Both of the notes say that the issue is related to parallel queries and that it is fixed in, but I am running this version so I disagree.

The Solution

Change the parameter _use_realfree_heap to FALSE. This cannot be changed at the session level so will have to be changed at the DB level, most likely temporarily while you are performing the work and then you can change it back.


Like it, share it...

Category: ORA 600

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *