Re: best way to log all sql queries?
Date: Mon, 04 Feb 2008 15:23:38 -0800
> 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!
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 damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Mon Feb 04 2008 - 17:23:38 CST