Quick question

[Chucks_k]

Hi,

Does anyone know off-hand what view can be used to find when a particular object was last accessed?

Thanks
Chucks_k

[bgill]

For DDL you can use

select last_ddl_time from dba_objects where object_name = 'OBJECT'

[hrishy]

For DDL you can use

select last_ddl_time from dba_objects where object_name = 'OBJECT'

hmm well that was not the question he asked..

If you wanna find out when was the table last acessed

You can do

a)Auditing

b)user alter table table_name monitoring

and then look at user_tab_modifications

regards
Hrishy

[Chucks_k]

Hi,

Thanks for those tips. Is there any other way u can find out when the last DML was performed on an object, apart from the methods described above?

Thanks once again,
Chucks_k

[patel_dil]

There is no other direct method provided by oracle to find out when DML was last performed on a Table. I think LogMiner is the closest help we can get from Oracle. correct me if I am wrong, anyone.

[marist89]

Originally posted by patel_dil
There is no other direct method provided by oracle to find out when DML was last performed on a Table. I think LogMiner is the closest help we can get from Oracle. correct me if I am wrong, anyone.

Depends. If your object wasn't accessed in your logminer window, you won't get any results from logminer.

This has been a thorn in the Oracle software for years. They tried to address this problem with catio, but with limited if questionable results. The best solution is to use 9i's MONITORING capability.

[jmodic]

Originally posted by marist89
This has been a thorn in the Oracle software for years. They tried to address this problem with catio, but with limited if questionable results.

Khmmm...

I would say they (quite successfully, with unquestionable results) addressed this problem with database auditing capability a looong time ago, way back in Oracle5 if not even earlier....