Bug 1782233

Summary: RFE - Oracle tuned profile
Product: Red Hat Enterprise Linux 8 Reporter: Sanjay Rao <srao>
Component: tunedAssignee: Jaroslav Škarvada <jskarvad>
Status: CLOSED ERRATA QA Contact: Robin Hack <rhack>
Severity: medium Docs Contact:
Priority: unspecified    
Version: 8.4CC: jeder, jskarvad, rhack
Target Milestone: rcKeywords: FutureFeature, Patch, Triaged, Upstream
Target Release: 8.0   
Hardware: Unspecified   
OS: All   
Whiteboard:
Fixed In Version: tuned-2.14.0-0.1.rc1.el8 Doc Type: No Doc Update
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2020-11-04 02:03:07 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 1817044, 1825061    

Description Sanjay Rao 2019-12-11 13:33:56 UTC
Description of problem:
Please add 

[vm]
transparent_hugepages=never


to the tuned-profiles-oracle package.

Oracle databases do not use transparent huge pages and for customers who run Oracle as the main application on their system will choose this profile. Oracle also disables THP on their kernel.



Version-Release number of selected component (if applicable):


How reproducible:


Steps to Reproduce:
1.
2.
3.

Actual results:


Expected results:


Additional info:

Comment 1 Ondřej Lysoněk 2019-12-12 10:59:35 UTC
Hi Sanjay,

we've had 'transparent_hugepages=never' in the Oracle profile from the very beginning [1]. I'm not sure what there is to do.

[1] https://github.com/redhat-performance/tuned/blob/master/profiles/oracle/tuned.conf#L29

Comment 2 Sanjay Rao 2019-12-12 15:07:11 UTC
I am very sorry. We were having this discussion internally and I put the wrong requirement. 

We need auto numa balancing turned off. Oracle kernel also turns it off. We also turn it off for larger database implementations like MSSQL Server because they do their own NUMA management. 

We need to set the following.

[sysctl]
kernel.numa_balancing=0


Sorry again for the mistake.

Comment 3 Ondřej Lysoněk 2019-12-12 16:46:08 UTC
No worries.

Upstream pull request:
https://github.com/redhat-performance/tuned/pull/236

Comment 13 errata-xmlrpc 2020-11-04 02:03:07 UTC
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory (tuned bug fix and enhancement update), and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHBA-2020:4559