are they similar 1700 sql statements differing by literals.
if ur db is 8.x can u use cursor_sharing?
hv u tried 10046 tracing?
myabe the parse time for these 1700 sql is more than the perceived tcp gain u r trying
to achieve.
-Original Message-
From: Schauss, Peter [mailto:[EMAIL
Yes,
Please do so ! Later versions of Oracle have this already enabled by default I
believe. Depending on the delay, the savings/improvements can be great !
First set tcp.nodelay = true, then worry about the SDU/TDU settings. The thing
to remember here is that the server and the client need
Peter,
You'll probably get best results by continuing down the path you've begun.
You had SQL-traced a process -- have you used TKPROF to aggregate the
information into something useful? Reading a .trc file from SQL trace for
performance is like reading a person's genome to find their gender;
