Search only in titles

---

Basic Monitoring

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.

---

Last Published Tuesday, December 12, 2023