Oracle RAC environment Performance issue related Wait events and example threshold

Oracle RAC environment Performance issue related Wait events  and example threshold.



1)Current gcs_drm_freeze_in_enter_server_mode waits 150 exceed threshold 100
2)Current log_file_sync waits 62 exceed threshold 50
3)Current latch:_cache_buffers_chains waits 314 exceed threshold 60.
4)Current row_cache_lock waits 20 exceed threshold 20.
5)Current library_cache_lock waits 80 exceed threshold 50.
6)Current latch:_cache_buffers_chains waits 440 exceed threshold 50.
7)Current latch_free waits 81 exceed threshold 25.
8)Current no. active_user 799 exceed threshold 300.
9)Current CSS_initialization waits 2 exceed threshold 2.
10)Current latch:_row_cache_objects waits 127 exceed threshold 50.
11)Current library_cache_lock waits 51 exceed threshold 50.
12)Current log_file_sync waits 167 exceed threshold 100.
13)Current gcs_drm_freeze_in_enter_server_mode waits 79 exceed threshold 70.
14)Current gc_buffer_busy waits 181 exceed threshold 60.
15)Current buffer_busy_waits waits 114 exceed threshold 50.
16)Current enq:_TX_-_allocate_ITL_entry waits 95 exceed threshold 70.
17)Current enq:_TX_-_index_contention waits 79 exceed threshold 70.
18)Current enq:_CF_-_contention waits 6 exceed threshold 5.
19)Current flashback_buf_free_by_RVWR waits 34 exceed threshold 15.
20)Current TCP_Socket_(KGAS) waits 20 exceed threshold 20.
21)Current enq:_TX_-_row_lock_contention waits 504 exceed threshold 500.
22)Current enq:_TX_-_index_contention waits 255 exceed threshold 200.
23)Current enq:_TX_-_allocate_ITL_entry waits 113 exceed threshold 70.
24)Current enq:_HW_-_contention waits 28 exceed threshold 10.
25)Current latch_free waits 30 exceed threshold 25.
26)Current CSS_operation:_action waits 2 exceed threshold 2.
27)Current enq: waits 0 exceed threshold SV.
28)  latch: ges resource hash list