AWR vs. TKPROF debate
- From: ryan_gaffuri@xxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 11 Aug 2006 14:32:45 +0000
I am on a rather large team and we are trying to come up with a consistent
strategy for performance testing. We want to come up with a way to gather
metrics and measure performance and regiment it so that everyone does
relatively the same thing. This is primarily a batch processing system written
in pl/sql.
I favor an approach of awrrpt.sql plus 10046 trace. We need the awrrpt.sql to
gather bulk metrics during tests where we have alot of threads running to get
cpu, physical IO, redo, etc... to put into our models.
This does not provide enough granularity to measure individual sqls, so I also
want us to gather 10046 traces. This is easy enough since we can gather them
for each batch process instead of having to do it for 1 sql at a time. I want
to keep the awrrpt and the 10046 traces in case we have a performance problem.
We can then review our last well performing plan and compare them. I think it
will make it easier to fix potential performance problems. This is easy enough
and requires little effort.
I am getting some push back on this. Some memberse of the team believe that the
AWR and v$sql_plan views are mature enough where we can get the same
information as we can with a tkprof. I have not looked at the AWR all that
much. Is there any accuracy to this?
Other related posts: