Re: In Search Of SQL Profiler...

Kilik wrote:
> One of the features of SQL Server that I found really useful was the
> profiler. It was really useful to have a trace window that would tell
> me what statements were executing as I ran an application. This
> really comes in handy when trouble shooting an issue in an existing
> application.
>
> I've done a bit of searching for an equivalent tool in the Oracle
> world but I haven't found anything that I like.
>
> Does anyone out there have any recommendations?
>
> -Thx
>

For starting a trace, we use the 10046 trace facility in Oracle. You can find more information here:

http://tonguc.wordpress.com/2006/12/30/introduction-to-oracle-trace-utulity-and-understanding-the-fundamental-performance-equation/ http://www.databasejournal.com/features/oracle/article.php/3469891

There are other sources as well...just Google "oracle 10046 trace".

The 10046 trace is probably the closest thing in Oracle to SQL Server's SQL Profiler.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com