SQL Server Profiler

Posts   
 
    
Krish
User
Posts: 91
Joined: 02-Jan-2008
# Posted on: 08-Feb-2008 21:15:21   

What is the equivalent tool in Oracle database, to SQL Server profiler?

I would like to see the queries LLBLGen uses and how often, to access, update the database.

How do you go about doing this, with Oracle databases.

LLBLGen Pro 2.5 Demo Self-servicing two class template. ASP.NET 2.0

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39797
Joined: 17-Aug-2003
# Posted on: 09-Feb-2008 12:17:13   

Moved to General Chat

Oracle doesn't come with a profiler if I'm not mistaken, though there are many informational views about performance metrics and there are some DBMS_* statements you can use to prfile Oracle. Try a google search, or search the Oracle manual on profiling.

Frans Bouma | Lead developer LLBLGen Pro
Posts: 30
Joined: 08-Apr-2008
# Posted on: 08-Apr-2008 11:59:04   

In Oracle, you'll probably want to query V$SQL_PLAN to view the statements being executed. Every statement goes into the library cache so the execution plan can be re-used by another similar query. V$SQL_WORKAREA is another view you may want to take a look at.