RE: Table last access date?
- From: "SHEEHAN, JEREMY" <JEREMY.SHEEHAN@xxxxxxx>
- To: "Jan-Hendrik.Boll@xxxxxxxxxxx" <Jan-Hendrik.Boll@xxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 19 Nov 2008 09:28:52 -0500
that's not a bad idea. I'll suggest that to my team. Someone else sent an
email to me suggesting auditing, but I think that's overkill for the scope of
what we want to do. We want to see which tables haven't been accessed in a
while to see if they can be cleaned up.
Thanks!
Jeremy
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Jan-Hendrik.Boll@xxxxxxxxxxx
Sent: Wednesday, November 19, 2008 9:25 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: 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@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:
