top 5 events on STATSPACK

[learning_bee]

this database is RAC and we have performance issues with one of the jobs, we tried to eliminate RAC is an issue so we switch it to DEDICATED mode.

Below is the top 5 events during the high CPU utilization.

Top 5 Timed Events
~~~~~~~~~~~~~~~~~~                                                     % Total
Event                                               Waits    Time (s) Ela Time
-------------------------------------------- ------------ ----------- --------
CPU time                                                        3,996    32.13
global cache cr request                         4,885,813       2,252    18.11
db file scattered read                            755,553       1,811    14.56
enqueue                                             6,323       1,469    11.81
db file sequential read                           632,428         972     7.82
          -------------------------------------------------------------

what could it make for the global cache cr request had a high wait time???

thanks,

[davey23uk]

how good is yout interconnect?

see metalink notes 181489.1 and 69048.1

[learning_bee]

Davey23uk,

thanks for your input, we don't see much improving to run the job by switching from RAC to DEDICATED. Do you think it had something to with RAC setup??? or you think it's some other issues on the database itself.

thanks

[learning_bee]

how come I don't have the CPU time on the above top 5 % so how do I know the service time???