Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Recording Logon and SQL
"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message
news:3F084E8D.24ED1ECF_at_exxesolutions.com...
> "netnews.comcast.net" wrote:
>
> > Does anybody know of a way to track every user
> > and SQL statement from the v$session and
> > v$sqlarea without using auditing. Currently we are using
> > a stored procedure that polls these tables but sometimes
> > the pool is flushed allowing statements to slip in between the cracks.
> > Looking for a better way of doing this.
>
> What you are trying to do is auditing. Why don't you want to reinvent the
> wheel?
Because they have worked out that auditing everything every user ever does
might be entirely unmanageable, but haven't yet worked out that it is the
request that is wholly daft and not the method of obtaining the data.
-- Niall Litchfield Oracle DBA Audit Commission UKReceived on Mon Jul 07 2003 - 08:52:07 CDT