Oracle 10g Active Connection SQL

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

« Unix Find And Grep Command

» Oracle 9i SQL Active Connection

Leave a Comment

Join the over 2,000 people who get free and fresh knowledge as soon as it’s published.

We respect your email privacy.

We promise never to rent, sell or share information we collect because that would be a violation of everything we stand for.

Period.

Oracle 10g Active Connection SQL

Recent Posts