Wednesday, November 13, 2013

script to find current sql code of the user or session?

SELECT OSUSER,SERIAL#,SQL_TEXT FROM V$SESSION, V$SQL WHERE V$SESSION.SQL_ADDRESS = V$SQL.ADDRESS AND V$SESSION.STATUS = 'ACTIVE';

SELECT OSUSER,SERIAL#,SQL_TEXT FROM V$SESSION, V$SQL WHERE V$SESSION.SQL_ADDRESS = V$SQL.ADDRESS AND V$SESSION.STATUS = 'ACTIVE' and sid=2017;

No comments:

Post a Comment