RSS Feed

Method R Discussion Group

Environment: using the profiler 5.2.4.0 under windows XP.

Background information:  I have been using the orasrp resource profiler and just recently purchased the Hotsos profiler.  There are some things and options the orasrp profiler does that I really like and I am trying to figure out how to accomplish similar things with the Hotsos resource profiler.

First question: Is there any way to turn off the “recursive sql” so that the profiler only shows you SQL from your application and not the internal dictionary related processing that Oracle does related to your SQL?  ( In orasrp you can do this by specifying –sys=no as an option ).

Second question:  can you force the hotsos resource profiler to show your SQL statements in the order in which they appear in the trace file?  I really use this feature all the time … following the logic of applications from the SQL in the trace file.  ( In orasrp you can do this by specifying –sort=crsid as an option ... lots of different ways to sort ... tkprof of course has similar options ).

Third question:  it appears the Hotsos profiler automatically turns off reporting for SQL statements that it decides are irrelevant/immaterial to the overall profile.  Can you force it to report on all the SQL statements?