Hi all,

I have the application and I want to know how it executed behind the scene if I look into v$SQLAREA I don't know which one belong to that session and if I executed the script below

SELECT A.SID,A.USERNAME,S.SQL_TEXT
FROM V$SESSION A,V$SQLTEXT S
WHERE A.SQL_ADDRESS = S.ADDRESS
AND A.SQL_HASH_VALUE = S.HASH_VALUE
ORDER BY A.USERNAME,A.SID,S.PIECE;


sometime it doesn't capture. does anyone have a better scripts to capture the query that was executed from the application???
Thanks



BTW: how can we clear the V$SQLAREA ????