Re: How to capture SQL

"Mark Bole" <makbo_at_pacbell.net> wrote in message news:YScVc.4866$QJ3.2354_at_newssvr21.news.prodigy.com...
> Joel Garry wrote:
>
> > "Randy Harris" <randy_at_SpamFree.com> wrote in message
news:<TrxUc.2712$ZC7.249_at_newssvr19.news.prodigy.com>...
> >
> >>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.
> >
> >
>
> If the OP will indicate what the goal is (tuning, auditing, etc) some
> choices would stand out as better than others.
>
> --Mark Bole

I was just trying to identify changes made by an application (with no source code). It's rather easy to detect added tables - spool to a file and use diff. But not quite so simple to tell if tables or records have been altered. Received on Sat Aug 21 2004 - 12:32:49 CDT