RE: Grid agent and CPU
Date: Sat, 24 Jun 2017 12:51:44 +0000
Message-ID: <30952_1498308716_594E606C_30952_5389_1_ECDEF0CC6716EC4596FCBC871F48292AB189C78D_at_ZRH-S231>
P.S. to answer your question: yes, we have to plan for overhead caused by monitoring. However, if you decide to build your own monitoring solution it is worth studying the Google guidelines ( https://landing.google.com/sre/book/chapters/practical-alerting.html ) for achieving the optimal solution.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Noveljic Nenad
Sent: Samstag, 24. Juni 2017 14:25
To: 'oralrnr_at_gmail.com'; oracle-l_at_freelists.org
Subject: RE: Grid agent and CPU
It is because of its architecture. What I mean by that is the Agent process permanently fires probes which are implemented as independent Perl and Java programs.
Just take a look at the truss -c -f output for an Oracle Cloud Control Agent process:
function time(s) count
lwp_park 22.465 173347
lwp_unpark 2.805 93786
...
forkx 87.612 1311
...
yield 11.617 190621 lwp_suspend 140.853 1115963 lwp_continue 8.329 1117835
...
- ------
sys totals: 304.582 3277516
usr time: 215.874
elapsed: 2106.830
In the example above, 15% of the elapsed time is the OS kernel CPU time spent just on thread management and forking!
Nenad Noveljic
Twitter: _at_NenadNoveljic
Home page: http://nenadnoveljic.com/blog
From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Orlando L
Sent: Samstag, 24. Juni 2017 11:17
To: oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>
Subject: Grid agent and CPU
Hi,
We had some prod servers with grid/cloud agents installed, but realized that they were a significant Cpu hog in that they were consuming 20-30% of the cycles in some AIX LPARs with 4-8 cores consistently. I am talking non stop for hours, days and weeks. Talking to support did not help us much except 'apply a patch' which did not help.
After lots of internet search, it looks like this seems to be an issue with several tools and specifically grid agent. Do the listers plan for a certain amount of CPU during architecture phase for monitoring tools when they carve out db servers.
TIA, Orlando.
Please consider the environment before printing this e-mail. Bitte denken Sie an die Umwelt, bevor Sie dieses E-Mail drucken.
Important Notice
This message is intended only for the individual named. It may contain confidential or privileged information. If you are not the named addressee you should in particular not disseminate, distribute, modify or copy this e-mail. Please notify the sender immediately by e-mail, if you have received this message by mistake and delete it from your system.
E-mail transmission may not be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete. Also processing of incoming e-mails cannot be guaranteed. All liability of the Vontobel Group and its affiliates for any damages resulting from e-mail use is excluded. You are advised that urgent and time sensitive messages should not be sent by e-mail and if verification is required please request a printed version.
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">p { font-family: Arial;font-size:9pt }</style>
</head>
<body>
<p>
<br>Important Notice</br>
<br>This message is intended only for the individual named. It may contain confidential or privileged information. If you are not the named addressee you should in particular not disseminate, distribute, modify or copy this e-mail. Please notify the sender immediately by e-mail, if you have received this message by mistake and delete it from your system.</br>
<br>E-mail transmission may not be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete. Also processing of incoming e-mails cannot be guaranteed. All liability of the Vontobel Group and its affiliates for any damages resulting from e-mail use is excluded. You are advised that urgent and time sensitive messages should not be sent by e-mail and if verification is required please request a printed version.<br/>
</p>
</body>
</html>
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Jun 24 2017 - 14:51:44 CEST