User talk:Anantha sreeraman
From Oracle FAQ
How do I get join DBA_AUDIT_TRAIL and DBA_HIST_ACTIVE_SESS_HISTORY?
I have a requirement where I need to monitor the number of login/logoff done by an ODI job.
My goal is to get the SQL statements for each session in DBA_AUDIT_TRAIL using sql_id in DBA_HIST_ACTIVE_SESS_HISTORY,
Any help would be highly appreciated.