How to get the web page name in v$session table in Oracle database
Posted on 2010-08-30
We have asp.net web application hosted on IIS (windows) and connecting to Oracle database (10g).
When I query the v$session table in the database, all I see the program name as "w3wp.exe"
coming from the IIS (web server) host machine.
Now its hard to diagnose as which session in the database is referring to which web page in the web application.
If I have 10 web pages open in my web application connecting to Oracle database, now if I wanted to get there
session info, when I browse the v$session all it shows me is "w3wp.exe" .
Now is there a way to get the web page name in the v$session.
( may be it needs some changes to code in the asp.net web application , change in configuring IIS web server as well ).
Let me know