SQL连接打开时间很长 [英] Very long SQL connection opening time

问题描述

最近，我们已经将Oracle 9.2.0.6生产数据库从Windows 32位RAC(2个节点)迁移到Linux 64位环境. Linux 64位环境的内存是Windows 32位环境的8倍，Linux 64位环境具有更快的磁盘(RAID 10与Windows的RAID 5相比).

Recently, We have migrated our Oracle 9.2.0.6 production database from Windows 32bit RAC (2 nodes) to Linux 64 bit environment. Linux 64 bit environment has 8 times more memory than Windows 32 bit environment and Linux 64 bit has faster disk ( RAID 10 compare to RAID 5 of windows).

但是，在此迁移之后，我们注意到sql连接时间已大大增加.一段时间后，打开连接需要16秒钟.我们使用了不同的驱动程序(JDBC，ODBC，OCI)和SQLPlus.但是，我们注意到sql连接时间没有差异.我们已经调查了网络，但没有发现网络有问题.

However, after this migration, we have noticed sql connection time has been increased significantly. Some time, it is taking 16 seconds to open a connection. We have used different driver (JDBC, ODBC, OCI) and SQLPlus. But, we have noticed no difference in sql connection time. We have investigated network, but noticed no problem with network.

有时，打开单个连接大约需要16秒钟.该数据库具有大约50000个用户架构.

Some time, it is taking around 16 seconds to open a single connection. This database has around 50000 user schema.

有人可以告诉我如何减少连接打开时间吗?您的帮助将不胜感激.

Can anybody tell me what can be done to reduce the connection opening time? Your help would be appreciated.

推荐答案

在我们的例子中是DNS.在我们的管理员注释掉了服务器端的所有DNS条目之后，系统开始立即进行响应.

It was DNS in our case. After our admin commented out all DNS entries on the side of the server the system started responding without delay.

这篇关于SQL连接打开时间很长的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！