Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Any experts here?
As usual,Sybrand raises a valid point, however the posting referred to long login time differences which, to me, implies that it only happens on the initial connection, not while executing statements within that session..
( A note: if any server administrators change the IP address on one of our dedicated Oracle Database servers without informing me ( and the other DBAs), I hope he/she has a current resume...)
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
>
>"TurkBear" <noone_at_nowhere.com> wrote in message
>news:flpittcv7l8p11q845ahjo6qp3mg59qc5q_at_4ax.com...
>>
>> Check your tnsnames.ora file..does it specify the host by its dns name or
>in dot notation?
>> If your thin driver is faster it may be because you use the actual ip
>address, xxx.xxx.xxx.xxx and not
>> myserver.my.domain.name
>> so no 'trips to the nameserver for decoding and routing' are needed..
>>
>>
>[snip]
>
>Which will occur *of course* only *once* per connection.
>If the OP is connecting and disconnecting for each statement that might be a
>concern.
>If he is not: when someone changes the IP address of that server he is
>toast.
>
>Regards,
>
>Sybrand Bakker
>Senior Oracle DBA
>
>
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Fri Oct 26 2001 - 12:22:17 CDT