Re: connection to the database is slow

> 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.

--
http://www.freelists.org/webpage/oracle-l