Newsgroups: comp.databases.oracle.server Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!rip!news.webusenet.com!peer01.cox.net!cox.net!news.maxwell.syr.edu!newspeer.radix.net!news.er.usgs.gov!news From: Brian Peasland Subject: Re: Recording Logon and SQL X-Nntp-Posting-Host: edcxpw014.cr.usgs.gov Content-Type: text/plain; charset=us-ascii Message-ID: <3F098B26.A72484B2@remove_spam.peasland.com> Sender: news@igsrsparc2.er.usgs.gov (Janet Walz (GD) x6739) Content-Transfer-Encoding: 7bit Organization: U.S. Geological Survey, Reston VA X-Accept-Language: en References: Mime-Version: 1.0 Date: Mon, 7 Jul 2003 15:00:54 GMT X-Mailer: Mozilla 4.78 [en] (Windows NT 5.0; U) Lines: 31 Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:237066 Others have addressed that auditing is the mechanism you need. But I wonder *why* you want to do this at all? Audit every single SQL statement that a user enters? Why? Another option is to set up tracing of every session. But be prepared for the disk requirements to store those large trace files. Cheers, Brian "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. -- =================================================================== Brian Peasland oracle_dba@remove_spam.peasland.com Remove the "remove_spam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three"