On 08/29/2016 01:06 AM, Apps DBA wrote:
Hello Gogala/Amir,
Thanks for your response. I dont see any problem in the wait events,
EVENT COUNT(*) AVG(B.WAIT_TIME)
---------------------------------------- ---------- ----------------
VKTM Logical Idle Wait 1 0
VKRM Idle 1 0
smon timer 1 0
JOX Jit Process Sleep 1 0
AQPC idle 1 0
direct path read temp 1 0
lreg timer 1 0
Streams AQ: emn coordinator idle wait 1 0
Streams AQ: qmn coordinator idle wait 1 0
wait for unread message on broadcast cha 1 0
nnel
heartbeat redo informer 1 0
pmon timer 1 0
Streams AQ: qmn slave idle wait 2 0
LGWR worker group idle 2 0
DIAG idle wait 2 0
jobq slave wait 2 0
Space Manager: slave idle wait 3 0
EMON slave idle wait 5 0
Streams AQ: waiting for time management 5 0
or cleanup tasks
rdbms ipc message 16 0
pipe get 21 0
Streams AQ: waiting for messages in the 29 0
queue
SQL*Net message from client 187 0
23 rows selected.
I believe there is something wrong with network/storage. below find the Oswatcher netstat info.
Linux OSWbb v7.3.3
zzz ***Mon Aug 29 00:00:21 EDT 2016
Kernel Interface table
Iface MTU RX-OK RX-ERR RX-DRP RX-OVR TX-OK TX-ERR TX-DRP TX-OVR Flg
eth0 1500 8803635 0 412 0 7038079 0 0 0 BMRU
eth1 9000 45572028 0 263 0 48337634 0 0 0 BMRU
lo 65536 7919428 0 0 0 7919428 0 0 0 LRU