Well,my nice bosses wants to "capture" everything from aud$, and also-a program who enter a particular command (for example TOAD.exe,sqlplus.exe and so on)
So,I find very useful information-for example-userid,userhost,sqltext in aud$
and some kind of "history of session" in v$active_session_history.
But,my problem is join of this 2 tables (beacause serial_id means diffferent things in that tables)
So,how can I join this table and that view?
Correlate aud$ and v_active_session_history?
Which column is correlation between table aud$ and v$active_session_history?