Use the following query to count changes to the table (insert and update):
SELECT count(*)
FROM <table>
WHERE update_date > trunc(sysdate);
Use the following query to read/select rows from REFRDEL in a single step:
SELECT TABLE_NAME, count(*)
FROM REFRDEL
WHERE delete_date > (sysdate);
GROUP BY TABLE_NAME
ORDER BY TABLE_NAME
When needed, you can use P6 Auditing to get a precise picture of usage.
Notes:
- These queries should run at the end of the day to capture all the changes from that day.
- These queries must be repeated for all the critical tables.