定位某事件高发的sql

1、select   t1.sid, t1.value,  t2.name  from v$sesstat  t1 ,v$statname t2 where t2.name like '%user commits%' and t1.statistic# = t2.statistic# and value >=100 order by value desc;

2、select  t.sid,  t.username,  t.program,  t.sql_id,  t.prev_sql_id from  v$session t  where sid=4;

3、select sql_text from v$sql where sql_id='avms232zm4k8u';