Tracing an ASP.NET app
720116Dec 9 2010 — edited Dec 9 2010I'm using ODP.NET 2.112.1.0, and a remote 11g server. I have a large ASP.NET application with many modules which was written by many people, and which makes many SQL calls. The app is working. I'd like to get some statistics about how many SQL calls it's makeing, and how long each is taking - to try to improve the performance. But I've been unable to get this data (or even to get a trace file to appear).
I tried adding a <oracle.dataaccess.client> section to my WEB.CONFIG file (in the <configuration> section), but this generated an ASP.NET error that the section was unrecognized.
I tried adding various combinations of the following lines to my SQLNET.ORA file, which have also not resulted in a file being written where I expected (or at all, as far as I can see):
TRACE_UNIQUE_CLIENT= ON
TRACE_DIRECTORY_CLIENT= C:\temp
TRACE_TIMESTAMP_CLIENT= ON
TRACE_LEVEL_CLIENT= 16
TRACE_FILE_CLIENT= SQLNetTrace
And I've tried modifying the following registry entries to HKLM\SOFTWARE\ORACLE\ODP.NET\2.112.1.0 (which were already there, with different values):
TraceFileName (set to: C:\temp\odpnet2.trc)
TraceLevel (set to 1)
TraceOption (set to 0)
In all cases, I've been running the ASP.NET app from Visual Studio 2010 on my development machine using the ASP.NET Development Server. In each case I made sure the Development Server was not running when I made the configuration changes, I then started my app, logged in (which does some SQL), and closed the browser window, and closed the ASP.NET Development Server. In no case did I see a file appear where I expected it, or anywhere on my machine that I could find.
I've read a bunch of documents and web searches, but have not found a solution. Again, I'd like a list of what SQL commands are being sent to the server, and how long each one is taking (and as little else as possible in the log, to reduce what I'll have to wade through). Ideally, I'd like to do this on my development machine, and not on the database server, but if this isn't possible, I'd like to know the easiest path for me to get this data. Thank you.