Re: Recording Logon and SQL

"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?

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)