Re: connection to the database is slow
- From: Tanel Põder <tanel.poder.003@xxxxxxx>
- To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 3 Feb 2006 13:19:16 -0600
I would check for DNS issues first: try to configure the tnsnames.ora/jdbc
url etc with IP address instead of machine/logical host name.
Same here.
You could verify a DNS issue by truss-ing or strace-ing the tnslistener
process during a new connection...
$ strace -T -p 3057
Process 3057 attached - interrupt to quit
poll([{fd=8, events=POLLIN|POLLRDNORM, revents=POLLIN|POLLRDNORM}, {fd=8,
events=0}, {fd=10, events=POLLIN|POLLRDNORM}, {fd=10, events=0}, {fd=11,
events=POLLIN|POLLRDNORM}, {fd=11, events=0}, {fd=-1}], 7, -1) = 1
<1.809157>
gettimeofday({1138994188, 114434}, NULL) = 0 <0.000661>
getsockname(8, {sa_family=AF_INET, sin_port=htons(1521),
sin_addr=inet_addr("0.0.0.0")}, [16]) = 0 <0.000064>
getpeername(8, 0xbfff94c4, [16]) = -1 ENOTCONN (Transport endpoint is
not connected) <0.000049>
^^^
maybe the getpeername() takes a lot of time in your case, the listener could
be doing reverse DNS lookup
Tanel.
--
//www.freelists.org/webpage/oracle-l
Other related posts: