Re: Tracking "selects"

From: <rene.nyffenegger_at_gmx.ch>
Date: 29 Jun 2005 01:11:41 -0700
Message-ID: <1120032701.586336.30470@g49g2000cwa.googlegroups.com>

> On 2005-06-28, Frank van Bortel <frank.van.bortel_at_gmail.com> wrote:
> > LineVoltageHalogen wrote:
> >> Does Oracle keep track of the "selects" issued against the database in
> >> the redo/archived logs? I need to know who viewed what data.
> >>
> >> Thanks.
> >>
> > Logminer can be used to track changes through redo. Not sure
> > about selects.
>
> Only when the selects do delayed block clean outs.

I realize that this folloup of mine is not accurate. I meant to write that a select statement writes to redo logs only when delayed block clean outs are involved. But still, it won't be possible to get the select statement out of the redo log.

> --
> Rene Nyffenegger
> http://www.adp-gmbh.ch/
Received on Wed Jun 29 2005 - 03:11:41 CDT