Oracle runs Great on Power 8 Rebecca Ballough ATS Oracle Solutions

Oracle runs Great
on Power 8
Rebecca Ballough
ATS Oracle Solutions
© 2014 IBM Corporation
Agenda
IBM/Oracle Certification
Power8 specifics
Benchmarks/Performance Data
Power8/Oracle licensing
Oracle 12C
© 2014 IBM Corporation
IBM and Oracle Have a Long-Standing Relationship
Sustaining relationship of 160K + clients
Coopetition is
alive and well
Oracle 25 years, PeopleSoft 23 years, JD
Edwards 35 years, Siebel 13 years
More than 160K joint technology clients
IBM has been
named an Oracle
Diamond level
partner, the highest
ranking available,
in the Oracle
PartnerNetwork
And more than 20,000 joint application clients
Vibrant technology relationship
Sustained investment in skills and resources
including dedicated international competency
centres
Market-leading services practice
IBM GBS is Oracle’s #1 SI partner (7,500 joint
projects) with 5,000 people dedicated to Oracle
Unrivalled client support process
Dedicated on-site resources and significant
program investments
Oracle Databases (along with most other Oracle products) are fully certified on IBM Power Systems, including
the use of PowerVM virtualisation, Micropartitioning, PowerHA and Live Partition Mobility
http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/PRS3369
© 2014 IBM Corporation
#powersystems
Enablement: Joint Process
A Collaborative Continuous Process between Oracle and IBM to ensure the
Oracle Certification of IBM SWG and STG products at its most Current
Releases with Oracle Product Releases *
– Applications Unlimited (PSFT, JDE, Siebel CRM, E-Business Suite)
– Fusion Applications
– Business Intelligence and EPM (BI Apps, OBI EE, Hyperion EPM)
– Retail GBU (Retek, 360Commerce, ProfitLogic)
– Communications GBU (Portal Software (BRM) , MetaSolv)
– Insurance GBU (AdminServer, Skywire)
– Edge Applications: G-Log OTM, Agile PLM, Demantra
– Oracle Technology (DB and RAC, Fusion Middleware, Enterprise Mgr)
Focus on Currency and Parity
IBM Cross-Brand Technology Focus (IBM STG and SWG Products):
extended technical advocates from Dev Labs
* Continuous evaluation as new companies are acquired
© 2012 IBM Corporation
Joint Development - The IBM Technology team
Developing
– On-site people dedicated to joint Oracle & IBM product development
– Oracle Technology and Application Offerings
• Generic and IBM-specific Oracle Product improvements
• New Platforms: Linux on z, Introduction of Power7, Testing with x5 and MAX5
– On-site team helps in tough debugging and critical customer situations
– Testing and certification of Operating Systems, Technology Offerings, Virtualization
Optimizing
– Technical assistance and platform-specific training to Oracle
• Compiler Exploitation (e.g. IBM XLC Compiler used on AIX)
• Advanced POWER Virtualization, z/VM
– Performance Testing and benchmarking to validate Oracle product optimization on Power and
System z
Delivering
– Document best practices, performance tuning, and other lessons learned
– Joint development and use of latest sizing tools for Techline
– Enablement (technical skills) of field force, FTSS, ATS, Business Partners
IBM Investment
80+ People dedicated full time to Oracle & IBM product development & sizing
Over >170 professionals world wide for sales & technical support
Over 1000+ IBM IT assets (Power servers, System z servers, Storage and networking) on Loan to Oracle
valued at $120,000,000
© 2012 IBM Corporation
Oracle’s Suite of Products is Certified on all IBM Systems
Power System x and
Systems BladeCenter
System z
PureFlex
Systems
Storage and
Networking
IBM
Software
And jointly supported across Operating Systems and Hypervisors
Preserving customer choice: Software, systems, virtualization technologies, and levels of support
Strong roadmaps for Oracle Database and Applications across all IBM server brands
Support for open source, industry standards, and application compatibility
Oracle Application Certifications on IBM Systems IBM Systems Positioning and Selection
Guide Oracle Database Certifications on IBM Systems
© 2012 IBM Corporation
Power Processor Technology Roadmap
POWER9
POWER8
POWER5/5+
130/90 nm
Dual Core
Enhanced Scaling
SMT
Distributed Switch +
Core Parallelism +
FP Performance +
Memory Bandwidth +
Virtualization
2004
© 2014 IBM Corporation
POWER6/6+
65/65 nm
Dual Core
High Frequencies
Virtualization +
Memory Subsystem +
Altivec
Instruction Retry
Dynamic Energy Mgmt
SMT +
Protection Keys
2007
POWER7/7+
45/32 nm
Eight Cores
On-Chip eDRAM
Power-Optimized Cores
Memory Subsystem ++
SMT++
Reliability +
VSM & VSX
Protection Keys+
2010
More Cores
SMT+++
Reliability ++
FPGA Support
Transactional Memory
PCIe Acceleration
Extreme Analytics
Optimization
Extreme Big Data
Optimization
On-chip accelerators
200+ systems in test
2014
#powersystems
POWER8 – Continued Leadership
(what you expected)
Industry
Best Practice
Industry
Leading
Industry
Leading
Industry
Leading
© 2014 International Business Machines Corporation
© 2014 IBM Corporation
#powersystems
12
POWER8 Multi-threading Options
4
SMT1: Largest unit of execution work
SMT2: Smaller unit of work, but provides
greater amount of execution work per cycle
3.5
SMT4: Smaller unit of work, but provides
greater amount of execution work per cycle
3
SMT8: Smallest unit of work, but provides the
maximum amount of execution work per cycle
Can dynamical shift between modes as
required: SMT1 / SMT2 / SMT4 / SMT8
Mixed SMT modes supported within same
LPAR
– Requires use of “Resource Groups”
2.5
2
1.5
1
0.5
0
SMT2 is available with POWER6
SMT4 is available with POWER7
© 2014 IBM Corporation
P7
P8
P8
P8
P8
SMT1 SMT1 SMT2 SMT4 SMT8
#powersystems
SMT 8 recognized with Oracle 11gR2, 12C
DB Name
TPCEDB
DB Id
255218632
5
Host
Name
Platform
p840caix71
AIX-Based
Systems (64-bit)
DB Name
TPCEDB
DB Id
2551215656
Instance
tpcedb
p840c-aix71
© 2014 IBM Corporation
1
CPUs
192
Instance
Cores
AIX-Based
Systems (64-bit)
01-May-14
19:05
Release
RAC
11.2.0.3.0
NO
Sockets
Memory (GB)
24
487.75
Startup
Time
Inst num
tpcedb
Platform
Startup
Time
Inst num
1
CPUs
21-Apr-14
23:04
Cores
192
Release
RAC
12.1.0.1.0
NO
Sockets
24
Memory (GB)
487.75
#powersystems
Some pointers …
•
Recommended AIX Release for POWER8 is 7.1 TL03 SP3+APAR
IV56367 & VIOS release 2.2.3.3
• AIX 6.1 TL9 SP3 + APAR IV56366 may also be used, but doesn’t
support SMT8
•
As always, AIX 7 on POWER8 leverages full binary compatibility with
applications built on AIX 6 and AIX 5.
.
•
Recommended tunables for Oracle on POWER7 provide excellent out of
the box performance when applied to POWER8
•
Watch out for Default Parallel Degree, which is based on logical CPU #
© 2014 IBMBusiness
Corporation
© 2014 International
Machines Corporation
#powersystems 16
Recommended vmo Parameters for Oracle on Power 8
Parameter
17
Recommend Value
AIX 7.1
Default
AIX 6.1
Default
AIX 6.1/7.1
Restricted
esid_allocator
1
1
0
Yes
vmm_klock_mode
2
2
1
No
minperm%
3
3
3
No
maxperm%
90
90
90
Yes
maxclient%
90
90
90
Yes
strict_maxclient
1
1
1
Yes
strict_maxperm
0
0
0
Yes
lru_file_repage
0
0
0
Yes
lru_poll_interval
10
10
10
Yes
minfree
960+
960
960
No
maxfree
1088+
1088
1088
No
page_steal_method
1
1
1
Yes
memory_affinity
1
1
1
Yes
v_pinshm
0
0
0
No
lgpg_regions
0
0
0
No
lgpg_size
0
0
0
No
maxpin%
80
80
80
No
© 2014 IBM Corporation
Oracle 11gR2 on Power Systems
6/6/2014
#powersystems
POWER6 / POWER7 / POWER8 Partition Mobility
AIX 7.1
AIX 7.1
AIX 6.1
AIX 6.1
AIX 7.1
AIX 7.1
AIX 7.1
AIX 7.1
AIX 6.1
AIX 6.1
AIX 6.1
AIX 6.1
AIX 5.3
AIX 5.3
AIX 5.3
IBM i 7.2
Linux
Linux
Linux
POWER6/6+
POWER7
IBM i 7.2
Linux
Linux
POWER8
Leverage POWER6 / POWER7 Compatibility Modes
LPAR Migrate between POWER6 / POWER7 / POWER8 Servers
Can not move POWER8 Mode partitions to POWER6 or POWER7 systems.
© 2014 IBM Corporation
#powersystems
Compatible Mode Architecture
POWER6 MODE
(and POWER6+ Mode)*
POWER7 MODE
(No POWER7+ Mode)
POWER8 MODE
2-Thread SMT
4-Thread SMT, IntelliThreads
8-Thread SMT
8 Protection Keys *(16 in P6+
Mode)
32 Protection Keys
User Writeable AMR
32 Protection Keys
User Writeable AMR
VMX (Vector Multimedia
Extension / AltiVec)
VSX (Vector Scalar Extension)
VSX2,
In-Core Encryption Acceleration
Affinity OFF by Default
CPU/Memory Affinity Enhancements
ON by Default, HomeNode,
3-tier Memory,
MicroPartition Affinity
HW Memory Affinity Tracking Assists,
MicroPartition Prefetch,
Concurrent LPARs per Core
64-core/128-thread Scaling
64-core / 256-thread Scaling
256-core / 1024-thread Scaling
> 1024-thread Scaling
Hybrid Threads
Transactional Memory
Active System Optimization HW
Assists
N/A
Active Memory Expansion
HW Accelerated/Assisted Active
Memory Expansion
N/A
P7+ : AME compression acceleration and
Encryption acceleration
Coherent Accelerator /
FPGA Attach
© 2014 IBM Corporation
#powersystems
IBM Power System S824 delivers New High-water
Siebel CRM Release 8.1.1.4 performance
Over 3 times the DB performance per-core than previous results
Highest overall users supported on fewer cores!
New #1
IBM Power
S824
6-core
Oracle
SPARC T4-2
16-core
Cisco
UCS B200 M3
16-core
3.3 X
IBM Power
S824
6-core
Oracle
SPARC T4-2
16-core
Cisco
UCS B200 M3
16-core
(1) All results use Siebel 8.1.1.4 PSPP Kit and are current as of 3/24/2014. For more information go to http://www.oracle.com/us/solutions/benchmark/white-papers/siebel-167484.html
© 2014 IBM Corporation
#powersystems
IBM Power System S824 delivers Best of Breed
eBS 12.1.3 Payroll performance
Over 2 times more performance per-core than Cisco result
with higher overall through-put on few cores
2X !
IBM Power
S824
12-core
(1)
© 2014 IBM Corporation
Cisco UCS
C240 M3
24-core
Oracle
BL460c
16-core
IBM Power
S824
12-core
Cisco UCS
C240 M3
24-core
Oracle
BL460c
16-core
All results use Oracle eBS 12.1.3 Payroll Batch Extra Large Kit and are current as of 3/24/2014.
For more information go to http://www.oracle.com/us/solutions/benchmark/apps-benchmark/results-166922.html
#powersystems
SAP Sales & Distribution 2-Tier ERP 6 Benchmarks
IBM Power System S824 using DB2 10.5 vs. Competition
Over 2 times better 24 core performance than nearest Intel competitive
results
Up to 2 times greater performance than previous Power generation
2X
more users
IBM Power
S824
Fujitsu
RX300 S8
Cisco UCS
C240 M3
HP ProLiant
BL460c
IBM Power
S824
IBM
p270
IBM
p260
(1.0) IBM Power System S824 on the two-tier SAP SD standard application benchmark running SAP enhancement package 5 for the SAP ERP 6.0 application; 4 processors / 24 cores / 192 threads, POWER8;
3.52GHz, 512 GB memory, 21,212 SD benchmark users, running AIX® 7.1 and DB2® 10.5, dialog response: 0.98 seconds, line items/hour: 2,317,330, dialog steps/hour: 6.952,000 SAPS: 115,870 database
response time (dialog/update): 0.011 sec / 0.019sec, CPU utilization: 99%, Certification #: 2014016 Results valid as of 3/24/14. Source: http://www.sap.com/benchmark.
(1.1) Fujitsu RX300 S8 on the two-tier SAP SD standard application benchmark running SAP enhancement package 5 for the SAP ERP 6.0 application; 2 processors / 24 cores / 48 threads. Intel Xeon E5-2697
processor 2.70 GHz, 256 GB memory, 10.240 SD benchmark users, running Windows Server 2012 SE and SQL Server 2012, Certification #: 2013024
(1.2) Cisco UCS c240 M3 on the two-tier SAP SD standard application benchmark running SAP enhancement package 5 for the SAP ERP 6.0 application; 2 processors / 24c ores / 48 threads. Intel Xeon E5-2697
processor 2.70 GHz, 256 GB memory, 10.045 SD benchmark users, running Windows Server 2012 DE and SQL Server 2012, Certification #: 2013038
(1.3) HP ProLiant BL460c Gen8 on the two-tier SAP SD standard application benchmark running SAP enhancement package 5 for the SAP ERP 6.0 application; 2 processors / 24 cores / 48 threads. Intel Xeon E52697 processor 2.70 GHz, 256 GB memory, 10.025 SD benchmark users, running Windows Server 2012 DE and SQL Server 2012, Certification #: 2013025
(2.1 IBM Flex System p270 Compute Node on the two-tier SAP SD standard application benchmark running SAP enhancement package 5 for the SAP ERP 6.0 application; 4 processors / 24 cores / 96 threads,
POWER7+; 3.4GHz, 256 GB memory, 12.528 SD benchmark users, running AIX® 7.1 and DB2® 10 .5 Certification #: 3012019 Source: http://www.sap.com/benchmark.
(1.1)IBM Flex System p260 on the two-tier SAP SD standard application benchmark running SAP enhancement package 5 for the SAP ERP 6.0 application; 2 processors / 16 cores / 64 threads, POWER7+; 4.1GHz,
256 GB memory, 10,000 SD benchmark users, running AIX® 7.1 and DB2® 10, Certification #: 2012035
© 2014 IBM Corporation
© 2014 International Business Machines Corporation
#powersystems
IBM POWER7/8 versus Intel x86 “Ivy Bridge” and E7-8870
X3-8
processor
X4-2
processor
IBM Power 7
IBM Power
S824
(3.5GHz)
Intel x86
“Ivy Bridge”
POWER8
vs “Ivy Bridge”
Intel X86
POWER8
vs E7-8870
POWER7+
vs E7-8870
POWER7+
POWER8
Xeon E5-2697
v2
Per core Ratio
Xeon E78870
Per core Ratio
Per core Ratio
16 cores
2 sockets
24 cores
2 sockets
24 cores
2 sockets
10,0003
21,212
10,2401
2.10x
23,2502
3.04x
2.15x
SPECint_rate2006 2
8843
1,750
1,020
1.70x
1,9901
2.93x
2.22x
SPECfp_rate2006 2
6024
1,370
734
1.90x
1,1902
3.84x
2.53x
13,1612
22,543
11,260
2.00x
27,1501
2.77x
2.42x
Published Industry
Standard
Benchmarks
SAP SD 2-Tier 1
SPECjEnterprise20103
80 cores
1) IBM Power System S824 on the two-tier SAP SD standard application benchmark running SAP enhancement package 5 for the SAP ERP 6.0 application; 4 processors / 24 cores / 96 threads,
POWER8; 3.52GHz, 512 GB memory, 21,212 SD benchmark users, running AIX® 7.1 and DB2® 10.5, dialog response: 0.98 seconds, line items/hour: 2,317,330, dialog steps/hour: 6.952,000 SAPS:
115,870 database response time (dialog/update): 0.011 sec / 0.019sec, CPU utilization: 99%, Certification #: * Results valid as of 3/24/14. * Certification # not available at press time. Source:
http://www.sap.com/benchmark.
(1.1) Fujitsu RX300 S8 on the two-tier SAP SD standard application benchmark running SAP enhancement package 5 for the SAP ERP 6.0 application; 2 processors / 24 cores / 48 threads. Intel Xeon E52697 processor 2.70 GHz, 256 GB memory, 10.240 SD benchmark users, running Windows Server 2012 SE and SQL Server 2012, Certification #: 2013024
(1.2) Fujitsu PRIMERGY RX900 S2 on the two-tier SAP SD standard application benchmark running SAP enhancement package 5 for the SAP ERP 6.0 application; 8 processors / 80 cores / 160 threads.
Intel Xeon Processor E7-8870 2.4GHz, 1TB memory, 23,250 SD benchmark users, running SUSE Linux Enterprise Server 11 SP2 and Sybase ASE 15.7, Certification #: 2013012
(1.3) IBM Flex System p260 on the two-tier SAP SD standard application benchmark running SAP enhancement package 5 for the SAP ERP 6.0 application; 2 processors / 16 cores / 64 threads,
POWER7+, 4.1GHZ, 256GB memory, 10,000 SD benchmark users, running AIX® 7.1 and DB2® 10, dialog response: 0.97 seconds, line items/hour: 1,094,000, dialog steps/hour: 3,282,000, Certification #:
2012035
2) IBM Power S824 results submitted to SPEC, waiting for approval. Supermicro SuperServer 6027AX-TRF (X9DAX-iF, Intel Xeon E5-2697 v2, 2.70 GHz). Source: http://www.spec.org
2.1) SPECint_rate2006 for Oracle Sun Server X2-8 (Intel Xeon E7-8870, 2.4GHz ) Source: http://www.spec.org
2.2) SPECfp_rate2006 for Fujitsu PRIMERGY RX900 S2 (Intel Xeon E7-8870, 2.40 GHz) http://www.spec.org
2.3) SPECint_rate2006 results for IBM Power 740 (Power7+, 4.22GHz) http://www.spec.org
2.4) SPECfp_rate2006 results for IBM Power 740 (Power 7+, 4.2GHz) http://www.spec.org
3)IBM WebSphere Application Server V8.5.5.2 and DB2 10.5 on IBM Power S824 result of 22,543.34 published on Apr 22, 2014. Oracle Weblogic Server Standard Edition Release 12.1.2 and Oracle
Database 12c on Oracle Sun Server X4-2 result of 11,259.88 published on Sep 23, 2013. Source:http://www.spec.org
3.1) Oracle Weblogic Server Standard Edition Release 12.1.1 on Sun Server X2-8 (E7-8870, 80cores) result of 27,150.05 published July 11, 2012. Source:http://www.spec.org
3.2) WebSphere Application Server V8.5 and DB2 10.1 on IBM Power 730 Linux (P7+, 4.2GHz) result of 12,066.73 published on Mar 6, 2013. Source:http://www.spec.org
© 2014 IBM Corporation
#powersystems
FlashSystem 840
© 2014 IBM Corporation
#powersystems
Power 8 Sockets/Chips/Cores/Threads
Each Power8 socket =
1 POWER8
dual chip
module (DCM)
(6 core example)
Remote SMP Links
Local SMP Links
Accelerators PCI Gen 3 Links
Each Power8 DCM = 6,8, 10, or 12 cores
Core Core Core
L2
MemCt
rl
Core
L2 Core
L2
L2 Core
Each Power8 Core = 8 HW SMT Threads
8 SMT Threads * 6 cores * 1 socket = 48 logical CPUs for a 6 core socket
One Power8 core = 1 core factor for licensing purposes.
http://www.oracle.com/us/corporate/contracts/processor-core-factor-table-070634.pdf
© 2014 IBM Corporation
#powersystems
Oracle Database editions available
Enterprise Edition - Flagship Oracle database version for OLTP, decision support
and content management
Standard Edition - Four- socket version, including full clustering support (RAC
support)
Standard Edition One - Two-socket version of Standard Edition (w/o RAC support)
Express Edition - Full-featured version for individual users, free of charge, no
support
Please note:
1) Not all Oracle Database versions are available with the same licensing terms in all
geographies. Please check in your particular country the currently available Oracle offerings.
2) Please consult Oracle’s Database website (http://www.oracle.com/us/products/database/index.html)
for an updated list of database editions offerings by Oracle
3) A list of costs for each edition can be found at
http://www.oracle.com/us/corporate/pricing/price-lists
© 2014 IBM Corporation
#powersystems
Oracle Core & Socket-based Database Edition Applicability*
for Power8 processor-based Systems
Oracle Database Edition
Power Systems Product Descriptions
Core pricing
Socket Pricing
Maximum Cores
(Processors)
Maximum Oracle
Socket Count
Oracle Enterprise
Edition
Oracle Standard
Edition One
Oracle Standard
Edition
Power S814
8
1
Yes
Yes
Yes
Power S822
20
2
Yes
Yes
Yes
Power S824
24
2
Yes
Yes
Yes
Power Systems
Model
For Standard Edition licensing eligibility with RAC the total number of sockets in the cluster
is considered, not just the number of sockets in an individual system.
© 2014 IBM Corporation
#powersystems
PowerVM with Oracle Licensing implications
A list of approved partitioning techologies can be found online at
http://www.oracle.com/us/corporate/pricing/specialty-topics/index.html
Approved hard partitioning technologies by Oracle include: LPAR (adds
DLPAR with AIX 5.2), Micro-Partitions (capped partitions only)
AIX LPM does not qualify for Hard Partitioning.
© 2014 IBM Corporation
#powersystems
Virtual Shared Processor Pools – Licensing Benefits
Server with 16 processor cores
POWER6/7/8 Multiple shared pools:
• Can reduce the number of
software licenses by putting a
limit on the amount of processors
an uncapped partition can use
n5
n6
n7
n8
n9
Uncapped
Uncapped
Uncapped
Uncapped
Uncapped
AIX
AIX
Oracle
Oracle
AIX
AIX
AIX
OAS
OAS
OAS
App 1
App2
QA
VP = 5
VP = 4
VP = 4
VP = 6
VP = 3
Ent. = 2.5
Ent. = 1.70
Ent. = 2.00
Ent. = 2.00
Ent. = 1.00
• Up to 64 shared pools
CUoD
n1
n2
n3
n4
VIOS
VIOS
AIX
Linux
Oracle
4
0.5
0.5
1
1
Virtual Shared pool #1
Virtual Shared pool #2
Max Cap: 5 processors
Max Cap:
Physical Shared Pool (9 processor
cores)6 processors
1
2
3
4
5
6
7
8
9
Oracle DB cores to license:
• 1 from dedicated partition n3
• 5 from shared CPU pool 1
=6
OAS cores to license:
• 6 from shared CPU pool 2
=6
© 2014 IBM Corporation
Oracle DB core – license factors:
POWER6:
1.0
POWER7/7+:
1.0
POWER8:
1.0
#powersystems
Oracle 12C brings some interesting changes…..
Multi-Tenant Container Databases (CDB)
– a new EE option ($17,500 per core)
– Allows multiple pluggable databases (PDB) per CDB
– Processes, binaries, spfile, redo, undo, rman, dataguard all at CDB level
FlexASM
– 1-1 relationship between server and ASM nodes no longer necessary
Flex Cluster
– HUB and LEAF design where HUBs run database instances and LEAF nodes run
applications
Automatic Data Optimization/Heat Map
– set compression or tiering policies at the row or segment level
– requires licensing Oracle Advanced Compression
40
© 2014 IBM Corporation
Oracle 11gR2 on Power Systems
6/6/2014
#powersystems
New in Oracle 12C – Multi-Tenant Container Database Consolidation
• A root database shell is called a “Container Database”, or CDB
• Each database within the CDB is called a “Pluggable Database”, or PDB
• Processes, binaries, character set, spfile, SGA, PGA, redo, undo are common to all
PDBs
• A limited # of parameters can be changed at the PDB level
• Security is separate; access between databases in a PDB is through dblink
• Applications connect to a listener-defined service; CDB is not visible to apps
• Management tools like rman, dataguard are at the CDB level
• Databases can be unplugged from one container and plugged into another as an
upgrade methodology
When is it implemented?
• In 12C, Databases can be created as CDB or non-CDB
• databases upgraded to 12C will use a non-CDB model by default
• Databases created CDB with only 1 PDB per CDB will not be charged extra
PDBA
PDBB
PDBC
PDBA
PDBB
PDBC
Dataguard
CDB
CDB
RMAN
41
© 2014 IBM Corporation
#powersystems
Consolidation Levels – Multi-Tenant
Multi-Tenant Container Database Consolidation
Multiple databases are consolidated as schemas under one physical database
Pros:
• Efficient resource usage – fewer processes running, shared SGA
• Fewer databases to administer, back up, patch
• No application changes needed
• No direct connection between pluggable databases (better security than schema
consolidation)
Cons:
• Separate license fee required - $17,500 per core
• Requires same character set, software versions, and mostly the same parameters to be
used by all pluggable databases
• Bugs from one pluggable database environment may impact others
• No memory resource prioritization
• All application environments must share the same maintenance window, backup and
recovery solution
• Some features such as Streams, ADO, and pre-12C databases are not compatible with
CDBs
• Application vendors may not permit use of a shared container database
• Some performance issues may be exacerbated (such as combining multiple LGWRconstrained
workloads)
42
© 2014 IBM Corporation
#powersystems
Consolidation Levels - Schema
Schema Consolidation
Multiple databases are consolidated as schemas under one physical
database
Pros:
• Efficient resource usage – fewer processes and fewer databases to
administer
Cons:
• Not supported by most application vendors
• Requires same parameters, character sets, and software versions to
be used by all schemas
• May have issues with physical object name overlap preventing
consolidation or requiring application rewrites
• No isolation of bugs - database outages caused by one application
affect all schemas
• No memory resource prioritization
• All application environments must share the same maintenance
window, backup and recovery solution
• Potential security concerns
43
© 2014 IBM Corporation
CRM
schema
HR
schema
Database
#powersystems
Consolidation Levels
Server Consolidation
Databases are isolated into separate VMs or partitions (or WPARs)
Pros:
• Provides the maximum level of resource isolation and SLA
guarantees
• Isolates and restricts Oracle licenses to the cores on which it runs
Cons:
• Still requires maintenance of each partition and database
LPAR 1
CRM DB
LPAR 2
HR DB
Server
Database Consolidation
Multiple databases are configured in a single VM, partition, or
physical server
Pros:
• Fewer OS images to maintain
• Binaries may still be separate or consolidated
Cons:
• Still requires maintenance of each database
• All databases must be able to support a common SLA
• Resource management needed
44
© 2014 IBM Corporation
CRM DB
HR DB
LPAR
#powersystems
POWER Systems Flexibility Advantage with
Oracle Database
Implement and deploy an appropriate mix of RAC and non-RAC Oracle database
instances as well as application instances
Size individual database LPARs to match
specific CPU, I/O and memory needs
Isolate critical databases in different LPARs
Scale from very small to very large LPARs
and Oracle instances
Mix test and production on the same frame
Create independent security domains
Isolate database by department or other
Mix application and database on the same
machine
Deploy varying versions of Oracle
AIX
WPARs
OS
OS
DB
DB
DB
App
OS
OS
RAC
RAC
OS
OS
RAC
RAC
OS
OS
OS
DB
DB
DB
DB
App
PowerVM Hypervisor
© 2014 IBM Corporation
PowerVM Hypervisor
= IBM Advantages
#powersystems
Server virtualization security is critical for DB workloads since many are
run in virtual environments
0
reported security breaches
on the PowerVM
hypervisor
The PowerVM hypervisor has never had a reported security
vulnerability and provides the bullet-proof security that
customers demand for mission-critical workloads
The VIOS, which is part of the overall virtualization has had 0
reported security vulnerabilities
Dare to compare – search any security tracking DB and
compare Power against x86
47
© 2014 IBM Corporation
IBM
#powersystems
Security of critical workload (SAP) deployments on Power is
beyond reproach
0
reported security breaches with
SAP and IBM DB2 or Oracle
on Power
SAP on Power versus competitive SAP
deployments study with over 54,150 clients
analyzed
The security for ERP systems, including SAP, can
be very challenging – by nature, the mixture of
application modules, user profiles, plug-in
components and so on, provide many avenues for
security breaches
Source: Business Impacts on SAP Deployments; Solitaire Interglobal Ltd (All rights
reserved); January 2013.
48
© 2014 IBM Corporation
IBM
#powersystems
Power RAS is built into the platform so clients do not have to
dedicate scarce resources to prepare for downtime
Power exhibits only
6.6 minutes of planned
downtime per year
With built-in RAS, the platform comes close to maintaining
itself
67% of corporations now require a minimum of 99.99%
uptime or better for mission critical hardware, operating
systems and main line of business (LOB) applications
AIX on Power consistently has the least amount of downtime
in ITIC studies for several years
Industry leading availability for all workloads, including SAP
Source: ITIC 2013 Global Server Hardware, Server OS Reliability Survey, ITIC, (All
rights reserved); January 2013.
49
© 2014 IBM Corporation
IBM
#powersystems
PowerVM workload management is nearly perfect when mixing
workloads
Run High And Low Priority Workloads Together
High Priority Workload
Workload Metrics
Total Throughput: 14.42M
© 2014 IBM Corporation
10.2%
throughput
reduction
High Priority Workload
Metrics
Total Throughput: 12.95M
#powersystems
Oracle VM for SPARC workload management loses 48% throughput
when mixing workloads
Run High And Low Priority Workloads Together
High Priority Workload
Workload Metrics
Total Throughput: 4.89M
© 2014 IBM Corporation
48.3%
throughput
reduction
High Priority Workload
Metrics
Total Throughput: 2.53M
#powersystems
VMware workload management loses 30% throughput when mixing
workloads
Run High And Low
High Priority Workload
Priority Workloads Together
Workload Metrics
Total Throughput: 6.48M
© 2014 IBM Corporation
30.7%
throughput
reduction
High Priority Workload
Metrics
Total Throughput: 4.48M
#powersystems
QUESTIONS
ANSWERS
54
© 2014 IBM Corporation
Oracle 11gR2 on Power Systems
6/6/2014
#powersystems