Find session detail which is completed
Hi ,
I need to find the details of the session which is completed.I was able to set the sql_id from v$sql but was not able to get the username as the session is no more in v$session.
I was able to get some information from v$active_session_history but i need to know the username .What all i am having are the tables where were used by the users and i need to know all other details (such as machive ,username etc)
Can anyone share your views.
Regards,
Hussain
Edited by: user608533 on Aug 4, 2009 10:57 AM