RE: Last access in table

Adriano,

To see what happens from now on, turn on auditing for that table. To see what has already happened in the table, you aren't going to have too much luck unless auditing is already on. You could try running the statement below. It won't actually show the last access to that table; instead it shows the FIRST_LOAD_TIME. Of course the first and last might be one and the same if you are lucky.

select sql_text, address, FIRST_LOAD_TIME from v$sqlarea
where upper(sql_text) like upper('%table_name_here%') order by FIRST_LOAD_TIME desc;

If you see something interesting, you can post the ADDRESS into the SQL below to see more of the statement.

select sql_text from v$sqltext
where address = '83C984A4'
order by piece

Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
jerome.whittle_at_scott.af.mil
618-622-4145

> -----Original Message-----
> From: Adriano Freire [SMTP:adriano.f_at_uol.com.br]
>
> DBA's,
>
> How can i see the last(date) access(DML) in a table?
>
> Thanks
>
> Adriano

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Whittle Jerome Contr NCI
  INET: Jerome.Whittle_at_scott.af.mil

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).