RE: Table last access date?
- From: "SHEEHAN, JEREMY" <JEREMY.SHEEHAN@xxxxxxx>
- To: "daniel.fink@xxxxxxxxxxxxxx" <daniel.fink@xxxxxxxxxxxxxx>
- Date: Wed, 19 Nov 2008 09:43:18 -0500
I believe we're using statspack there. This is a 9i DB so we can't use AWR on
it, but I think we're slated to upgrade soon so that's another possibility!
Thanks!
Jeremy
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Daniel Fink
Sent: Wednesday, November 19, 2008 9:37 AM
To: SHEEHAN, JEREMY
Cc: oracle-l
Subject: Re: Table last access date?
If you are using statspack or licensed for AWR, you can look at the historical
data. You need to look for the table name in sql statements and any views that
reference that table.
Statspack - stats$sqltext contains the actual text of a statement. Using the
sql_ids from this table, you can query stats$sql_summary and stats$snapshot to
get the time information
AWR - dba_hist_sqltext contains the actual text of a statement. Use the sql_id
to access dba_hist_sqlstat and dba_hist_snapshot
Regards,
Daniel Fink
--
Daniel Fink
OptimalDBA.com - Oracle Performance, Diagnosis, Data Recovery and Training
OptimalDBA http://www.optimaldba.com
Oracle Blog http://optimaldba.blogspot.com
Lost Data? http://www.ora600.be/
SHEEHAN, JEREMY wrote:
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:
