I activated audit control on one of our Oracle user; activities about this user have been audited into the DBA_AUDIT_TRAIL system view.
This view has a SESSIONID column; i found that this column matches with the V$SESSION.AUDSID column.
I need to gather some information about the audited sessions of this user; i'd like to know what's the sql statement of these sessions and which tables do they access.
Unfortunately, since the DBA_AUDIT_TRAIL sessions are already inactive, i can't find them into the V$SESSION. In addition, i didn't find
Where can i find more information about them?
Thank you.