Track Application Access to Oracle Tables Easily

To track activity in a schema and find out which applications or users are using your tables and views.

Who is accessing which objects in your Oracle database?

The dynamic performance views v$access and v$session make it easy to find out.

set line 200 pages 200
col object for a15
col type for a15
col username for a8
col osuser for a8
col program for a30
SELECT a.object,
       a.type,
       a.sid,
       b.serial#,
       b.username,
       b.osuser,
       b.program
FROM   v$access a,
       v$session b
WHERE  a.sid    = b.sid
AND    a.owner  = 'HR';