Question on SQL*Net message from client
- From: "Harvinder Singh" <Harvinder.Singh@xxxxxxxxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 9 May 2007 18:16:22 -0400
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
Other related posts:
