RE: CPU Wait troubleshoot

My understanding of the RWP recommendation is that max session should be between 1 and 10 times the number of cores, depending on the percentage time spent on IO versus CPU for your app.

On a 32 Core system, 320 sessions max, if they are IO intensive. However, if each session is roughly 50/50 on IO versus CPU, you'll probably want a smaller number than 320. As always, testing is your friend.

On the rare occasions when we get in early and have time for full testing, I like to have each app server with a connection pool set very low, and then test for performance versus requirement, and then only go up the way if we don't meet the requirements.

Christopher Osborne

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Stefan Koehler Sent: 12 April 2016 20:38
To: cstephens16_at_gmail.com
Cc: oracle-l_at_freelists.org
Subject: Re: CPU Wait troubleshoot

Hi Chris,
by talking and discussing with the guys.

In addition you also get similar information from their YouTube videos where they talk about a small multiple (e.g. they are using a ratio of 1:6 in this demo case):

• https://www.youtube.com/watch?v=Oo-tBpVewP4
• https://www.youtube.com/watch?v=XzN8Rp6glEo

P.S.: It is a guideline, not a fixed recommendation.

Best Regards
Stefan Koehler

Freelance Oracle performance consultant and researcher Homepage: http://www.soocs.de
Twitter: _at_OracleSK

> Chris Stephens <cstephens16_at_gmail.com> hat am 12. April 2016 um 21:17 geschrieben:
>
> Where are you getting the RWP recommendations from?
--
http://www.freelists.org/webpage/oracle-l

Information in this email including any attachments may be privileged, confidential and is intended exclusively for the addressee. The views expressed may not be official policy, but the personal views of the originator. If you have received it in error, please notify the sender by return e-mail and delete it from your system. You should not reproduce, distribute, store, retransmit, use or disclose its contents to anyone. Please note we reserve the right to monitor all e-mail communication through our internal and external networks. SKY and the SKY marks are trademarks of Sky plc and Sky International AG and are used under licence. Sky UK Limited (Registration No. 2906991), Sky-In-Home Service Limited (Registration No. 2067075) and Sky Subscribers Services Limited (Registration No. 2340150) are direct or indirect subsidiaries of Sky plc (Registration No. 2247735). All of the companies mentioned in this paragraph are incorporated in England and Wales and share the same registered office at Grant Way, Isleworth, Middlesex TW7 5QD. †Ûiÿü0ÁúÞzX¬¶Ê+ƒün– {ú+iÉ^ Received on Mon Apr 18 2016 - 16:29:42 CEST