Oracle trace with timed stat

From: <kerbiquet_at_hotmail.com>
Date: Mon, 18 Dec 2000 18:28:57 GMT
Message-ID: <91ll10$2ne$1@nnrp1.deja.com>

Oracle 8.0.6 HP UX 11

I got the following trace, and not 100% sure how to understand time statictics. Does the trace meen that the last execute call took 3.58 s cpu or is it the total time of the 52253 execute calls that took that time?

SELECT TIME_ID
FROM
"TIME" WHERE TIMEDATE = TO_DATE(:b1,'RRRRMMDD') + 1

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

---

Parse 1 0.00 0.00 0 0 0 0
Execute 52253 3.58 3.03 0 0 0 0
Fetch 52253 1.91 1.15 3 156759 0 52253
------- ------ -------- ---------- ---------- ---------- ---------- ----

---

total 104507 5.49 4.18 3 156759 0 52253

Sent via Deja.com
http://www.deja.com/ Received on Mon Dec 18 2000 - 12:28:57 CST