-- =============================
-- Show currently committing
-- =============================
SAMPLE OUTPUT Go to Script
--------------------------------------------------------------------------------
USERNAME PROGRAM STATUS LOGONTIME EXECUTIONS SQL_TEXT
--------------- ------------------------------ -------- ------------- ---------- --------------------------------------------------
INSIDEUSER JDBC Connect Client INACTIVE 09Mar05 13:41 39 set transaction isolation level read committed
OUTSIDEUSER JDBC Connect Client INACTIVE 09Mar05 13:40 39 set transaction isolation level read committed
EMPLOYEES JDBC Connect Client INACTIVE 09Mar05 13:41 39 set transaction isolation level read committed
SYS sqlplus@servername.subnet.dns ACTIVE 09Mar05 13:48 2 select s.username,s.program,s.status,to_char(s.log
on_time,'ddMonyy hh24:mi') logontime,executions, s
ql_text from v$session s, v$sqlarea a where a.hash
_value = s.sql_hash_value and a.address = s.sql_ad
dress and upper(a.sql_text) like '%COMMIT%' and us
ername is not null order by 5 desc
SCRIPT Go to Top
------------------------------------------------------------------------------------------------------------------------------------
set pagesize 140
col program for a30 trunc
col s.username a15
col sql_text for a50
set linesize 200
select s.username,s.program,s.status,to_char(s.logon_time,'ddMonyy hh24:mi') logontime,executions, sql_text
from V$SESSION s, V$SQLAREA a where a.hash_value = s.sql_hash_value and a.address = s.sql_address
and upper(a.sql_text) like '%COMMIT%' and username is not null order by 5 desc;
