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

Posted on 2010-08-30
Medium Priority
Last Modified: 2012-05-10

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
Question by:OCUBE
LVL 78

Accepted Solution

slightwv (䄆 Netminder) earned 2000 total points
ID: 33559837
I've never used this but check out: DBMS_APPLICATION_INFO.SET_MODULE


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.

Author Closing Comment

ID: 33578657


Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question