Re: Connection Pooling - tracking users

Mark D Powell wrote:
> Generally speaking there is no way to trace back to the ultimate
> end-user for connections made through a connection pool where all the
> sessions use the same Oracle username and show as the OS user of the
> webserver or application server unless that information is passed to
> Oracle by the application. The Oracle package DBMS_APPLICATION_INFO is
> sometimes used for this purpose.
>
> Possible solutions for this depend on the information Daniel listed.
>
> HTH -- Mark D Powell --

For those with 10g:

SQL> desc v$session

note the new column SERVICE_NAME. Also look at how this has now crept into many built-in packages including DBMS_MONITOR, DBMS_SERVICE, UTL_DBWS, EMD_RAC, DBMS_RESOURCE_MANAGER, etc. Oracle is moving in the direction of connecting and tracing services rather than, or in addition to, by session.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)