 | |
best way to log all sql queries?
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
best way to log all sql queries? -
02-04-2008
, 04:39 PM
#2
| |||
| |||
|
|
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 |
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
#3
| |||
| |||
|
|
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 |
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
#4
| |||
| |||
|
|
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 |
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
#5
| |||
| |||
|
|
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 |
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
#6
| |||
| |||
|
|
mh (AT) pixar (DOT) 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 |
Thanks!
--
Mark Harrison
Pixar Animation Studios
#7
| |||
| |||
|
|
mh (AT) pixar (DOT) 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 |
Thanks!
--
Mark Harrison
Pixar Animation Studios
#8
| |||
| |||
|
|
mh (AT) pixar (DOT) 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 |
Thanks!
--
Mark Harrison
Pixar Animation Studios
#9
| |||
| |||
|
|
mh (AT) pixar (DOT) 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 |
Thanks!
--
Mark Harrison
Pixar Animation Studios
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.