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.....