Re: SQL*net message from Client

This wait event means that the database is waiting for information from the client. So the session is sitting there idle until the session passes information to the database. Are you trying to pass large data from the client to the database? Typically, increasing TDU and SDU will only be necessary if your events are "SQL*Net more data [to|from] [client|dblink]". You'll have to figure out why it is taking so long to get information out of your client to the database.

HTH,
Brian

Vincento Harris wrote:
>
> Hi
>
> HP UX Oracle 8i .Three tier peoplesoft on Oracle ..(Query run on IE)
>
> I had a query that ran for about about 5 minutes
> A trace (10046 level 12) was run and tkprof,trca.zip downloaded from
> Metalink were used to explain the trace.
> The stand out is SQL*Net message from client with a time
> of 293.83 seconds and that is about the time the query took to run.
> I considered changing tdu and sdu in the tnsnames files but have not
> done so yet .
> Any ideas will be appreciated.
>
> Vincento

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"