Re: best way to log all sql queries?

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

Also look at Oracle's Audit Vault.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org