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. |
Is there a way to collate the data created by DBMS_TRACE and DBMS_PROFILER, and would that even be useful?
The two tools don't "know about each other", so it's up to us to comment things correctly so we can collate the information collected by each tool. When you start profiling make sure you put something meaningful into the comment field of the DBMS_PROFILER.START_PROFILER('comment'); call. If this comment and the comment used in the DBMS_TRACE.COMMENT_PLSQL_TRACE('comment'); call have a relation then it should be easy to collate the output of each.
|
Powered by FogBugz