Skip to Main Content

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
Post Details
Added on Nov 10 2016
40 comments
23,051 views