CPU WAIT in OEM (Light green area)

From: Jack van Zanen <jack_at_vanzanen.com>
Date: Mon, 18 Nov 2019 11:53:04 +1100
Message-ID: <CAFeFPA8akQc96bsQCFQN48tfqfd-exeOOVe8R5cX+w7Er055zQ_at_mail.gmail.com>

Hi All

I am seeing on occasion that CPU WAIT in OEM graph gets very prominent According to "
https://blog.orapub.com/20150210/what-is-light-green-oracle-database-cpu-wait-time.html "
The CPU WAIT is when Oracle is waiting to get on CPU (in the queue)

I would however expect to see CPU pressure when this happens

however on OS CPU have lots of IDLE time

[oracle_at_cltsadm01vm01 AWR]$ vmstat 10 10 procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu-----
 r b swpd free buff cache si so bi bo in cs us sy id wa st
13 0 0 91456296 1246408 72531584 0 0 8 32 0 0 22  4 74 0 0
 9 0 0 91441104 1246408 72532288 0 0 0 188 50024 41230 28  3 69 0 0
13 0 0 91481680 1246408 72533216 0 0 1 266 48898 41615 28  3 69 0 0
 9 0 0 91487496 1246408 72536520 0 0 0 242 60376 46185 26  3 71 0 0
10 0 0 91501456 1246408 72537696 0 0 1 196 45629 37927 24  5 71 0 0
12 0 0 91464880 1246412 72541536 0 0 0 252 46247 39331 29  4 67 0 0

Jack van Zanen

---

This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies. Thank you for your cooperation

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

Received on Mon Nov 18 2019 - 01:53:04 CET