database tuning based on wait events
Please tell me the step and how I should tune this problem in my rac database.
select * from gv$system_event where event like '%wait%';
INST_ID EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT
---------- ---------------------------------------------------------------- ----------- -------------- ----------- ------------
TIME_WAITED_MICRO EVENT_ID
----------------- ----------
3 wait list latch free 3 0 92 31
916623 2530878290
3 global enqueue expand wait 117 100 166 1
1657201 3498297576
3 class slave wait 1997 1305 12758910 6389
1.2759E+11 1055154682
3 KSV master wait 1531 244 84128 55
841284599 1510356050
3 DIAG idle wait 4543486 0 9782685 2
9.7827E+10 3176176482
3 kjctssqmg: quick message send wait 52 52 3 0
29029 3613653811
3 wait for sync ack 3 0 7 2
65906 2470511309
3 name-service call wait 4875 1975 136347 28
1363469467 3954828229
3 CGS wait for IPC msg 967557 967125 2770 0
27698984 1736567536
3 wait for tmc2 to complete 1 1 2 2
24025 2612383990
3 wait for votes 67 67 290 4
2901610 687721825
3 wait for record update 1 0 3 3