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!

Slow Response Across DB Links in 11g

rspeakerAug 14 2012 — edited Aug 14 2012
We have done a number of 11g upgrades recently and are seeing a recurring theme - connecting to remote DBs from an 11g source (hence, acting as can 11g client), are slow. The issue first manifested itself to us as slow response across DB links, but we now see it in multiple aspects. As an example, I have a server with both a 10g and 11g installation on it. Running tnsping from each of these environments to a common target DB show drastically different results. Given that everything else is the same, the only difference being the Oracle version, it seems to me it has to be an 11g-specific issue or behavioral change.

when running the tnsping from the 10g environment, response time is 100 msec
when running the tnsping from the 11g environment, response time is 1430 msec

I can recreate the issue using SQL*Plus to connect to the remote DB.

connecting from the 10g environment takes approximately 1 second
connecting from the 11g environment takes approximately 4 seconds

The target DB is 11.2.0.3.2.

Has anyone else encountered this? I have an SR open with support, they are directing me to Network/SysAdmin, and we are planning some traces.
But if this were DNS or network related, it would seem to me the issue would exist in both 10g and 11g - we only see issues when 11g is the source/client.

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 11 2012
Added on Aug 14 2012
4 comments
810 views