RE: Extended trace analysis and perf. problem.
- From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
- To: "Brian Wisniewski" <brian_wisniewski@xxxxxxxxx>
- Date: Fri, 13 May 2005 17:39:54 +0200
Brian
>I pulled the averages out for PARSE and
>EXEC and the averages also seem to be in line
>with current production. The total column is the=20
>number of entries in the trace file and this is
>just a sampling of a run - not a complete run.
1) I don't know how do you "compare" the values. I simply see important =
differences.
2) Averages are not good. They hide too much information.
>It is impossible to trace a run in production and
>then pull that over to this and do an exact compare.=20
>We were able to pull a file that loaded into prod in 16
>minutes and loaded it into the new env and it took 30.
Trace the *same* load on both systems and generate a resource usage =
profile for them. Then you will immediately see what's different.
HTH
Chris
>-----Original Message-----
>From: Brian Wisniewski [mailto:brian_wisniewski@xxxxxxxxx]
>Sent: 13 May 2005 17:22
>To: Christian Antognini
>Subject: RE: Extended trace analysis and perf. problem.
>
>Christian, I pulled the averages out for PARSE and EXEC and the =
averages also seem to be in line
>with current production. The total column is the number of entries in =
the trace file and this is
>just a sampling of a run - not a complete run. It is impossible to =
trace a run in production and
>then pull that over to this and do an exact compare. We were able to =
pull a file that loaded into
>prod in 16 minutes and loaded it into the new env and it took 30.
>
>Any thoughts? - Thanks - Brian
>
> AVG TOTAL EVENT LOAD_TXT
>---------- ---------- ----- ------------------------------
> 1426.59 29261 EXEC Prod run 8317
> 1484.95 52816 EXEC Prod run 14892
> 1595.63 9309 EXEC RAC C 3node noasync initial
> 1673.18 19041 EXEC RAC C 3node async
> 1778.92 19160 EXEC RAC C 1node async
> 2006.78 17486 EXEC RAC C 3node async cert client
> 2130.79 24289 EXEC Prod run amcc
> 3258.19 8123 EXEC Prod run 25464
>
> AVG TOTAL EVENT LOAD_TXT
>---------- ---------- ----- ------------------------------
> 15354.60 5177 FETCH Prod run 25464
> 20395.46 33192 FETCH Prod run 14892
> 28192.50 15390 FETCH Prod run amcc
> 28797.78 12995 FETCH RAC C 3node async
> 29162.50 18721 FETCH Prod run 8317
> 34628.21 6258 FETCH RAC C 3node noasync initial
> 35101.63 13058 FETCH RAC C 1node async
> 37916.84 12001 FETCH RAC C 3node async cert client
--
//www.freelists.org/webpage/oracle-l
Other related posts:
