Doubt about Total Waited

From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Thu, 5 Jan 2012 16:53:58 -0200
Message-ID: <CAJdDhaNmffg7U+=N=yyWciEuhFJ=0zhrgp9kn=vLhBJcoOhsvA_at_mail.gmail.com>

Hi friends,
I have the following report extracted from trace.

  SQL*Net message from client                    18       13.29

113.66
The total time of the process was 34 seconds.

1.) What does it mean ? the 113.66 ?

2.) This event (SQL*Net message from client) occurs after or before execution of the query ?

 3.) What is the measure of 113.66 ?

Regards
Eriovaldo

---

select COD_DADO
from
 DADOS where (COD=:b0 and PONTO=:b1)

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ----------

---

Parse        9      0.00       0.00          0          0
0           0
Execute      9      0.00       0.00          0          0
0           0
Fetch       18      0.00       0.00          0         18
0           9

------- ------ -------- ---------- ---------- ---------- ----------

---

total       36      0.00       0.00          0         18
0           9

Misses in library cache during parse: 1
Misses in library cache during execute: 1 Optimizer mode: RULE
Parsing user id: 59
Rows Row Source Operation
------- ---------------------------------------------------

      1 INDEX RANGE SCAN IND_DADOS (cr=2 pr=0 pw=0 time=26 us)(object id 59871)

Elapsed times include waiting on following events:

  Event waited on                             Times   Max. Wait  Total

Waited

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

  ---

  SQL*Net message to client 18 0.00 0.00 SQL*Net message from client 18 13.29 113.66

  ---

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jan 05 2012 - 12:53:58 CST