-
tracing session to see how the application was executed in Oracle
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 ????
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|