ORA-600

We are experiencing ORA-600 is routinely raised, which is negatively affecting our operations. We've been working with Oracle, but there hasn't been much progress, so I thought I'd ask the specialists here if they might assist.

The problem is always raised on one table in our EBS system, OR_ORDER_LINES_ALL, and this table is heavily used 24 * 7 with a lot of INSERT + UPDATES. Our database contains 19c. I looked through the alert log and the trace file but couldn't make much sense of it, for example, using the below queries I figured out when the issue occurred and in the enclosed trace file with 3M rows I can see the below rows meaningful as they show an update statement but I don't see anything wrong with the statement and why would it cause ORA-600.

Please offer any insights you have if possible.

SELECT ORIGINATING_TIMESTAMP, DETAILED_LOCATION, MESSAGE_LEVEL, MESSAGE_TEXT, PROBLEM_KEY
  FROM V$DIAG_ALERT_EXT
 WHERE MESSAGE_LEVEL = 1
   AND MESSAGE_TEXT LIKE '%ORA-00600%'
 ORDER BY ORIGINATING_TIMESTAMP DESC; SELECT * FROM V$DIAG_TRACE_FILE_CONTENTS WHERE trace_filename = 'cebsprd_ora_165301_i848794.trc' ORDER BY TIMESTAMP;

Best Regards,
AMIT

--
http://www.freelists.org/webpage/oracle-l





text/plain attachment: cebsprd_ora_165301_i848794.trc.txt