Oracle Profiler

[jasonhuibers]

Is there a similiar utility such as SQL Server Profiler for Oracle? We have a JAVA based application and want to be able to put a trace on buttons that are clicked in the application to see what queries are being executed.

Can anyone make any good suggestions?

 

[LKBrwnDBA]

Oracle provides several means of generating trace and audit files.
The most common is to trace the session.

 ALTER SESSION SET SQL_TRACE=TRUE;

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[jasonhuibers]

Is this something I can execute on pC SQL?

 

[LKBrwnDBA]

What is pC SQL?


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[Dagon]

You could probably switch SQL*Trace on via a log-on trigger for whatever user runs the PC SQL application. You could also enable it at database level for a short time.

For Oracle-related work, contact me through Linked-In.