<% String sName; %> Active transactions <% String url = request.getParameter("url"); String sPassword = request.getParameter("pwd"); String sUsername = request.getParameter("uid"); java.util.Date date = new java.util.Date(); %>

<%= url %> ON <%= String.valueOf(date) %>

<% url = "jdbc:oracle:thin:@" + url ; java.sql.Connection con = null; try { java.lang.Class.forName("oracle.jdbc.driver.OracleDriver"); } catch (java.lang.Exception e) { out.println("Exception: could not load the driver?"); return; } con = java.sql.DriverManager.getConnection(url,sUsername,sPassword); java.sql.Statement stmt_transac = con.createStatement(); java.sql.ResultSet rs_transac = stmt_transac.executeQuery("SELECT osuser o, s.sid sid, s.serial# ser, s.machine machine, terminal, process, username u, r.segment_name s, substr(sa.sql_text,1,200) txt from v$session s, v$transaction t, dba_rollback_segs r, v$sqlarea sa WHERE s.taddr=t.addr AND t.xidusn=r.segment_id(+) AND s.sql_address=sa.address(+) "); %>

ACTIVE TRANSACTIONS

<% while (rs_transac.next()) { String ssOsuser = rs_transac.getString("o"); String ssSid = "" + rs_transac.getInt("sid"); String ssSerial = "" + rs_transac.getInt("ser"); String ssMachine = rs_transac.getString("machine"); String ssTerminal = rs_transac.getString("terminal"); String ssProcess = rs_transac.getString("process"); String ssUsername = rs_transac.getString("u"); String ssSegment = rs_transac.getString("s"); String ssSqlText = rs_transac.getString("txt"); %> <% } rs_transac.close(); stmt_transac.close(); %>
Osuer Sid Serial Machine Terminal Process Ora username Rollback seg SQL Text
<%= ssOsuser %> <%= ssSid %> <%= ssSerial %> <%= ssMachine %> <%= ssTerminal %> <%= ssProcess %> <%= ssUsername %> <%= ssSegment %>