solved, pete finnigan told me to audit by access works great Mike ----- Original Message ----- From: "Michael McMullen" <ganstadba@xxxxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------