Managing Stability & Performance of current Oracle Db versions running AIX on Power including POWER9 04_

brynden

1559

41页

3次

2020-05-22

5墨值下载

1 © Copyright IBM Corporation, 2020

Technical Notes

IBM Oracle International Competency Center (ICC)

April 1, 2020 Email address: ibmoracle@us.ibm.com

Managing the Stability and Performance of current Oracle Database

versions running 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, 2020

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

IBM Techdocs WP102750 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

http://www-

03.ibm.com/support/techdocs/

atsmastr.nsf/WebIndex/WP10

2425

Tips, Considerations and

certification level information

Oracle Database on IBM

Power with AIX Best

Practices Presentation

https://www.ibm.com/developerw

orks/community/wikis/form/anony

mous/api/wiki/61ad9cf2-c6a3-

4d2c-b779-

61ff0266d32a/page/1cb956e8-

4160-4bea-a956-

e51490c2b920/attachment/7e0f8

148-6f15-4a40-a71b-

3f67e82930da/media/OracleOnP

owerTuningConsiderations_AIX_

VUG_v1.0_ext.pdf

Washington Systems Center–

Oracle IBM - AIX VUG call

on 09/27/2018

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

AIX Virtual Processor

Folding is Misunderstood

https://www.ibm.com/developerw

orks/community/blogs/aixpert/entr

y/aix_virtual_processor_folding_i

n_misunderstood110?lang=en

of 41

5墨值下载

关注

评论