Skip to Main Content

Oracle Database Discussions

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!

Too many wait events

VvsDec 20 2018 — edited Dec 28 2018

Hi All,

i am using Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production  . i found too many wait event in database from number of seconds. so it affect on os memory ?  because i am facing memory issue as well  or can i kill those all session ?

select event, state, count(*) from v$session_wait group by event, state order by 3 desc;

events                                                  state                count(*)

rdbms ipc message                           WAITING          15

SQL*Net message from client          WAITING          8

EMON slave idle wait                        WAITING          5

.........so many.....

This post has been answered by JohnWatson2 on Dec 20 2018
Jump to Answer
Comments
Post Details
Added on Dec 20 2018
13 comments
3,243 views