how to fetch last access TIMESTAMP of a table in oracle?

user_9024419 0
Viewed 229

How to fetch the last access date for a table in oracle using the query from Oracle DB? I am using select TIMESTAMP from dba_tab_modifications query it's giving me last updates in table but I need last execution of select query statement on a particular table

Thanks in Advance Sai Kumar

oracle
1 Answers

Oracle does not keep this information by default. You need to enable the appropriate AUDIT rules. But I'd question what problem you think this will solve. Auditing every access to a table will be a lot of audit records.

user_57325370
Related