• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 511
  • Last Modified:

How to get the web page name in v$session table in Oracle database



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
0
OCUBE
Asked:
OCUBE
1 Solution
 
slightwv (䄆 Netminder) Commented:
I've never used this but check out: DBMS_APPLICATION_INFO.SET_MODULE

http://www.experts-exchange.com/Database/Oracle/Q_26431656.html

The way I've done this in the past is add comments to the SQL in the .Net code.

VB stub:
sqlStr = "select /* " & scriptNameVariable & " */ column from table"

Then you can look in v$sqlarea to see the text being executed.
0
 
OCUBEAuthor Commented:

Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now