Mark Townsend wrote:
>
> > Just trying to figure out what an application is doing to the
> database. I
> > thought there would be some way to activate a log, that would capture
> the
> > SQL.
>
> Would mining the redo log and then querying V$LOGMNR_CONTENTS give you
> what you want - see
> http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10825/logminer.htm#sthref1988
>
[snip!]
8.1.7, Mark - logminer in 8i? Do not think so.
As an alternative to the SQL tracing, one could also
try SQL*Net tracing (on the client, using the application),
if this is a client/server type application.
--
Regards,
Frank van Bortel
Received on Sun Feb 13 2005 - 05:12:09 CST
