So I can get the current sessions' information easy:
select USERNAME, MACHINE from v$session;
What can be done to get historical data correlating a USERNAME to MACHINE?
I don't need timestamps; I just would like to be able to a rough idea, through the history, where certain applications login to the database from.
Unfortunately, dba_hist_active_sess_history doesn't have the USERNAME column as v$session does.
Thanks in advance!