Re: Table last access date?

> 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.

If you decide to use that column, why not use last_active_time? It doesn't require the cursor to be reloaded so it may well be more recent. But of course, this column only exists in 10g and up.

In case the table name doesn't exist in v$sql% (because the SQL uses synonyms, packages/functions, etc.), you can check v$bh or x$bh for blocks that belong to the table in question. Limitations are obvious though.

Yong Huang       

--
http://www.freelists.org/webpage/oracle-l