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.
[EMAIL PROTECTED]
618-622-4145
-----Original Message-----
From: Adriano Freire [SMTP:[EMAIL PROTECTED]]
DBA's,
How can i see the last(date) access(DML) in a table?
Thanks
Adriano
