Re: paper on SQL*Net performance tuning

On Fri, 14 Dec 2001 18:42:05 GMT, Ed_Stevens_at_nospam.noway.nohow (Ed Stevens) wrote:

>I have been studying a document I downloaded from Oracle, entitled "SQL*Net
>Performance tuning Utilizing Underlying Network Protocol." At first I thought
>it might be quite useful, but the more I study it, the more I begin to wonder .
>. . the author made several assertions that left me scratching my head.
>
>At one point, speaking of the TNSNAMES.ORA file, he says, "Instead of reading
>the entire file and scanning for the relevant entry, it is better to implement
>an indexing method." Later, under "Recommendations/Standards" he lists "3.
>implementing indexing method to read Tnsnames.ora file"
>
>Now, I've never heard or read of a mechanism for indexing access to TNSNAMES.
>So who is this recommendation for? Certainly we DBAs and developers have no way
>of doing this, so is he directing this at an internal Oracle audience
>responsible for SQL*Net implementation? Or is he just being uselessly
>theoretical?
>
>He also spends a lot of time talking about configuring Array Size, and in his
>"Recommendations/Standards" he lists "2. application must have the capability to
>determine the Array Size." Again, nice theory but unless your apps run under
>SQL*Plus (the client he used for his testing) of what value is it? My days as a
>developer were spent mostly with COBOL so I don't have much hands-on experience
>with the development tools my databases are supporting. Do Powerbuilder and VB
>with ADO have methods of controlling what Plus calls "array size"?
>
>On adjusting network buffer sizes he says the following:
>
>"SQL*NET should be intelligent enough to adjust its buffer size automatically
>according to the UNP (underlying network protocol) buffer size."
>
>Well, perhaps it SHOULD be, but if it isn't, then it's a moot point.
>
>Or am I missing something?

• Indexing tnsnames.ora Evidently the tnsnames.ora is completely loaded into memory (this can be demonstrated using support trace) and searched linearly. If you replace tnsnames.ora by Oracle Names, especially using a region database you do use indexing. Using Oracle Names usually is giving faster resolution times, I've always wondered why no one uses it (too tired of not reading the manual I suppose)

How do you say that in US legal terms: objection dismissed

• Developer can determine the array size, Powerbuilder can change the arraysize, Pro*C can set the arraysize, I'm not sure why Pro*Cobol shouldn't be capable of doing this. Those enslaved to Microsux products, not using Oracle Objects for Ole, better should stick to sqlserver anyway.

Objection dismissed

• Setting the Session Data Unit correctly according to the Max Transmission Unit of the UNP is an one time operation.

Objection dismissed

Next case

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Dec 14 2001 - 13:44:29 CST