C cyf4 Unregistered / Unconfirmed GUEST, unregistred user! 2009-06-09 #1 那位老兄知道，oracle怎么监视SQL语句，就像SQLSERVER里跟踪工具那样，谢谢
P power255 Unregistered / Unconfirmed GUEST, unregistred user! 2009-06-09 #3 试一下这个SQLselect q.sql_text from v$session s, v$sqlarea q where s.user# = q.parsing_user_id and s.status = 'ACTIVE' and s.username = '【用户名填在这里】' order by q.FIRST_LOAD_TIME Desc;
试一下这个SQLselect q.sql_text from v$session s, v$sqlarea q where s.user# = q.parsing_user_id and s.status = 'ACTIVE' and s.username = '【用户名填在这里】' order by q.FIRST_LOAD_TIME Desc;
L luoyanqing119 Unregistered / Unconfirmed GUEST, unregistred user! 2009-06-10 #4 查询谁在执行什么SQL语句 SELECT osuser, username, sql_text from v$session a, v$sqltext b where a.sql_address =b.address order by address, piece
查询谁在执行什么SQL语句 SELECT osuser, username, sql_text from v$session a, v$sqltext b where a.sql_address =b.address order by address, piece
