Posts

Showing posts with the label Trace

How to trace the tables which are impacted by a process in Oracle Cloud Applications.

You can run below SQL before and after submitting the process and check the tables for change in inserts/updates/deletes count. SELECT *    FROM all_tab_modifications  ORDER BY timestamp desc This table stores information of inserts, updates and deletes since the last time statistics were gathered on the tables.  Hope this helps !