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. ----- Original Message ----- From: "Powell, Mark D" <mark.powell@xxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Friday, July 16, 2004 10:19 AM Subject: RE: auditing connection pool > Mike, what audit commands do you have in effect? > > And by subsequent sessions do you mean that only one out of say 10 pooled > connections create audit records or that only the first use of a connection > pool session creates an audit record? > > -- Mark D Powell -- > > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Michael McMullen > Sent: Friday, July 16, 2004 8:36 AM > To: oracle-l@xxxxxxxxxxxxx > Subject: auditing connection pool > > > oracle 8.1.7.3, 9.2.0.4 > I have some jdbc connection pools that I would like to audit select table by > user. I notice that the first session to hit the pool will spit out the > audit trail. Any other subsequent sessions don't. I know the connections are > getting reused but why no more audit records and is there an easy fix? > > Thanks > Mike > ---------------------------------------------------------------- > 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 > ----------------------------------------------------------------- > ---------------------------------------------------------------- > 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 > ----------------------------------------------------------------- > ---------------------------------------------------------------- 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 -----------------------------------------------------------------