Re: auditing connection pool

  • From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 16 Jul 2004 10:29:52 -0400

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

Other related posts: