Re: CPU WAIT in OEM (Light green area)

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 18 Nov 2019 09:02:38 +0000
Message-ID: <CWXP265MB17504D273DCC2F335DCDD2F4A54D0_at_CWXP265MB1750.GBRP265.PROD.OUTLOOK.COM>

What platform are you running on, and what figures does Oracle report in the AWR section for:

Sockets Cores CPUs ?

Your vmstat figures COULD be consistent with CPUs = 4 * Cores, if you were running the equivalent of more than 4 CPU intensive tasks.

Regards
Jonathan Lewis

---

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Jack van Zanen <jack_at_vanzanen.com> Sent: 18 November 2019 00:53
To: oracle-l_at_freelists.org
Subject: CPU WAIT in OEM (Light green area)

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

[https://docs.google.com/uc?id=0BwovDucFT1fXaEREVHNWRWZyNjg&export=download]

---

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 - 10:02:38 CET