查询频繁commit的SQL语句:

set linesize 1000
column sid             format 99999
column program         format a20
column machine         format a20
column logon_time      format date
column wait_class      format a10
column event           format a32
column sql_id          format 9999
column prev_sql_id     format 9999
column WAIT_TIME       format 9999
column SECONDS_IN_WAIT format 9999
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 >= 10000
 order by value desc;

select t.SID,
         t.PROGRAM,
             t.EVENT,
         t.LOGON_TIME,
         t.WAIT_TIME,
         t.SECONDS_IN_WAIT,
         t.SQL_ID,
         t.PREV_SQL_ID
   from v$session t
  where sid in (46);

select t.sql_id,
         t.sql_text,
         t.EXECUTIONS,
         t.FIRST_LOAD_TIME,
         t.LAST_LOAD_TIME
  from v$sqlarea t
 where sql_id in ('7knasq7cpk93v');

select * from v$active_session_history where session_id=194；