how to find session detail of completed session
ivwviDec 21 2008 — edited Dec 22 2008I am using 10g
And need to know details of session/serial# having executed given sql .
Session is completed and sql is not in v$sqlarea
v$session has no entry for completed session.
Is there any view which contains the history of v$session as session is completed (consider audit trail is set to DB)
How to dig down the session information like from which machine has executed this sql under such sid/serial#
given:sid/serial# and sql
say auditing is on
unfortunately sql_id is missing
need to find : session deatils like machine username etc