Method R Discussion GroupMethod R helps developers, DBAs, and decision-makers optimize Oracle-based software in every phase of the software life cycle. |
||
Discuss Method R products, techniques, and events. Ask new questions or post your own responses. |
Which of these tools is more useful? I have impression that DBMS_TRACE generates far too much information.
DBMS_PROFILER is likely to be the more useful of the two. TRACE could be very useful in an environment where you are unfamiliar with the architecture of the application. With TRACE you could see where someone goes when the do particular functions and there for focus your attention on particular procedures and functions rather then guesses which ones get called frequently. But since TRACE doesn’t give any timing information its usefulness is limited.
|
Powered by FogBugz