Re: Table last access date?
Date: Thu, 20 Nov 2008 10:06:04 -0800 (PST)
> you could try to select * from v$sql where lower(sql_text) like
> The column LAST_LOAD_TIME will tell you when the statement has been
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 HuangReceived on Thu Nov 20 2008 - 12:06:04 CST