RE: Table last access date?

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Nov 19 2008 - 08:43:18 CST