如何获取客户端传给数据库的SQL语句？

[gdxuz]

如何获取客户端传给数据库的SQL语句（包括select、update、delete等），是否有
这样的视图？

[chanet]

v$sql

[railgunman]

v$sql
v$sqltext

[gdxuz]

是不是所有数据库用户的SQL都能查到？

['Alan]

set line 1000
select address,piece,sql_text from v$session,v$sqltext
where address=sql_address and machine='YOUR MACHINE'
order by address,piece;

['Alan]

your machine name 大写

[zhaokeke2004]

SELECT SQL_TEXT
FROM V$SQL_TEXT T, V$SESSION S
WHERE T.ADDRESS=S.SQL_ADDRESS
AND T.HASH_VALUE=S.SQL_HASH_VALUE
AND S.MACHINE='XXXXX' OR USERNAME='XXXXX' -- 查看某主机名，或用户名

[tobywusky]

1. select sql_text from v$sql order by first_load_time desc;
2. 在dba中看session，sql很清楚。

[newboy3205579]

SELECT osuser, username, sql_text from v$session a, v$sqltext b
where a.sql_address =b.address order by address, piece;