RE: Table last access date?
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 19 Nov 2008 09:44:29 -0500
>> We want to see which tables haven't been accessed in a while to see
if they can be cleaned up <<
Tables that have not referenced used will not have SQL in the shared
pool though you could build a list of everything that has been used and
subtract that from what exists. Then I would use auditing to monitor
access those tables on the list of potentially unused tables. Some
might be used only monthly, quarterly, or even annually depending on
your applications.
Something else you can check is the dependencies that exist via
dba_dependencies. Some tables that are in fact not used may still be
referenced in code that is used.
-- Mark D Powell --
Phone (313) 592-5148
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of SHEEHAN, JEREMY
Sent: Wednesday, November 19, 2008 9:29 AM
To: Jan-Hendrik.Boll@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Table last access date?
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:
