identify tables using V$SQLAREA

[yxez]

Hi Friends,

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

[malay_biswal]

You can find the table names from v$sqlarea/v$sql , but being accessed within last 24 hours. I do not think that condition will be fulfilled by any of these views.

[davey23uk]

you have to set up auditing to do that