Re: best way to log all sql queries?
Date: Tue, 05 Feb 2008 00:33:22 GMT
DA Morgan <damorgan_at_psoug.org> wrote:
> mh_at_pixar.com wrote:
> > We have a database where users can make ad hoc queries. I would
> > like to be able to log all queries and dml for this database,
> > so that we can have some insight into how the database is
> > being used, and for performance forensics, etc.
> > What's the best way to do this?
> > Many TIA!
> > Mark
> Assuming a currently supported version of the product use the built-in
> auditing capabilities including Fine Grained Auditing implemented with
> the DBMS_FGA built-in package.
Ah, that's just what I want, I will experiment with that, Thanks!
-- Mark Harrison Pixar Animation StudiosReceived on Mon Feb 04 2008 - 18:33:22 CST