Skip to Main Content

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!

Simple insert into table hanging

AParmNov 10 2016 — edited Nov 11 2016

Hi there,

I have a query that joins 2 tables, 1 table has 2 million records and other 1 million records, the query returns 1 record in less than 1 second, both the 2 tables being joined are accessed across a database link, despite the query running in less than a second, if I do a simple insert using the query it just hangs, and I don't understand why. The table is not locked, I have tried dropping the table before the insert and recreating it, to ensure there are no locks.

If I look at the wait events all  I a can see this

I am running 12c on Windows, the database link is to database in another pluggable database in the same container.

SQL*Net message from dblink

This post has been answered by AParm on Nov 11 2016
Jump to Answer

Comments

Moving this old post to the correct forum.

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 9 2016
Added on Nov 10 2016
40 comments
24,998 views