by http://webgeektutorials.blogspot.com

Monday, May 14, 2012

Oracle DBA Script : Monitor User

Displays the user and the text of the statement the user is executing

Code:
SELECT OSUSER,SERIAL#,SQL_TEXT
FROM V$SESSION, V$SQL
WHERE
V$SESSION.SQL_ADDRESS=V$SQL.ADDRESS 

AND 
V$SESSION.STATUS = 'ACTIVE';

No comments:

Post a Comment