Question on SQL*Net message from client

From: Harvinder Singh <Harvinder.Singh_at_MetraTech.com>
Date: Wed, 9 May 2007 18:16:22 -0400
Message-ID: <D6424CD4C8A3C044BBC49877ED51C51804E028DF@ex2003.metratech.com>

Hi,  

We see lot of waits in the database on "SQL*Net message from client" and following is one of the sample query with wait events from tkprof, what can be the possible reason for long wait for this event for truncate command?  

TRUNCATE TABLE tab1    

call count cpu elapsed disk query current rows

• ------ -------- ---------- ---------- ---------- ----------

  ---

Parse 1 0.00 0.00 0 0 0 0

Execute 1 0.27 0.36 18 2 122 0

Fetch 0 0.00 0.00 0 0 0 0

• ------ -------- ---------- ---------- ---------- ----------

  ---

total 2 0.27 0.36 18 2 122 0  

Misses in library cache during parse: 1

Optimizer mode: ALL_ROWS

Parsing user id: 172  

Elapsed times include waiting on following events:

  Event waited on                             Times   Max. Wait  Total

Waited

• Waited ----------

  ---

  db file sequential read                        18        0.00

0.00

  enq: RO - fast object reuse                     6        0.01

0.02

  local write wait                               11        0.00

0.05

  log file sync                                   1        0.00

0.00

  SQL*Net message to client                       1        0.00

0.00

  SQL*Net message from client                     1      120.46

120.46  

Thanks

--Harvinder
 

--

http://www.freelists.org/webpage/oracle-l Received on Wed May 09 2007 - 17:16:22 CDT