:

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:

ALTER TABLE policy
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 10.2.0.4, 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.

ALTER SYSTEM SET _use_realfree_heap=FALSE SCOPE=BOTH|MEMORY;

Like it, share it...

Category: ORA 600


Related Posts

Leave a Reply

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