Re: best way to log all sql queries?

From: DA Morgan <>
Date: Mon, 04 Feb 2008 15:23:38 -0800
Message-ID: <> 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.

Also look at Oracle's Audit Vault.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Mon Feb 04 2008 - 17:23:38 CST

Original text of this message