问题是这样的:
SQL> conn username/passwd@dbserver
Connected.
---登录需要10几秒
SQL> conn username/passwd
Connected.
---瞬间登录
以上操作都是在服务器上操作。
我tnsping dbserver,没有延迟。数据库版本是11.1.0.6,操作系统是Linux。
$ tnsping dbserver 20
TNS Ping Utility for Linux: Version 11.1.0.6.0 - Production on 05-MAY-2011 19:59:27
Copyright (c) 1997, 2007, Oracle.All rights reserved.
Used parameter files:
/u01/app/oracle/product/11.1.0/db_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.11)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = dbserver)))
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (10 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
bash-3.2$
[ 本帖最后由 听海★蓝心梦 于 2011-5-6 08:44 编辑 ]