RE: DNS causing performance issues

Since /etc/host entries override DNS, I don't see how this could have any affect, assuming that /etc/host is correct. Perhaps you had some routing or bandwidth congestion occurring ?

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dan Norris Sent: Monday, March 17, 2008 3:45 PM
To: Oracle L
Subject: DNS causing performance issues

I'm unable to get a lot of information about the issue reported to me earlier today, but from what I can discern, there is an extract process that runs from sqlplus on serverA and connects to a database on serverB.

The sqlplus session runs a number of pl/sql packages to generate CSV files that are spooled using sqlplus (on serverA).

The symptom reported to me was that the extract processes was slow. It usually takes about 45 minutes and ran for about 5 hours (it did complete successfully). Someone suggested that a previous performance problem was resolved by ensuring that proper reverse DNS records were in

place. In this case, they found that those DNS records did not exist--nor did the forward records, but there were a proper /etc/hosts entries on the servers involved. This process runs once a day. After the

performance issue, the DNS was updated to have proper forward and reverse DNS records. The next day, the extracts ran in about 32 minutes--faster than before. I'm chalking it up to coincidence.

Have any of you seen DNS records make a performance difference for sqlplus operations? I've seen connect-time delays for telnet, ssh, and ftp caused by DNS boo-boos, but not sqlplus. Even so, after connect-time, DNS isn't a part of the picture, so there's no reason for DNS to have an impact on performance after the connection is established. Just looking for any feasible theory on how these two facts

can be connected.

Dan
--

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

--

http://www.freelists.org/webpage/oracle-l Received on Mon Mar 17 2008 - 16:06:55 CDT