|
本帖最后由 lfree 于 2015-7-22 09:23 编辑
> select count(*) from V$ACTIVE_SESSION_HISTORY where sql_id= '7pucjfm8w1vy6' and sample_time>=trunc(sysdate);
COUNT(*)
----------
1010
--需要1010秒,
> select count(*),event from V$ACTIVE_SESSION_HISTORY where sql_id= '7pucjfm8w1vy6' and sample_time>=trunc(sysdate) group by event;
COUNT(*) EVENT
---------- ----------------------------------------
55
955 db file sequential read
--有可能是溢出去了吗? |
|