Re: Insert statement hanging

Hi,

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" < raviteja.bellamkonda7_at_gmail.com> 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" <dmarc-noreply_at_freelists.org>
> 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(12.1.0.2)
>
>
> TIA
> Sanjay
>
>
>

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