Use the following query to count changes to the table (insert and update):
Notes:
SELECT count(*)
FROM <table>
WHERE update_date > trunc(sysdate)
Use the following query to reads/selects 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 necessary, you can use P6 Auditing to get a precise picture of usage.
Legal Notices
Copyright © 1999, 2014,
Oracle and/or its affiliates. All rights reserved.
Last Published Friday, January 31, 2014