Re: Performance issues with SSD on DELL servers

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 am not sure how this result was produced, by having 0 waiting time for all events suggests that your applications are running like a greased lightning.

>
> 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
Yes, dropped packets do suggest problems with network. That also suggests the issue with your query against V$SYSTEM_EVENTS, because network issues should have resulted in marked increase of waiting time for the network events.
Regards

-- 
Mladen Gogala
Oracle DBA
Tel:(347) 321-1217 <tel:%28347%29%20321-1217>



>



-- 
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217


--
http://www.freelists.org/webpage/oracle-l