Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Insert still running for a long time

Charles MSep 7 2017 — edited Sep 20 2017

Hi All -

We have an insert that is running forever. In this case, it began yesterday at 5 pm and still shows as running in OEM at this time. This is coming from a 3rd party application (on an Oracle database). We are in touch with their team, but progress has been slow. Please help us indentify what is causing this poor performance.

First, we are wondering if it has even done anyting. Meaning, any inserts ... or is it just waiting/reading. I do have the SQL ID, and I did run an AWR report. I can provide whatever is necessary to help understand. Please help us understand what is happening.

3rd Party Application / DB version 11.2.0.4

Regards,

Charles

This post has been answered by AndrewSayer on Sep 8 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 18 2017

Added on Sep 7 2017

#11gr2, #general-database-discussions, #insert, #sql

19 comments

6,189 views