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
