Re: best way to log all sql queries?

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.
>
> http://www.psoug.org/reference/dbms_fga.html

Ah, that's just what I want, I will experiment with that, Thanks!

-- 
Mark Harrison
Pixar Animation Studios