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)
TIASanjay