Re: Auditing

"Sybrand Bakker" <gooiditweg_at_sybrandb.verwijderdit.demon.nl> wrote in message news:omqhl0t04nil8ubshc8e7vdarslh1hkmke_at_4ax.com...
> On Mon, 27 Sep 2004 23:07:02 GMT, "Oradba Linux"
> <techiey2k3_at_comcast.net> wrote:
>
> >Question about auditing web connections to the oracle 9204 DB .
> >
> >There is a pool of connections from an application server like weblogic.
> >Auditing is turned on in such a way that select on a table
> >by session should create an audit entry. Will x many entries get created,
if
> >x sessions (?) access the database using the same connection or will just
> >one entry be recorded even though 100 web users could have used the same
> >connection and accessed the database.
> >
> >
>
> a session is a session, so x many entries will be created.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA

I am not seeing this behavior. When there are 50 persistent connections from an application server into the database, i see only 50 audit entries in sys.aud$. If 1000s of web users access the application, they still use one of the persistent connections and only create one audit entry in sys.aud$. Unless that connection is refreshed, there is no audit entry created in the database. Received on Tue Sep 28 2004 - 11:28:55 CDT