Re: How to capture SQL

Randy Harris wrote:

> Is there a simple means of capturing an SQL statement sent from an
> application to an Oracle 9i server (on the server end)? I've been looking
> through the documentation, not sure if this should be done with trace, or
> auditing or if there is some way to enable SQL logging, or dump the redo log
> or something else.

Look at the DBMS_SUPPORT built-in package. http://www.psoug.org/reference/dbms_support.html

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)