Managing the Stability and Performance of current Oracle Database versions running AIX on Power Systems including POWER9
免费下载
1 © Copyright IBM Corporation, 2021
Technical Notes
IBM Oracle International Competency Center (ICC)
June 2, 2021 Email address: ibmoracle@us.ibm.com
Oracle 19c to 12c and 11.2.0.4 Database Performance
Considerations with AIX on Power Systems including POWER9
Introduction
This document is intended to provide information, suggestions and website links to assist with
IBM Power Systems running the Oracle database. Suggestions for both the standalone database
and Real Application Clusters (RAC) environments for Oracle 19c, 18c, 12c and 11.2.0.4
(terminal release) are included. POWER9 with improved SMT4 and SMT8 performance has
been optimized for stronger thread performance and increased execution bandwidth efficiency.
Issues on IBM Power Systems using AIX 7.1 and AIX 7.2 with the Oracle database can be
minimized by following standard practices which apply to current IBM Power Systems
generations.
Please note that Oracle has changed the database naming convention starting with Oracle 12.2.
Oracle database 18c (year 2018) is the full release of 12.2.0.2. The recommended database
product to target would be 19c as it offers a greater duration of support by Oracle to March
2026 (see database release schedule).
The Oracle MOS link provides additional detail on understanding the new Oracle version
numbers and the Oracle Database Release Schedule (Doc ID 742060.1):
Oracle version detail: https://docs.oracle.com/en/database/oracle/oracle-
database/18/upgrd/oracle-database-release-numbers.html#GUID-1E2F3945-C0EE-4EB2-
A933-8D1862D8ECE2
Oracle database release schedule:
https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-
state=1d9en3wyah_9&_afrLoop=477182903158893
2 © Copyright IBM Corporation, 2021
Table 1, Helpful reference links
Oracle and IBM Reference Information
Oracle Database 11g and 12c
on IBM Power Systems S924,
S922 and S914 with POWER9
processors
https://www.ibm.com/support/
pages/node/6355685
POWER9 tips and
considerations on Techdocs
Current Oracle Database
Release Schedule
For releases of Oracle for AIX,
please refer to MOS note:
Release Schedule of Current
Database Releases (Doc ID
742060.1)
Oracle MOS document
Oracle 12c DB & RAC -
IBM AIX: Tips and
Considerations
https://www.ibm.com/support/
pages/node/6355451
Tips, Considerations and
certification level information
Oracle Database on IBM
Power with AIX Best
Practices Presentation -
Power Systems Virtual User
Group
https://ibm.ent.box.com/v/PSV
UG-OracleBestPracticesPart1
https://ibm.ent.box.com/v/PSV
UG-OracleBestPractPart2
IBM Advanced Technology
Group, ISV on Power - Oracle
- AIX VUG call on 08/20/20
and 08/27/20.
Oracle Best Practices Part 1
(CPU & Memory)
Oracle Best Practices Part 2
(I/O & Miscellaneous)
Advanced Technology Group
(ATG), ISV on Power -
Oracle
https://w3.ibm.com/w3publisher/
advanced-technical-group-
oracle/collateral
Internal site - formerly
Washington Systems Center
Oracle IBM
Oracle Real Application
Clusters on IBM AIX – Best
practices in memory tuning
and configuring for system
stability
http://www.oracle.com/technet
work/database/clusterware/ove
rview/rac-aix-system-stability-
131022.pdf
RAC tuning and configuration
Guide
Oracle Real Application
Clusters (RAC) and Oracle
Clusterware Interconnect
Virtual Local Area Networks
(VLANs) Deployment
Considerations
http://www.oracle.com/technet
work/database/clusterware/ove
rview/interconnect-vlan-
06072012-1657506.pdf
RAC and VLAN deployment
guide
Managing Raw Disks in AIX
to use with Oracle Automatic
Storage Management (ASM)
(MOS) Doc ID 1445870.1 My Oracle Support (MOS)
https://support.oracle.com
(Registration required)
AIX Disk Queue Depth
Tuning for Performance Ver
1.2
http://www-
01.ibm.com/support/docview.
wss?uid=tss1td105745&aid=1
IO queuing for disk device
driver and adapter device
driver
of 43
免费下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
文档被以下合辑收录
评论