Solved

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

Posted on 2010-08-30
2
429 Views
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
0
Comment
Question by:OCUBE
2 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 33559837
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
 

Author Closing Comment

by:OCUBE
ID: 33578657

Thanks
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to create an MVC5, Razor Widget 2 26
exporting html table data 4 27
asp Google Map 2 26
Error in creating a view. 8 21
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

840 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