Re: auditing connection pool

From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Fri, 16 Jul 2004 10:29:52 -0400
Message-ID: <BAY9-DAV201i6bdVJWr000c2b11@hotmail.com>

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_at_eds.com> To: <oracle-l_at_freelists.org> 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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Michael McMullen
> Sent: Friday, July 16, 2004 8:36 AM
> To: oracle-l_at_freelists.org
> 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_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
> -----------------------------------------------------------------
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
>

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 - 09:33:19 CDT