lfree 发表于 2016-2-24 16:48
把这个结果帖上来。
SELECT sql_id ,p1 ,p2 ,p3 ,COUNT (*) FROM dba_hist_active_sess_history WHERE eve ...
SQL> select * from (
2 select p1,p2,p3,sql_id,count(*) from
3 dba_hist_active_sess_history
4 where event ='Disk file operations I/O'
5 group by p1,p2,p3,sql_id
6 order by count(*) desc) where rownum <20;
P1 P2 P3 SQL_ID COUNT(*)
---------- ---------- ---------- ------------- ----------
2 0 15 628s0689nqf2w 7032
2 0 15 ds5011930gwmq 4120
2 0 15 5fgkjvux5czhb 3242
2 0 15 576thsxdr9576 2935
2 0 15 73h4zdymdg41m 2584
2 0 15 19c4mwp4r4a6g 2470
2 0 15 7qhjcd8zkun2w 2175
2 0 15 cv20gajn2w050 2153
2 0 15 6zpq6grxqrnrg 1928
2 0 15 3sk391a1uyuud 1578
2 0 15 0tgjzh24rnbyq 1560
2 0 15 6scua95k0fdas 1528
2 0 15 4bcsmw375zf4h 1342
2 0 15 79a7h475aqnny 1337
2 0 15 76tpztwxa2h1a 1180
2 0 15 8sdn9rx71fcbb 1142
2 0 15 4t5yb094jdc3z 1112
2 0 15 04ss32g2cwgcp 1110
2 0 15 3zpu9u71vk29t 1085
19 rows selected
SQL>
SQL> select * from (
2 select p1,p2,p3,count(*) from
3 dba_hist_active_sess_history
4 where event ='Disk file operations I/O'
5 group by p1,p2,p3
6 order by count(*) desc) where rownum <20;
P1 P2 P3 COUNT(*)
---------- ---------- ---------- ----------
2 0 15 119219
5 0 3 108
2 0 3 9
8 0 8 3
2 1 2 1
2 38 2 1
5 0 4 1
7 rows selected