to ineedtostudy(amei): 用pl/sql developer 显示的信息不全呀?
select sql_text from v$sql 就是这个啊
和SESSION视图关联起来看: Select b.SID,b.SERIAL#,b.USERNAME,b.MACHINE,b.Module,a.SQL_TEXT From v$sqltext a,v$session b Where b.SQL_ADDRESS=a.ADDRESS And b.SQL_HASH_VALUE=a.HASH_VALUE Order By b.SID,b.SERIAL#,a.piece;
用pl/sql developer 显示的信息不全呀?
就是这个啊
Select b.SID,b.SERIAL#,b.USERNAME,b.MACHINE,b.Module,a.SQL_TEXT
From v$sqltext a,v$session b
Where b.SQL_ADDRESS=a.ADDRESS And b.SQL_HASH_VALUE=a.HASH_VALUE Order By b.SID,b.SERIAL#,a.piece;