RE: auditing connection pool

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Fri, 16 Jul 2004 10:19:43 -0400
Message-ID: <564DE4477544D411AD2C00508BDF0B6A2133DDF9@usahm018.exmi01.exch.eds.com>

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

Received on Fri Jul 16 2004 - 09:17:51 CDT