If we want to check the objects that a particular session id(SID) is accessing in oracle we can use the below SQL.

SELECT a.object,
       a.owner,
       a.type,
       a.sid,
       s.username,
       s.osuser,
       s.program
FROM   v$access a,
       v$session s
WHERE  a.sid   = s.sid
AND    a.sid = &sid_to_check
ORDER BY a.object