It is possible to list all the tables being accessed in the last 24hrs where the owner of the table is "PROD" using the data dict V$SQLAREA or others.
Thanks a lot
Results 1 to 3 of 3
Thread: identify tables using V$SQLAREA
Click Here to Expand Forum to Full Width