Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Indexing TNSNAMES?

Indexing TNSNAMES?

From: Ed Stevens <Ed_Stevens_at_nospam.noway.nohow>
Date: Tue, 13 Nov 2001 14:16:08 GMT
Message-ID: <3bf12845.59698391@ausnews.austin.ibm.com>


A few days ago I posted a question here (see "Puzzling Results of Using Bequeaqth") that didn't draw any responses, so I posted it to MetaLink. (I generally find this NG provides faster response and better advice than MetaLink). Their response was to point me to a white paper -- CR 212951 --that didn't even approach the subject of my question, but did have a couple of statements I found interesting:

"When a client application initiates a transaction to retrieve data
from a server, the entire Tnsnames.ora file is read."

"Instead of reading the entire file and scanning for the relevant
entry, it is better to implement an indexing method."

First, while I had never been told otherwise, I always assumed tnsnames was read until the relevant entry was found, rather than reading the entire file into a buffer then scanning. Right or wrong?

Second, and much more interesting . . . I've never heard of indexing tnsnames. What is this all about?

BTW, I'm still searching for an answer to my question in "puzzling performance results with bequeath connection" if anyone wants to take a crack at it.

Thanks.

Received on Tue Nov 13 2001 - 08:16:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US