Re: BLOB reading is slow

Hello,

First sorry for cross posting, this is the only place where I'll continue this thread.

I wasn't very clear about what I did.

Network level:

• Enabling debuging on my cisco switch, looking at packets delay, I saw absolutely no wait time from the switch on the server port on the client and the switch port on the server.
• Network configuration: DNS, MTU, are fine.
• TCP Stack of solaris was debugged to see for eventual wait time / timeout.

OS Level:
- Memory usage and CPU usage has been carefully monitored on both
Server (solaris) and Client (macosx).
- IO of disk has been watched, and they are nearly idle, but when
running test SQL scripts, I see higher activity, so I think there is no bottleneck here.

DB Level:
- I sent you an email with the output of v$session_wait as you told me.
So I don't want to annoy you. But again sorry for double posting.
- I found out this: "SQL*Net more data to client", is the wait event
causing the problem.

Regards

Kuon Received on Sun Nov 13 2005 - 09:14:50 CST