SQL Performance (MOSC)

MOSC Banner

Insert into table through dblink very slow after upgrade database to 11.2.0.4

edited Jul 13, 2017 1:46PM in SQL Performance (MOSC) 8 commentsAnswered

Hi all!

After I upgrade the database from 11.2.0.1. to 11.2.0.4, I have become very slow query through dblink, who previously worked quickly, the maximum per minute. I'm trying to insert into a local table from a remote database via dblink. While running query, i see event "sql*net message from dblink" with expectations that can hang very long. I tried to gather stats on both databases, gathered statistics on the full database, data dictionary and fixed objects, but nothing helped. However, if I do CREATE TABLE AS SELECT * FROM tables@dblink, then all too quickly works. What could happen

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center