Re: Optimising an Oracle application for bandwidth

Sybrand Bakker wrote:

>
> What you see is normal sqlnet behavior.

Ok, it's good to know that, at least.

> It looks like you don't have array fetching set up (and I don't know whether
> that's at all possible with OLEdb) and you are getting back one record at a
> time.

I'm seeing multipe rows returned n a single packet for some of the queries (those used to populate drop-down dialog boxes), and I'm not seeing a row at a time fetch anywhere, so hopefully this isn't the case.

> Setting event 10046 on that particular session from the Oracle server side
> is probably going to confirm with.

How do I set that? I think I should be using ORADBX, but I have Oracle 8.1.5, and I seem not to have an oradbx. My docs suggest I should find it in $ORACLE_HOME/rdbms/admin/lib, but that directory doesn't even exist, let alone oradbx. Do I need to install it separately from the Oracle CD, and if so, whick option do I find it under?

> So other than implementing array fetch, and in a later stage, try to play
> with the Session Data Unit of sqlnet, there's no real solution.

Ugggh. I've seen several references to increasing the arraysize parameter, but they all refer to tool specific ways. Is there a way to change this in VB/OLEDb?

Changing part of the app to use server side stored procedures has actually slowed it down. I'm getting stuff like:-

00 00 00 00 00 00 00 00 9c 0c b5 03 01 0f 42 45 ........ ..µ...BE 47 49 4e 20 53 59 53 2e 44 42 4d 53 5f 44 45 53 GIN SYS. DBMS_DES 43 52 49 42 45 2e 44 45 53 43 52 49 42 45 5f 50 CRIBE.DE SCRIBE_P 52 4f 43 45 44 55 52 45 28 3a 6f 62 6a 65 63 74 ROCEDURE (:object 5f 6e 61 6d 65 2c 3a 72 65 73 31 2c 3a 72 65 73 _name,:r es1,:res 32 2c 3a 6f 76 65 72 6c 6f 61 64 2c 3a 70 6f 73 2,:overl oad,:pos 69 74 69 6f 6e 2c 3a 6c 65 76 65 6c 2c 3a 61 72 ition,:l evel,:ar 67 75 6d 65 6e 74 2c 3a 64 61 74 61 74 79 70 65 gument,: datatype 2c 3a 64 65 66 61 75 6c 74 2c 3a 69 6e 5f 6f 75 ,:defaul t,:in_ou 74 2c 3a 6c 65 6e 67 74 68 2c 3a 70 72 65 63 69 t,:lengt h,:preci 73 69 6f 6e 2c 3a 73 63 61 6c 65 2c 3a 72 61 64 sion,:sc ale,:rad 69 78 2c 3a 73 70 61 72 65 29 3b 20 45 4e 44 3b ix,:spar e); END;

in the TNS packets. Why is that appearing there, and is there anything I can do to prevent it?

> You should however try to find out whether the application unnecessarily
> closes cursors.

It is currently closing the ADO recordset after use. We're trying to recode one of the screens to keep them open, and will test afterwards. Thanks for the pointer.

Mike. Received on Tue Nov 06 2001 - 10:18:26 CST