Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!news-FFM2.ecrc.net!newsfeed.vmunix.org!newspeer1-gui.server.ntli.net!ntli.net!news2.euro.net!newsfeed.kabelfoon.nl!195.129.110.21.MISMATCH!bnewsfeed00.bru.ops.eu.uu.net!bnewsinpeer00.bru.ops.eu.uu.net!lnewspeer00.lnd.ops.eu.uu.net!lnewspost00.lnd.ops.eu.uu.net!emea.uu.net!not-for-mail From: "Niall Litchfield" Newsgroups: comp.databases.oracle.server References: <3F084E8D.24ED1ECF@exxesolutions.com> Subject: Re: Recording Logon and SQL Date: Mon, 7 Jul 2003 14:52:07 +0100 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Lines: 24 Message-ID: <3f097b0a$0$15036$ed9e5944@reading.news.pipex.net> NNTP-Posting-Host: host9.audit-commission.gov.uk X-Trace: 1057585931 reading.news.pipex.net 15036 193.128.236.219 X-Complaints-To: abuse@uk.uu.net Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:237058 "Daniel Morgan" wrote in message news:3F084E8D.24ED1ECF@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 UK