Hi guys,

On a V8 database I want to put an alert if there is no DML activity i.e. insert/update/delete for a specified period of time; let's say 10 minutes.Any idea what can be done to achieve this?

Thanks in advance.

Paul

You could probably use a statement event monitor, see the System Monitor Guide.

Would slow things down a bit, though.

Thanks Jonathan.

I made use of the Rows deleted/Rows inserted and Rows updated to track the activity within the database. Thanks.

Paul