Snehashish Ghosh Oracle DBA, Snehashish Ghosh Oracle Database Administrator, Snehashish Ghosh 9+ years Oracle DBA,Snehashish Ghosh Oracle Certified Professional,Snehashish Ghosh OCP,Snehashish Ghosh O tagged posts

Check Last Insert Update Merge Time DML Time for each row of a table

by Snehashish Ghosh

Check Last Insert Update Merge Time Data Manipulation Language Operation Time for each row of a table


 Scenario


How to check Last Insert Update Merge Time i.e. Data Manipulation Language Operation Time for each row of a table. The application table does not have a audit column for timestamp and application code cannot be changed due to absence of budget and time.  

Solution


The requirement is to find out the last insert update timestamp for each row of table. Auditing of DML operation on the table cannot be enabled due to performance overhead. Also new column on the table cannot be added to track last update and insert timestamp. Crawl the archive log files using logminer cannot be done as developers are not used to the tool...

Read More