Basic Monitoring

Previous TopicNext TopicContents

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