RE: Table last access date?
From: SHEEHAN, JEREMY <JEREMY.SHEEHAN_at_fpl.com>
Date: Wed, 19 Nov 2008 09:28:52 -0500
Message-ID: <8833494F383585499CB855121711D2630446A6C328@JBXEXVS02.fplu.fpl.com>
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!
Date: Wed, 19 Nov 2008 09:28:52 -0500
Message-ID: <8833494F383585499CB855121711D2630446A6C328@JBXEXVS02.fplu.fpl.com>
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jan-Hendrik.Boll_at_dataport.de
Sent: Wednesday, November 19, 2008 9:25 AM
To: oracle-l_at_freelists.org
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_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-lReceived on Wed Nov 19 2008 - 08:28:52 CST