optimizing oracle database stability and performance with ... · optimizing oracle database...

Optimizing Oracle Database Stability and Performance with the Right Hardware

Presenter Lee Diamante

ldiamante@forsythe.com

Meta7 Team Introductions

Name TitleErin Turner Associate Account Manager; eturner@forsythe.com

Lee Diamante Solution Architect; ldiamante@forsythe.comDan Morgan Oracle Ace Director; dmorgan@forsythe.com

Kevin Smith Master Consultant; ksmith@forsythe.com

Who is Meta7?

• Oracle-only division of Forsythe

• Platinum-level strategic partner

• Best-in-class design, build & implementation of Oracle infrastructure, software and cloud

• Dedicated consultants with decades of Oracle expertise

• A team of internationally recognized experts in the Oracle Red Stack

• Professional, creative and agile

Our Growing Team

Our experts are uniquely positioned with deep knowledge in Oracle products and the necessary services to turn these products into full solutions.

4 SOLUTIONARCHITECTS

15 CONSULTANTS 5 ACCOUNTMANAGERS

2 SENIORMANAGERS

Combined Years of Oracle

Expertise80 5566 210

• Design & architecture systems engineering

• Implementation & program management

• Database strategy & administration

• Operational readiness

Platform Services

• Technology refresh

• Consolidation

• Virtualization

• P2V migrations

Platform Modernization

• Clustering

• Oracle RAC design/ implementation

High Availability Services

• DB & application server installs/upgrades

• Data warehouse ETL process implementations

Implementation

• Expertise with GoldenGate, ADG, RAC, ASM

• Oracle 12c Upgrade/Features

• Oracle Cloud Services

• Database tuning

• Health checks

Database/Cloud

• Database & OS change planning & migration

• ERP OS change planning & migration

• Oracle on Oracle implementations/ competitive migrations

Migration

Meta7: Areas of Expertise

Oracle on Oracle

Applications

Middleware

Database

Operating System

Virtualization

Servers

Storage

• Oracle has been very clear about its intentions for the Oracle Sun product line

• Sun acquisition enables Oracle to deliver “Complete, Open, and Integrated Products”o From storage to application, Oracle is able to

provide all of a customer’s data center needs for Oracle platforms

o Open standards facilitate adoption and integrationo Designed from the ground up for synergy and

efficiencyo Complete, Open, and Integrated delivers better

performance, shorter deployment times, ease of management, and lower cost of ownership

• Oracle is solving Oracle problems for Oracle customers. It just so happens that everyone wins.

Oracle On Oracle

• All customers face the same three challenges:• Integration• Performance• Cost

• Customers make significant investments to optimize each layer of the stack

• Each layer is designed, built, and run separately• Fragile systems – hard to maintain• The fragile nature of these systems threatens the

stability of your Oracle environments• The lack of integration between layers inhibits your

performance• The investment at multiple levels exaggerates your

Oracle on Oracle - Stability

Applications

Middleware

Database

Operating System

Virtualization

Servers

Storage

• Stability requires investment at each layer of the stacko Reliability through redundancyo High availabilityo Consistency and Standardso Lifecycle management

– Within a layer– Across layers

• Stability within a layer is simple

• Stability across layers is a nightmareo What Works With What matrixo I know nothing is wrong with your layer but I need you to

take an outage for mine. And no, thank you, I don’t want your advice.

o Best Practices exist in a vacuum.– Best practices for storage, server, operating system,

and database are not necessarily the same

Oracle on Oracle - Stability

Engineered Together

Tested Together Certified Together

Deployed Together

Upgraded Together

Managed Together

Supported TogetherEveryone else has to stop at the Virtual Machine while Oracle integrates through the Application

PerformanceIntegrated components eliminate bottlenecks and minimize latency

CostNo more cost-effective way to deploy

Oracle applications.

IntegrationHardware and software engineered to

work together

Engineered Systems: Integration with a Purpose

ExadataDatabaseMachine

ExalogicElasticCloud

OracleDatabaseAppliance

ExalyticsIn-Memory

Machine

BigData

Appliance

SPARCSuperCluster

T5 and M6

PrivateCloud

Appliance

Zero DataLoss Recovery

Appliance

NetworkApplications

Platform

ZFS Storage Appliance

Exadata• Extreme Database Performance• Storage Indexing• Hybrid Columnar Compression

Exalogic• Extreme Performance for Fusion Middleware• Exalogic Elastic Cloud Software

Exalytics• Extreme performance for Business Intelligence• Times Ten In Memory Database

Oracle Database Appliance• Extreme Simplicity• App in a Box

Big Data Appliance• Hadoop made simple• Use SQL for map reduction

Zero Data Loss Recovery Appliance• Database backup and recovery• Database aware backups and restores

SPARC SuperCluster• Exadata, Exalogic, and General Application combined.

Oracle On Oracle – Integration

Oracle On Oracle Integration

• One Vendor from the power supply to the power user• Other vendors have broad portfolios; no one else comes close

product integration• Branding isn’t integration!• True integration of Software, Servers, and Storage

• Product developers attend each others development sessions

• Database developers plan for leveraging hardware features• Hardware developers plan to support Database needs

• Complete infrastructure with unmatched simplicity and costs:

• Oracle on Oracle does things that can’t be done on other platforms

• Servers, Storage, and Software are not only designed to work well together, they are designed to communicate, cooperate, collaborate

• Oracle software constantly shifts resource-intensive tasks to the servers and storage

• Servers and storage constantly optimize the tasks they have been assigned with and understanding of why the tasks have been assigned.

Oracle on Oracle Integration

ZFS Storage Appliance - Integration

Applications

Middleware

Database

Operating System

Virtualization

•ZFS Storage Appliance•FS1-2 Flash Array

Storage

Servers

• Unified Storage Applianceo NAS (NFS, dNFS, CIFS, iSCSI)o SAN (16Gb FC)

• Storage by a software company for a software company

• Intelligently managed JBODso Oracle Solaris serverso Intelligence moved out of the array and back to the

servero Unprecedented visibility with Analytics

• Oracle Database, Oracle Solaris, Oracle ZFS = intelligent integration

– Oracle Intelligent Storage Protocol– Hybrid Columnar Compression– Snapshots and Clones at the database level– Encryption

• Features just wake up! No tweaks necessary.• When Oracle software starts, it checks for Oracle servers and Oracle

storage and activates any applicable features• Oracle Intelligent Storage Protocol• Smart Scan processing• Storage Indexing• Hybrid Columnar Compression• Hybrid Storage Pools• Dynamic Tiering for fastest access• M7 Software in Silicon

• OISP• When Oracle Databases are connected to Oracle storage via NFS or dNFS, the database will

send hints to the storage about what to do with the data and what is coming next.

• Smart Scan processing• When Smart Scan is enabled, the database can ship functions to all Storage Servers.

Functions are processed in the storage tier so that only the results are returned to the database server.

• Storage Indexing• The storage tier not only knows where it put data, it knows what the data is and can retrieve

only the interesting bits that answer the question.

• Hybrid Columnar Compression• Database and storage work together to compress data 3x to 50x and the data does not

need to be uncompressed to use. The database stores it compressed, retrieves it compressed, and uses it in its compressed format. Only the portion which needs to be changed is uncompressed.

• Hybrid Storage Pools• Oracle storage provides shares or LUNs from hybrid pools of media: DRAM, Performance

SSD, Capacity SSD, Performance Disk, Capacity Disk

• Dynamic Tiering for fastest access• Oracle storage intelligently and dynamically shifts data in and out of the media resources with

input and guidance from the Oracle software.

• SPARC M7 Software in Silicon• The most exciting announcement yet. The enormity of this can not be overstated!• SPARC M7 will feature co-processors dedicated to Oracle Database queries and Java

processes• Wherever possible, Oracle database functions bypass the general pool of cores to run on

dedicated co-processors• Software in Silicon is yielding 10x improvement when the same workload is compared on the

T5/M6 and M7 platforms• Nothing needs to be done to leverage the feature. It is automatically enabled by the

database software when it is run on SPARC M7 processors.• No other vendor can do this. Oracle databases running on non-Oracle servers will require

several times the processing capacity to do the same amount of work.

• SQL Queries, Encryption, Compression/Decompression all take advantage of the Software in Silicon features

Oracle On Oracle - Value

Performance

• Performance without compromise• Everyone can work harder. Oracle on Oracle works harder and

smarter.• Faster Processors; More Memory• High-speed networks• Horizontal and Vertical Scalability• Eliminate unnecessary work• Share the necessary work

Oracle on Oracle Performance

All Vendors

Oracle

• META7 and Forsythe have yet to see a customer run their database on Exadata without at least a 70% improvement in performance. No tuning required.

• META7 and Forsythe customers see 5x to 10x compression of infrequently changed data using Hybrid Columnar Compression

• ~40% of your data is infrequently changed but that does not mean it is infrequently read.

• Data compressed with HCC does not need to be uncompressed. Conservatively, HCC allows database to transfer 100% of the data for 20% the effort.

• Example: In the time it takes other solutions to transfer 20GB, Oracle on Oracle solutions can transfer 100GB.

• The Hybrid Storage Pool architecture employs a combination of DRAM, flash, and disk to accelerate both read and write performance while retaining disk economics and protecting data integrity and persistency.

• Field telemetry data shows that, on average, 70 percent to 90 percent of reads are DRAM cache hits, meaning that a majority of reads are delivered directly from DRAM, which is the fastest media type.

• Flash is a thousand times faster than disk. DRAM is a thousand times faster than flash.

Other vendors are pushing all-flash arrays which makes sense if they can’t take it to the next level – DRAM.

M7 Processor Performance – compared to M6 (Current generation)14% increase in speed ; 3x performance improvement Software in Silicon

Oracle On Oracle - Value

• Cost advantageso Time

– Pre-tested, pre-packaged, pre-builto Effort

– Oracle does the work so you don’t have to– Deploy in days rather than weeks or months

o Money– One vendor, one premium– Software licensing– Reduced support costs

Oracle on Oracle Value - Time

• Pre-built system ready to use with minimal setup• Arrives pre-built and cabled

• Removes the integration risk for deploying infrastructure• Automatic provisioning of new servers, networks, and storage• Wire-once System• Oracle Virtual Networking and SDN

• Allows customers to consolidate and virtualize according to their requirements and timeline

• Private Cloud Appliance Manager• Oracle Ops Center and VM Manager• Oracle VM Templates

• Cloud Management out of the box• Oracle Enterprise Manager• Oracle Cloud Control

Private Cloud Appliance

Oracle on Oracle Value - Effort

• It’s a consistent theme:• ZDLRA uses the same tools that the database

administrators are already using• Third-party tools and software are unnecessary.• All inter-team coordination, cooperation, and confusion

can be bypassed• DBAs do not have to learn anything new to have

complete self-service and control• This is not possible with other storage solutions• ZDLRA is a self-service appliance by Database people for

Database users to do Database things with Database tools across all Database environments without compromise or delay.

With Trusted Partitions:

License only the cores used by each software component

No additional cost for virtualization, OS, management, or monitoring

On other Converged Solutions

• License the virtualization layer, monitoring, and management

• License the Operating System• License all cores on each physical server

for the Oracle software products running in the virtual machines

• On average, Oracle software license consumption on other converged solutions is 150% to 200% greater than on Oracle engineered systems

Oracle on Oracle Value - Cost

Oracle on Oracle Value - Costs

• Hardware and support were essentially equal.• Additional database licenses and support over three years meant virtualization onto a VMware

platform would be $860,000 more • Oracle support costs for Oracle VM Environment were the same as what customer would have paid if

they didn’t consolidate and virtualize.

Oracle VM Environment VMware EnvironmentNumber of Units/Nodes 8 5Number of Cores 256 80Relative Performance Estimate 495,320 176,900RAM (GB) 2,048 2,560Usable Storage (TB) 80 80CPU Architecture Intel Xeon Intel XeonProcessor Speed (GHz) 2.3 2.6Hardware/Software Purchase Price $594,525 $590,539Hardware/Software Maintenance (3 Year) $214,029 $215,991New Oracle Licensing Cost (*) N/A $545,000Oracle Support cost (3 Year) (*) $1,079,100 $1,438,800Implementation/Migration Services $205,000 $165,000

Total 3 Year Costs $2,092,654 $2,955,330

Oracle on Oracle Value - Costs

• This customer was consolidating onto Dell servers and re-using existing storage for their RAC databases and WebLogic application servers.

• Even though the Dell hardware was $400,000 less than the Oracle VM solution, three year Oracle software license and support was $1.6M more

• Overall, customer would save $1.06M with Oracle VM

Oracle VM Environment VMware EnvironmentNumber of Units/Nodes 6 6Number of Cores 216 216Relative Performance Estimate 371,490 371,490RAM (GB) 1,536 1,536Usable Storage (TB) 80 80CPU Architecture Intel Xeon Intel XeonProcessor Speed (GHz) 2.3 2.3Hardware/Software Purchase Price $420,000 $152,000Hardware/Software Maintenance (3 Year) $151,000 $0New Oracle Licensing Cost (*) N/A $277,500Oracle Support cost (3 Year) (*) $2,088,900 $3,442,500Implementation/Migration Services $150,000 $0

Total 3 Year Costs $2,809,900 $3,872,000

Oracle on Oracle Value - Cost

$200,000

$400,000

$600,000

$800,000

$1,000,000

$1,200,000

$1,400,000

$1,600,000

$1,800,000

256 TB 512 TB 768 TB 1,024TB

1,280TB

1,536TB

1,792TB

2,048TB

2,304TB

2,560TB

2,816TB

3,072TB

ZS3-2 Cost/GB

ZS4-4 Cost/GB

• Costs for ZS3-2 and ZS4-4 Configurations include clustered controllers, flash cache, and all software features – including all licensed options.

• Encryption only available on ZS4-4. Encryption included in ZS4-4 configurations• USEABLE capacity listed after mirroring.• Costs scale linearly – Licenses are per controller..

• No additional license or feature cost as storage scales• No metered licensing. One cost covers unlimited replication, cloning, snapshots, or encryption.

$0.51/GB

$0.66/GB

$0.48/GB

Oracle On Oracle - Summary

Summary