AW: Table last access date?
- From: <Jan-Hendrik.Boll@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 19 Nov 2008 15:25:12 +0100
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
Other related posts:
- » AW: Table last access date? - Jan-Hendrik.Boll
