Logo Background

Oracle 10g Active Connection SQL

  • By on August 17, 2008 | No Comments

    You may use the SQL line as below, run it on TOAD or SQL Plus to check the active connection on your database: –

    SQL> SELECT b.sid, b.serial#, a.spid, b.program, b.osuser, b.machine,
    b.type, b.event, b.action, b.p1text, b.p2text, b.p3text, b.state, c.sql_text,b.logon_time
    FROM v$process a, v$session b, v$sqltext c
    WHERE a.addr=b.paddr
    AND b.sql_hash_value = c.hash_value
    AND b.status = 'ACTIVE'
    ORDER BY a.spid, c.piece

    This SQL only applicable on Oracle 10g and above. It could be useful for monitoring purposes to you as a DBA

    » Oracle 9i SQL Active Connection
Leave a Comment