AW: Table last access date?

Hi,  

you could try to select * from v$sql where lower(sql_text) like '%table_name%'
The column LAST_LOAD_TIME will tell you when the statement has been stated.  

Jan-Hendrik Boll

Von: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] Im Auftrag von SHEEHAN, JEREMY Gesendet: Mittwoch, 19. November 2008 15:20 An: oracle-l
Betreff: 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

--
http://www.freelists.org/webpage/oracle-l