Re: Table last access date?

You can fetch the last time some table's block has been updated by fetching:
select max(ora_rowscn) from my_tab;

You can always convert scn to timestamp

select max(scn_to_timestamp(ora_rowscn)) from my_tab;

Michael

On Wed, Nov 19, 2008 at 4:19 PM, SHEEHAN, JEREMY <JEREMY.SHEEHAN@xxxxxxx>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
>



-- 
Best Regards
Michael Elkin

Other related posts: