Re: ORA-600

On 12/11/23 13:17, Amit Saroha wrote:
> Hi All,
>
> 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.

Amit, I am surprised. Do you have Oracle Support account? If not, you should get one. Here is the document returned by ORA-600 diagnostic tool:

ORA-600 [ktspgfb-1] (Doc ID 285847.1)

Apparently, there is a bug:

/There is 1 bug listed. /

*NB* *Prob* *Bug* *Fixed* *Description*

        /II/ 34291862
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=285847.1&id=34291862.8>         

        ORA-600 [ktspgfb-1] or ORA-600[ktecgsc:objdchk_kcbgtcr_5] on update mv master table

I'd open a case with Oracle Support if that has happened to me.

Regards

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

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