RE: Extended trace analysis and perf. problem.

Brian

>Is it possible to change anything else? :-)

Yes, database version.

>All of the wait time averages for the new setup=20
>are right in line with current production.

Response time =3D service time + wait time

What about CPU?

>If this was database related I'd expect to see=20
>some wait-time averages way off the chart somewhere
>- wouldn't you? Am I missing something if this is=20
>database related - shouldn't it show in the extended
>traces if it was?

If the loads are about 1/2 fast, the response time on the new system = should be twice as the old system. Therefore either you use more CPU or = you wait more time! (or both of course)

>RAC 'C' is the new cluster - all the others are=20
>current production runs.

Mhmm... without analyzing the data in detail, if the forth column is a = run, to me it seams that there are huge differences!

HTH
Chris

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