see_active_sql
PID SID SPID ORA User OS User TERMI PROGRAM B STATUS SQL --- --- ------------ --------- --------- ----- -------- - -------- ------------------------------------------------------------ 16 9 9788 CBO_JMS oracle UNKNO oracle@a INACTIVE select count(*) from dual 17 12 9790 CBO_JMS oracle UNKNO oracle@a INACTIVE select count(*) from dual 18 13 9794 CBO_JMS oracle UNKNO oracle@a INACTIVE select count(*) from dual 45 40 9864 CBO_JMS oracle UNKNO oracle@a INACTIVE select count(*) from dual 43 38 9860 CBO_JMS oracle UNKNO oracle@a INACTIVE select count(*) from dual 42 37 9858 CBO_JMS oracle UNKNO oracle@a INACTIVE select count(*) from dual 63 58 9900 CBO_JMS oracle UNKNO oracle@a INACTIVE select count(*) from dual 65 60 9906 CBO_JMS oracle UNKNO oracle@a INACTIVE select count(*) from dual 64 59 9902 CBO_JMS oracle UNKNO oracle@a INACTIVE select count(*) from dual 12 ### 10489 CBO_WEB oracle UNKNO oracle@a INACTIVE begin :1 := JAVA_XA.xa_commit_new (:2,:3,:4,:5); end; 13 8 9778 CBO_WEB oracle UNKNO oracle@a INACTIVE select count(*) from dual PID SID SPID ORA User OS User TERMI PROGRAM B STATUS SQL --- --- ------------ --------- --------- ----- -------- - -------- ------------------------------------------------------------ 14 10 9780 CBO_WEB oracle UNKNO oracle@a INACTIVE select count(*) from dual 15 11 9784 CBO_WEB oracle UNKNO oracle@a INACTIVE select count(*) from dual 19 14 9796 CBO_WEB oracle UNKNO oracle@a INACTIVE begin :1 := JAVA_XA.xa_commit_new (:2,:3,:4,:5); end; 21 ### 10509 CBO_WEB oracle UNKNO oracle@a INACTIVE begin :1 := JAVA_XA.xa_commit_new (:2,:3,:4,:5); end; 54 49 9882 CBO_WEB oracle UNKNO oracle@a INACTIVE begin :1 := JAVA_XA.xa_commit_new (:2,:3,:4,:5); end; 53 48 9880 CBO_WEB oracle UNKNO oracle@a INACTIVE begin :1 := JAVA_XA.xa_commit_new (:2,:3,:4,:5); end; 52 47 9878 CBO_WEB oracle UNKNO oracle@a INACTIVE begin :1 := JAVA_XA.xa_commit_new (:2,:3,:4,:5); end; 50 45 9874 CBO_WEB oracle UNKNO oracle@a INACTIVE select count(*) from dual 48 43 9870 CBO_WEB oracle UNKNO oracle@a INACTIVE select count(*) from dual 47 42 9868 CBO_WEB oracle UNKNO oracle@a INACTIVE select count(*) from dual 39 34 9846 CBO_WEB oracle UNKNO oracle@a INACTIVE begin :1 := JAVA_XA.xa_commit_new (:2,:3,:4,:5); end; PID SID SPID ORA User OS User TERMI PROGRAM B STATUS SQL --- --- ------------ --------- --------- ----- -------- - -------- ------------------------------------------------------------ 36 31 9836 CBO_WEB oracle UNKNO oracle@a INACTIVE begin :1 := JAVA_XA.xa_commit_new (:2,:3,:4,:5); end; 32 27 9826 CBO_WEB oracle UNKNO oracle@a INACTIVE begin :1 := JAVA_XA.xa_commit_new (:2,:3,:4,:5); end; 84 84 9978 CBO_WEB oracle UNKNO oracle@a INACTIVE begin :1 := JAVA_XA.xa_commit_new (:2,:3,:4,:5); end; 83 79 9962 CBO_WEB oracle UNKNO oracle@a INACTIVE begin :1 := JAVA_XA.xa_commit_new (:2,:3,:4,:5); end; 82 80 9960 CBO_WEB oracle UNKNO oracle@a INACTIVE begin :1 := JAVA_XA.xa_commit_new (:2,:3,:4,:5); end; 80 74 9940 CBO_WEB oracle UNKNO oracle@a INACTIVE begin :1 := JAVA_XA.xa_commit_new (:2,:3,:4,:5); end; 79 77 9938 CBO_WEB oracle UNKNO oracle@a INACTIVE begin :1 := JAVA_XA.xa_commit_new (:2,:3,:4,:5); end; 78 73 9936 CBO_WEB oracle UNKNO oracle@a INACTIVE begin :1 := JAVA_XA.xa_commit_new (:2,:3,:4,:5); end; 77 71 12443 CBO_WEB oracle UNKNO oracle@a INACTIVE SELECT VALUE FROM NLS_INSTANCE_PARAMETERS WHERE PARAMETER =' NLS_DATE_FORMAT' PID SID SPID ORA User OS User TERMI PROGRAM B STATUS SQL --- --- ------------ --------- --------- ----- -------- - -------- ------------------------------------------------------------ 76 70 9932 CBO_WEB oracle UNKNO oracle@a INACTIVE begin :1 := JAVA_XA.xa_commit_new (:2,:3,:4,:5); end; 75 72 12348 CBO_WEB oracle UNKNO oracle@a INACTIVE SELECT VALUE FROM NLS_INSTANCE_PARAMETERS WHERE PARAMETER =' NLS_DATE_FORMAT' 74 98 10020 CBO_WEB oracle UNKNO oracle@a INACTIVE begin :1 := JAVA_XA.xa_commit_new (:2,:3,:4,:5); end; 73 68 9922 CBO_WEB oracle UNKNO oracle@a INACTIVE begin :1 := JAVA_XA.xa_commit_new (:2,:3,:4,:5); end; 72 67 9920 CBO_WEB oracle UNKNO oracle@a INACTIVE begin :1 := JAVA_XA.xa_commit_new (:2,:3,:4,:5); end; 71 66 9918 CBO_WEB oracle UNKNO oracle@a INACTIVE begin :1 := JAVA_XA.xa_commit_new (:2,:3,:4,:5); end; 69 20 12393 CBO_WEB oracle UNKNO oracle@a INACTIVE begin :1 := JAVA_XA.xa_commit_new (:2,:3,:4,:5); end; 62 57 9898 CBO_WEB oracle UNKNO oracle@a INACTIVE select count(*) from dual 61 56 9896 CBO_WEB oracle UNKNO oracle@a INACTIVE select count(*) from dual PID SID SPID ORA User OS User TERMI PROGRAM B STATUS SQL --- --- ------------ --------- --------- ----- -------- - -------- ------------------------------------------------------------ 60 55 9894 CBO_WEB oracle UNKNO oracle@a INACTIVE select count(*) from dual 94 91 9998 CBO_WEB oracle UNKNO oracle@a INACTIVE begin :1 := JAVA_XA.xa_commit_new (:2,:3,:4,:5); end; 31 53 13422 DEMO oracle UNKNO oracle@a INACTIVE DELETE FROM JMSState WHERE recordHandle = :1 AND recordGener ation = :2 OR recordHandle = :3 AND recordGeneration = :4 OR recordHandle = :5 AND recordGeneration = :6 OR recordHandle = :7 AND recordGeneration = :8 OR recordHandle = :9 AND rec ordGeneration = :10 OR recordHandle = :11 AND recordGenerati PID SID SPID ORA User OS User TERMI PROGRAM B STATUS SQL --- --- ------------ --------- --------- ----- -------- - -------- ------------------------------------------------------------ 30 54 13420 DEMO oracle UNKNO oracle@a INACTIVE begin :1 := JAVA_XA.xa_commit_new (:2,:3,:4,:5); end; ### 50 14506 DSIMS oracle UNKNO oracle@a INACTIVE select count(*) from ACME.memo_line_act where OUTBOUND_EN VELOPE_ID = '15' and UPDATE_TS > to_date ('12/03/02', 'mm/dd" /yy') ### ### 12377 JSMITH jsmith UNKNO oracle@a INACTIVE 22 81 14511 ACME map pts/1 oracle@a ACTIVE select b.sid, c.username, c.osuser, c.terminal, decode(b .id2, 0, a.object_name, 'Trans-'||to_char(b.id1)) object_nam e, b.type, decode(b.lmode, 0, '--Waiting--', 1, 'Null' , 2, 'Row Share', 3, 'Row Excl', 4, 'Share', 5, 'Sha Row Exc', 6, 'Exclusive', 'Other') "Lock Mode", dec PID SID SPID ORA User OS User TERMI PROGRAM B STATUS SQL --- --- ------------ --------- --------- ----- -------- - -------- ------------------------------------------------------------ 93 ### 14513 ACME jsmith UNKNO oracle@a INACTIVE ### 32 14527 ACME map pts/1 oracle@a ACTIVE SELECT P.pid pid, S.sid sid, P.spid spid, S.username us ername , S.osuser osname, substr(P.terminal,1,5) terminal, substr(P.program,1,8) program, P.background, S.status, RTRIM(SUBSTR(a.sql_text, 1, 300)) SQL FROM v$process P, v $session S, v$sqlarea A WHERE P.addr = s.paddr AND 2 1 9738 oracle UNKNO oracle@a 1 ACTIVE select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname, o.subname,o.dataobj#,o.flags from obj$ o where o.obj#=:1 PID SID SPID ORA User OS User TERMI PROGRAM B STATUS SQL --- --- ------------ --------- --------- ----- -------- - -------- ------------------------------------------------------------ 3 2 9740 oracle UNKNO oracle@a 1 ACTIVE 4 3 9742 oracle UNKNO oracle@a 1 ACTIVE 5 4 9744 oracle UNKNO oracle@a 1 ACTIVE 6 5 9748 oracle UNKNO oracle@a 1 ACTIVE insert into sys.col_usage$ values ( :objn, :coln, decode (bitand(:flag,1),0,0,1), decode(bitand(:flag,2),0,0,1), decode(bitand(:flag,4),0,0,1), decode(bitand(:flag,8),0,0, 1), decode(bitand(:flag,16),0,0,1), decode(bitand(:flag, 32),0,0,1), :time) 7 6 9750 oracle UNKNO oracle@a 1 ACTIVE select local_tran_id, global_tran_fmt, global_oracle_id, glo bal_foreign_id, state, status, heuristic_dflt, PID SID SPID ORA User OS User TERMI PROGRAM B STATUS SQL --- --- ------------ --------- --------- ----- -------- - -------- ------------------------------------------------------------ session_vector, reco_vector, 3600*24*(sysdate-reco_time), 3600*24*(sysdate-nvl(heuristic_time,fail_time)), globa l_commit#, type# from pending_trans$ where session_vector