Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Connection Pooling - tracking users
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 -- Received on Wed Jul 06 2005 - 10:08:33 CDT