Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Wait Events and Issues

JhilNov 20 2019 — edited Nov 26 2019

Dear Experts ,

We have observed below wait events continuously/

Does it affect DB performance seriously ?   Especially   enq: TM - contention wait event ?                                             

EVENT                                                           INST_ID   COUNT(*)
------------------------------------------------------------ ---------- ----------
gcs remote message                                                    3          5
gcs remote message                                                    1          5
gcs remote message                                                    2          5
EMON slave idle wait                                                  3          5
Space Manager: slave idle wait                                        3          7
Space Manager: slave idle wait                                        1          7
LMS CR slave timer                                                    3          9
LMS CR slave timer                                                    1         10
LMS CR slave timer                                                    2         10
enq: US - contention                                                  2         10
SQL*Net message to client                                             3         11
Space Manager: slave idle wait                                        2         15
class slave wait                                                      3         17
enq: TM - contention                                                  2         17
enq: TM - contention                                                  1         21
class slave wait                                                      2         35
class slave wait                                                      1         36
rdbms ipc message                                                     3         83
rdbms ipc message                                                     1         84
rdbms ipc message                                                     2         84
SQL*Net message from client                                           3        346
SQL*Net message from client                                           2        355
SQL*Net message from client                                           1        358

120 rows selected.

Thanks in advance

Comments
Post Details
Added on Nov 20 2019
10 comments
5,916 views