RE: Extended trace analysis and perf. problem.

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_at_yahoo.com]
>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

--
http://www.freelists.org/webpage/oracle-l