Mladen Gogala <gogala_at_sbcglobal.net> wrote in
news:pan.2005.11.13.01.59.10.293439_at_sbcglobal.net:
> On Sat, 12 Nov 2005 17:33:41 -0800, kuon wrote:
>
>> Hello,
>>
>> I'm currently developing a JDBC program on Oracle and I have the
>> following problem.
>>
>> I use the BLOB.getBinaryStream() method, it works fine, I got the
>> stream and I can read it.
>>
>> My problem is slow performances, when I call stream.read():
>>
>> The first call takes 10 seconds.
>> Then 32*1024 next calls are very fast.
>> Then hang for 10 seconds
>> Then 32ko readed fast, hang....
>>
>> Do you have any idea if this is Database or JDBC problem?
>>
>> The network is fine.
>>
>> I think it's a SQL Net problem, because when I SQL plus to the db on
>> the local computer, the connection is immediate, but if I sqlPlus from
>> remote computer, the connection hang for 5 seconds before showing me
>> the sqlPlus prompt. And 32ko seems to be the net packet size, but I'm
>> not sure of this.
>
> On the oracle-l, where you cross posted the problem, I asked you
> about the wait in V$SESSION_WAIT and V$SESSION_EVENT. Any news or
> are you cross posting just to annoy the heck out of me?
>
Also posted to http://www.dbforums.com/f4/
Received on Sat Nov 12 2005 - 21:24:36 CST