Re: Insert statement hanging

From: Ahmed Aangour <>
Date: Fri, 18 Aug 2017 05:49:11 +0200
Message-ID: <>


Do you have a RTSM report? The first step is trying to understand which part of the exec plan is taking the most part of the execution time ( is it the insert part? Is it a join? Is it a table access part due to an irrelevant nested loop? Etc.)

Le 18 août 2017 05:39, "Ravi Teja Bellamkonda" <> a écrit :

> 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.
> Thanks.
> On Aug 17, 2017 8:25 PM, "Sanjay Mishra" <>
> wrote:
> Hi
> I had insert statement which is selecting database from 3-4 table and
> hanging for several hours. Some main points are
> - The Target Table where insert is going is empty table
> - Select statement as itself is working geting 10K records in few sec
> - Tried to create new table to insert but still not worked
> - Insert session is showing very high wait on CPU and taking big CPU time
> - Bouncing database and running insert worked first few min but as App is
> started , it is again hanged and never complete
> Opened Oracle SR now but they ask for Trace analyzer and so want to check
> experts as what can be other thing to check. This was working fine and
> suddenly started in last few days where no patching on Oracle/OS or major
> changes to involved table are done.
> Environment is Linux with Non-RAC using ASM as storage and Oracle
> 12c(
> Sanjay

Received on Fri Aug 18 2017 - 05:49:11 CEST

Original text of this message