Re: auditing connection pool

From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Fri, 16 Jul 2004 11:55:55 -0400
Message-ID: <BAY9-DAV4lXapA5x1rd000a8554@hotmail.com>

solved, pete finnigan told me to audit by access works great

Mike
----- Original Message -----
From: "Michael McMullen" <ganstadba_at_hotmail.com> To: <oracle-l_at_freelists.org>
Sent: Friday, July 16, 2004 10:29 AM
Subject: Re: auditing connection pool

> audit connect by elequery
> audit select table by elequery
>
> No all 10 pooled connection create audit records for the logon/logoff but
> only the first distinct select of a connection pool session creates an
audit
> record. I remember reading somewhere (asktom ?) that you need to use
dbms_?
> to reset the session context in connection pools. Unfortunately, the users
> aren't accessing a package, just 4 tables.
>

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Jul 16 2004 - 11:02:20 CDT