Oracle Server - SQL*Net roundtrip

Author

SQL*Net roundtrip

Pedro Lopes

2005-05-24, 8:23 pm

Hi all,
How can I reduce the roundtrip of an sql statetement exectution ?

I look at some documents that talk about set array size on sqlplus...
and It works.

But if I have a C++ aplication that is executing the statement.. how can
I get bigger packets ?
Looked for SDU (on the listener and tnsnames side), but after executing
the explain plan the SQL*Net Rountrip stills the same.

any ideias ?

thanks,
Pedro

Sybrand Bakker

2005-05-24, 8:23 pm

On Tue, 24 May 2005 21:42:53 +0100, Pedro Lopes
<pedro.lopes@netvisao.pt> wrote:

>Hi all,
>How can I reduce the roundtrip of an sql statetement exectution ?
>
>I look at some documents that talk about set array size on sqlplus...
>and It works.
>
>But if I have a C++ aplication that is executing the statement.. how can
>I get bigger packets ?
>Looked for SDU (on the listener and tnsnames side), but after executing
>the explain plan the SQL*Net Rountrip stills the same.
>
>any ideias ?
>
>thanks,
>Pedro

Depends on whether you are using a Host Language Interface like Pro*C
or plain OCI. In Pro*C you will have host arrays set up. You can play
around with the size of those arrays.
Please be aware that in order to be efficient the total size of the
array (number of elements times number of bytes in element) should be
smaller than SDU.

--
Sybrand Bakker, Senior Oracle DBA

Noons

2005-05-25, 3:23 am

Pedro Lopes wrote:
> But if I have a C++ aplication that is executing the statement.. how can
> I get bigger packets ?

You pick up the source for the C++ and change it to use the array
interface to retrieve resultsets or pass parameters to Oracle.
Just like sqlplus does: it's also a program written in C.
It works for both Pro*C and OCI, BTW. In fact, in OCI there is
even a little bit more you can do: check the doco.

If you don't have the source, then there is preciously nothing
you can do other than complain to whoever has it.

Or get a faster network...

Sponsored Links