Fw: Table last access date?
- From: Robert Freeman <robertgfreeman@xxxxxxxxx>
- To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 19 Nov 2008 16:00:23 -0800 (PST)
Version??? If you are using 9i and later look at fine grained auditing. I
believe this will give you just what you are looking for.
RF
Robert G. Freeman
Author:
OCP: Oracle Database 11g Administrator Certified Professional Study Guide
(Sybex)
Oracle Database 11g New Features (Oracle Press)
Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Oracle9i RMAN Backup and Recovery (Oracle Press)
Oracle9i New Features (Oracle Press)
Other various titles out of print now...
Blog: http://robertgfreeman.blogspot.com
The LDS Church is looking for DBA's. You do have to be a Church member in
good standing. A lot of kind people write me, concerned I may be breaking
the law by saying you have to be a Church member. It's legal I promise! :-)
________________________________
From: "SHEEHAN, JEREMY" <JEREMY.SHEEHAN@xxxxxxx>
To: oracle-l <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, November 19, 2008 7:19:37 AM
Subject: Table last access date?
Does anyone have a way to find out the last time a table was
last accessed? It's something that needs to be figured out for my work and I
wanted to know if anyone has a way to figure this out. If impossible or an
incredible stretch just let me know!
Thanks!
Jeremy
Other related posts:
- » Fw: Table last access date? - Robert Freeman