Re: Activate SQL logging

From: MCArch <spamfree_at_thankyou.net>
Date: Sun, 13 Feb 2005 06:51:41 GMT
Message-ID: <1OCPd.5158$IA2.283@newssvr31.news.prodigy.com>

"Mark Townsend" <markbtownsend_at_comcast.net> wrote in message news:vdWdnQzhZZ-ZeZPfRVn-jw_at_comcast.com...
>
> > 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
>

I think that's probably just what I needed. Thanks very much. Received on Sun Feb 13 2005 - 00:51:41 CST