Re: Monitoring table access

bw000001@pixie.co.za (Billy Wheeler) wrote: >Tod Kehrli <72064.1721@CompuServe.COM> wrote: > >>Is there any way to monitor application access to specific >>tables (i.e. # of selects in a day)? I'm trying to measure >>system usage without putting hooks into the application. > >If you're using Version 7.x, look at OnAudit. Otherwise, *I'm* >stumped. :) Inserts, updates, and deletes can be monitored using triggers that store row values from affected rows in an audit table. I'm not familiar with OnAudit so I don't know how to monitor reads without modifying the applicaton. Roger Tomas AG Communication Systems