Get sql_text's executed by another user !
Hi all,
I want view sql was executed by another user, I use bellow scipt:
--------------------------------------
select sesion.sid,
sesion.username,
optimizer_mode,
hash_value,
address,
cpu_time,
elapsed_time,
sql_text
from v$sqlarea sqlarea, v$session sesion
where sesion.sql_hash_value = sqlarea.hash_value
and sesion.sql_address = sqlarea.address
and sesion.username is not null
--------------------------------------
But in the sql_text, content of sql not enough ! Seem as it was cutted ! Ex: original content is abc123 --> after elect it has value is abc.
Are there some methods that I can view completely sql text ?
0