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;
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