Need help interprating v$session_wait,etc

[charity]

Hello,

Does anyone have a script that joins v$session_wait and v$session and itepreates the values for p1,p2,p3,etc and would end up displaying e.g. username,sid,event,object_name, hash_value,etc.
I tried to write one but I have been very unsuccessful.

Please if you do and would like to share can you please email it to me at:

charity_qu@yahoo.com.

Thanks,
Charity

[anandkl]

You can can join both tables based on v$session_wait.sid=v$session.sid and try your query.

regards
anandkl