var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Can you tell when a table has last been modifed / accessed ?
Thanks in advance to all who reply.
Last accessed :When select is performed on a table, then that time and date will become the last accessed for the table.
: When commands like
Last modified insert/update/delete are performed on a table, then that time and date will become the last modified for the table.
Thanks ! Is that info stored in a table / view ? dba_tables ? I am a novice so please forgive me it these questions seem trivial !
The Detail is available in System table : sys.dba_audit_object.
One option is as follows:
(1) Turn the auditing on: AUDIT_TRAIL = true in init.ora
(2) Restart the instance if its running.
(3) Audit the table:
AUDIT INSERT,SELECT,DELETE,UPDATE on TableName
by ACCESS WHENEVER SUCCESSFUL
(4) Get the desired information using :
SELECT OBJ_NAME,ACTION_NAME ,to_char(timestamp,'dd/mm/yyyy , HH:MM S')
No. You may want to look at Oracle's
Thanks for all your help ! Will use of the audit affect performance ?
Yes, for every audited action performed, the db will have to write to the sys.ADU$ table. However, under normal circumstances, you should not be able to notice it.
Originally Posted by