To find list of objects accessed by a database session

Here is a simple query that shows all the objects accessed by a database:

SELECT sid,
       owner,
       TYPE,
       object
  FROM v$access
 WHERE sid = 'session_id';

Ex:

SELECT sid,

       owner,

       TYPE,

       object

  FROM v$access

 WHERE sid = '769';