Re: Help ? Urgent SQL*NET question...

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Sat, 21 Apr 2001 02:50:57 GMT
Message-ID: <lA6E6.37072$xN4.2658791@news1.sttls1.wa.home.com>

Yes.

In the application you have to set the array size. If you are using OCI then you specify for each cursor what the array size is. I believe for jdbs there is a global way to set it.
Jim

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:te10sot9rd3092_at_beta-news.demon.nl...
>
> "Dorian Creber" <dorian_at_ntlworld.nospam.com> wrote in message
> news:17%D6.1793$991.180796_at_news6-win.server.ntlworld.com...
> > Hi all,
> > I hope I'm in the right place :-)
> >
> > I'm trying to find out how to set the "default array size" in sql*net
> > v2.x.... ???
> >
> > Can anyone point me to the right solution ?
> >
> > Best regards,
> >
> > Dorian_at_ntlworld.com
> >
> >
>
> There is no such thing is sqlnet, that's a client issue.
> You can set the SDU though, the session data unit, the maximum number of
> bytes sqlnet will send in one go.
> This issue should be described in the sqlnet administrators guide.
> I say this because I right now don't remember how to set it in
listener.ora,
> I do remember how to set it in tnsnames.ora
> connect_data =(
> (sdu=<any multiple of the Maximum Transmission Unit of the network,
usually
> 1500>)
> ... rest of definiton...
>
> something similar needs to be done in listener.ora as sqlnet will always
use
> the lower value and the default is 2048.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> >
> >
>
>
Received on Fri Apr 20 2001 - 21:50:57 CDT