RE: SQL*Net message to|from client

Hi

> I am working on Siebel application and have found few stuff are
working
> slow and doing detailed traces with Waits shows that only wait events
are
> SQL*Net message to client'
> SQL*Net message from client'

You have only "SQL*Net message to/from client" probably because the needed data is already in the buffer cache.

The application is fetching only two rows at time (strangely enough the first time 3...). Since the fetches are performed without any possible user's "think time", you should increase the number of rows which are fetched for each database call. I.e. you should increase the fetch size.

HTH
Chris

--
http://www.freelists.org/webpage/oracle-l