I'm presently along the way of debugging a database performance problem. I've run extended trace around the suffering oracle box to acquire a trace file which i've examined using tkprof.

One factor that caught my attention immediately was the next output

  Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  SQL*Net message to client                       4        0.00          0.00
  SQL*Net message from client                     4      109.06        141.31

I've run the relate query by hand using a SQL client an it executes in due time. And So I don't believe its cause directly through the query.

Can someone clarify just what "SQL*Internet message from client" means ?

Does anybody have idea what is leading to such large wait occasions ?

Thanks ahead of time

Karl

SQL*Internet message from client means time taken by oracle awaiting input in the client that you're hooking up with. It's frequently regarded as an "idle" event, so nothing to bother with however, this link disagrees. You will probably find that the client may be the one making the effort which means you could optimise the application not the queries it uses.

http://oracletoday.blogspot.com/2005/09/sqlnet-message-from-client.html

Also, one other good link is http://www.dba-oracle.com/m_sql_net_message_to_client.htm