SELECT osuser, username, sql_text from v$session a, v$sqltext b where a.sql_address =b.address order by address, piece;
如果我想查看其它session在当前数据库上执行的SQL呢,这个好像是看当前SQL所执行的SQL。我将SQL改成:(12是另一台机器上的SQLPLUS)SELECT osuser, username, sql_text from v$session a, v$sqltext b where a.sql_address =b.address and a.sid = 12 order by address, piece;请赐教
where a.sql_address =b.address order by address, piece;
where a.sql_address =b.address and a.sid = 12 order by address, piece;请赐教