- 论坛徽章:
- 0
|
********************************************************************************
count = number of times OCI procedure was executed
cpu = cpu time in seconds executing
elapsed = elapsed time in seconds executing
disk = number of physical reads of buffers from disk
query = number of buffers gotten for consistent read
current = number of buffers gotten in current mode (usually for update)
rows = number of rows processed by the fetch or execute call
********************************************************************************
select sid
from
v$mystat
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.01 0.08 0 19 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 43 0.00 0.00 0 0 0 622
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 45 0.01 0.08 0 19 0 622
不理解这里: fetch : 43 为何? query ,current ,disk 三个 有什么区别。 如何检测到三者的数据。 query 在parse 中19 如何能手工得出? |
|