解析后的trace文件内容如下
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.01 0.03 0 3 0 0
Fetch 3 0.34 65.09 919 938 0 20
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 5 0.35 65.12 919 941 0 20
Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 97
Rows Row Source Operation
------- ---------------------------------------------------
20 VIEW
20 COUNT STOPKEY
0 VIEW
0 SORT ORDER BY
0 HASH JOIN
0 TABLE ACCESS FULL CHARGEITEM
0 HASH JOIN
0 TABLE ACCESS FULL PAYNOTEITEM
0 HASH JOIN
0 TABLE ACCESS FULL PARENTUNIT
0 HASH JOIN
0 TABLE ACCESS FULL UNIT
0 HASH JOIN
0 TABLE ACCESS FULL UNIT
0 TABLE ACCESS FULL PAYNOTE
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
rdbms ipc reply 2 0.00 0.00
enqueue 4 0.09 0.10
PX Deq: Join ACK 2 0.00 0.00
PX Deq Credit: send blkd 55 0.00 0.00
PX Deq Credit: need buffer 162 0.00 0.01
PX Deq: Parse Reply 4 0.00 0.00
SQL*Net message to client 3 0.00 0.00
PX Deq: Execute Reply 117 2.04 64.47
db file scattered read 63 0.01 0.20
db file sequential read 2 0.00 0.01
PX Deq: Table Q qref 4 0.10 0.16
SQL*Net message from client 3 156.25 156.34
SQL*Net more data to client 1 0.00 0.00
PX Deq: Signal ACK 10 0.10 0.71
********************************************************************************