Toad World® Forums

Oracle workload replay question


#1

I recorded many Oracle workloads to replay on a newer faster server. No matter what the workload I simulate, it always shows the new server as being slower. The top 5 timed events shows otherwise, but the snapshot times shows it took longer on the new server. Below are the top 5 timed events for each. Let me know if there is something I am missing, because when I run items through the Client front end on the new server, everything just flies. (sorry about the formatting below)

Source
Top 5 Timed Events Avg %Total

Event                                            Waits    Time (s)   (ms)   Time
----------------------------------------- ------------ ----------- ------ ------
db file sequential read                        765,929       3,571      5   49.8
CPU time                                                     1,813          25.3
db file scattered read                       1,226,792       1,438      1   20.1
Streams AQ: enqueue blocked on low memory            1         300 ######    4.2
db file parallel read                              872          19     22     .3

Target
Top 5 Timed Events                                                    Avg %Total
~~~~~~~~~~~~~~~~~~                                                   wait   Call
Event                                            Waits    Time (s)   (ms)   Time
----------------------------------------- ------------ ----------- ------ ------
CPU time                                                       179          68.2
db file sequential read                         32,188          35      1   13.4
log file parallel write                         10,552          15      1    5.6
log file sync                                    9,020          13      1    5.1
db file scattered read                           1,696           9      5    3.4

#2

I am not sure what is happening here. The metric that BMF looks at to determine which server performs faster is the response time(s) of the SQL from the BMF point of view. Can you tell me what your average response times are for target server?