I do it very simply. I don't need immediate notification,2 minutes to
us is fine.
I simply have a dbms_job that runs every 2 minutes and based on the
time scans the DBA_AUDIT_TRAIL table for what we are looking for.
Means you have to have auditing turned on in the database (see
documentation).
Then the dbms_job simply emails us. There might be better/faster ways
of doing this, but this work, has worked for years and ports between
versions quite nicely.
http://yaodba.blogspot.com/
Received on Fri Mar 17 2006 - 08:20:22 CST
