Re: Insert statement hanging
From: Ravi Teja Bellamkonda <raviteja.bellamkonda7_at_gmail.com>
Date: Thu, 17 Aug 2017 20:51:56 -0700
Message-ID: <CANRhLpA1_aOPK8eAJmbAOwys-8G_nB93jMZU1VGqT1rTSYc6UQ_at_mail.gmail.com>
Date: Thu, 17 Aug 2017 20:51:56 -0700
Message-ID: <CANRhLpA1_aOPK8eAJmbAOwys-8G_nB93jMZU1VGqT1rTSYc6UQ_at_mail.gmail.com>
Sanjay,
Check for TM Contention wait event. Verrify if the referencing child table (foreign key column) got index on it.
Check for p1 p2 and p3 and check the object where the lock is occurring. Valid if it is a lock issue as saod by Dennis.
On Aug 17, 2017 8:34 PM, "Dennis Williams" <oracledba.williams_at_gmail.com> wrote:
Sanjay,
You might query for locks.
Dennis Williams
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 18 2017 - 05:51:56 CEST