tns連線非常慢

BTxigua發表於2010-08-09
以下所有的操作都是在本機執行的，所以可以排除網路問題。

$ tnsping mssdb2_255

TNS Ping Utility for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production on 09-AUG-2010 08:55:03

Copyright (c) 1997, 2006, Oracle Corporation.  All rights reserved.

Used parameter files:
/oracle/app/oracle/product/9.2.0/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.201.255.10)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME =mssdb2)))
OK (10470 msec)

TNS ping 耗時1萬多毫秒，當時的系統負載情況，其實系統也沒有忙到這種程度：
$ vmstat 1
System Configuration: lcpu=16 mem=23647MB
kthr    memory              page              faults        cpu   
----- ----------- ------------------------ ------------ -----------
r  b   avm   fre  re  pi  po  fr   sr  cy  in   sy  cs us sy id wa
11  0 4203248 1423059   0   0   0   0    0   0 3932 38075 12585 76 12  5  7
8  0 4202970 1423327   0   0   0   0    0   0 6268 24592 15878 69 15  7  9
11  0 4204770 1421521   0   0   0   0    0   0 1747 25479 4157 82 12  2  3
9  0 4206332 1419947   0   0   0   0    0   0 1049 33114 3647 77  7  8  8
10  0 4206948 1419321   0   0   0   0    0   0 1136 28215 3661 70 11  9 10
10  0 4207126 1419132   0   0   0   0    0   0 1184 19773 3640 68 10 13 10
9  0 4205677 1420569   0   0   0   0    0   0 1329 34922 3890 76 11  5  8
12  0 4206259 1419973   0   0   0   0    0   0 994 25841 3100 84  6  2  7
16  0 4206841 1419387   0   0   0   0    0   0 3257 41001 8264 83  9  4  4
11  0 4205584 1420633   0   0   0   0    0   0 1524 25640 3892 70  9 14  8
5  0 4205898 1420307   0   0   0   0    0   0 1291 22445 4421 59  9 21 11
6  0 4206335 1419863   0   0   0   0    0   0 1080 43732 3422 64 11 16 10
6  0 4205308 1420878   0   0   0   0    0   0 3463 29527 8693 58 16 16 11
8  0 4208394 1417784   0   0   0   0    0   0 2451 22139 6769 57 14 21  8
7  0 4210456 1415714   0   0   0   0    0   0 2613 17220 8778 43 16 26 15
5  0 4213319 1412841   0   0   0   0    0   0 4048 19100 9205 41 18 22 19
6  0 4213943 1412179   0   0   0   0    0   0 2264 14892 6908 57 15 12 16
7  0 4213981 1412132   0   0   0   0    0   0 1723 22403 5631 56 11 17 16
8  0 4212196 1413907   0   0   0   0    0   0 1820 15836 5077 62 11 14 13
7  0 4212064 1414025   0   0   0   0    0   0 2038 19721 5990 74  8  6 11

另外做了sqlplus來進行登陸測試
$ date
Mon Aug  9 08:59:27 BEIST 2010
$ sqlplus bpm/xxxxxx@mssdb2_255

SQL*Plus: Release 9.2.0.8.0 - Production on Mon Aug 9 08:59:27 2010

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.8.0 - Production

quit

SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.8.0 - Production
$ date
Mon Aug  9 09:00:15 BEIST 2010
這個耗時48秒。

如果不使用監聽，連線就相當快了。
$ date
Mon Aug  9 08:59:56 BEIST 2010
$ sqlplus bpm/xxxxxx
SQL*Plus: Release 9.2.0.8.0 - Production on Mon Aug 9 08:59:56 2010

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.8.0 - Production

quit

SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.8.0 - Production
$ date
Mon Aug  9 08:59:57 BEIST 2010

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/10867315/viewspace-670610/，如需轉載，請註明出處，否則將追究法律責任。

相關文章