Hi, I recently started a new development project in .net with an oracle db. I never used oracle before, and I wondered if there is a sqlprofiler like tool for oracle as well?
+3
A:
Oracle provides SQLDeveloper, which includes EXPLAIN tools and AUTOTRACE tools, etc.
P.S. TOAD is nice if you can afford it (at least it was the last time I could afford it).
Hank Gay
2009-03-10 15:56:30
+1
A:
Related with profiling, a bit more general, as involves general performance tuning - Automatic Performance Statistics. Even if you don't want to use it, it will give you idea of the important system performance related views and events.
Anonymous
2009-03-11 07:41:08
+1
A:
The best way to profile your application in Oracle is sql tracing. The sql trace gives you what statements your application executed, the elapsed time for those, for that they waited on and for how long the waits were. The link I have provided is a good start to read about sql tracing.
Yas
2009-03-12 14:55:19
A:
In addition to extended SQL Trace and TKPROF you can profile PL/SQL code with the Oracle supplied package DBMS_PROFILER.
Paul James
2009-03-19 13:07:53