Re: Table last access date?

From: Yong Huang <>
Date: Thu, 20 Nov 2008 10:06:04 -0800 (PST)
Message-ID: <>

> 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       

Received on Thu Nov 20 2008 - 12:06:04 CST

Original text of this message