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

.



Relevant Pages

  • Re: after network drop i get ora-03114 not connected to oracle
    ... I guess this is a connection pool feature. ... Why don't you use Oracle managed provider in first place? ... this works fine and when network drops/fails i get a timeout. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: after network drop i get ora-03114 not connected to oracle
    ... Try clearing connection pool and re-create connection when this happens. ... Why don't you use Oracle managed provider in first place? ... this works fine and when network drops/fails i get a timeout. ...
    (microsoft.public.dotnet.framework.adonet)
  • ODP .Net Connection Pool Problem on Web Application
    ... I am a .Net developer of a Large Online Retailling Company. ... like to have your help on a Connection Pool issue. ... Oracle Database 10g. ... it may hit a long query in the database. ...
    (microsoft.public.dotnet.framework.adonet)
  • ODP .Net Connection Pool Problem on Web Application
    ... I am a .Net developer of a Large Online Retailling Company. ... like to have your help on a Connection Pool issue. ... Oracle Database 10g. ... it may hit a long query in the database. ...
    (comp.databases.oracle.server)
  • ODP .Net Connection Pool Problem on Web Application
    ... I am a .Net developer of a Large Online Retailling Company. ... like to have your help on a Connection Pool issue. ... Oracle Database 10g. ... it may hit a long query in the database. ...
    (microsoft.public.dotnet.framework.aspnet)