1 / 30

TRANSFORMING YOUR

TRANSFORMING YOUR. ORACLE. ENVIRONMENTS. MAINTAINING. ORACLE ENVIRONMENTS. SAY TIME SPENT ON ONGOING DATABASE MANAGEMENT INHIBITING COMPETITIVENESS. Which Areas Would You Like To Invest More?. 39 %. 39 %. 36 %. 34 %. Migrating Or Upgrading Databases. Database Consolidation.

felix
Download Presentation

TRANSFORMING YOUR

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. TRANSFORMING YOUR ORACLE ENVIRONMENTS

  2. MAINTAINING ORACLE ENVIRONMENTS SAY TIME SPENT ON ONGOING DATABASE MANAGEMENT INHIBITING COMPETITIVENESS Which Areas WouldYou Like To Invest More? 39% 39% 36% 34% Migrating Or Upgrading Databases Database Consolidation Upgrade Hardware & Processors Research New Oracle Features SAY TIME AND COST OF ONGOING DATABASEMANAGEMENT PREVENTING FUNDING OF INNOVATION Source: 2014 IOUG IT Resource Strategies Survey

  3. RUNNING MIXEDENVIRONMENTS Oracle11g Oracle12c SQL Server SharePoint Exchange SAP MULTIPLE SILOS OF DATABASES & APPLICATIONS MULTIPLE VERSIONS OF DATABASES & APPLICATIONS COMPETING IT OPERATIONAL NEEDS (Performance, Backup, Data Availability & Protection)

  4. EMC VIRTUAL INFRASTRUCTURE Oracle11g Oracle12c SQL Server SharePoint Exchange SAP VIRTUALIZATION SERVER NETWORK MANAGEMENT AUTOMATION STORAGE GREATER EFFICIENCY & CONTROL WITH LOWER TCO

  5. CUSTOMERS ARE SEEING THE BENEFITS 100% VIRTUALIZED ORACLE & MICROSOFT Reduced Hardware Costs by 80% 99% VIRTUALIZED ORACLE & MYSQL Reduced Hardware Costs by 90% 90% VIRTUALIZED ORACLE & MICROSOFT Reduced Hardware Costs by 92% 90% VIRTUALIZED ORACLE & MICROSOFT Enabled 2x Growth with Same IT Staff

  6. EMC: THE #1 CHOICE FOR ORACLE EMC Global IT Virtualizes Over 90% Of Oracle, Microsoft & SAP Systems 18+ YearAlliance With Joint Technology & Support Centers EMC & Oracle Announce New 12c Integrations at OOW 2013 More Oracle Deployed On EMC Than Any Vendor (IDC)

  7. REDUCING TIME & COST RUNNING ORACLE OPTIMIZE ORACLE INFRASTRUCTURE MAXIMIZE DBA PRODUCTIVITY Reduce Oracle TCO By 26-38% And Maximize Quality Of Service & Agility For IT Give DBAs 30-50% More Time To Focus On Value-Add Activities

  8. OPTIMIZE ORACLE INFRASTRUCTURE MAXIMIZE DBA PRODUCTIVITY NEXT STEPS OPTIMIZE ORACLE INFRASTRUCTURE ORACLE PERFORMANCE Optimize For OLTP, DW & Mixed Workloads AGILITY Deploy New IT Services Faster Without Disruption TCO Multi-Year Hardware, Software & Maintenance SERVER NETWORK STORAGE

  9. OPTIMIZE ORACLE INFRASTRUCTURE MAXIMIZE DBA PRODUCTIVITY NEXT STEPS PERFORMANCE WHERE IT’S NEEDED THE MOST EMC XtremCache 23686 SERVER FLASH: Dramatically Reduces Response Times & Boosts Performance 10xLess Latency Array Workload (IOPS) Response Times (MS) 35MS 5266 3MS Baseline XtremCache TIERED STORAGE: Optimizes Performance For OLTP, DW & Mixed Workloads 30830 3xMOREIOPS 304K Tier 1 Tier 1 519K 220K Array Workload (IOPS) TPM EMC FASTVP Tier 2 Tier 2 13894 8558 Tier 3 Tier 3 Baseline FAST VP FAST Cache+ FAST VP

  10. OPTIMIZE ORACLE INFRASTRUCTURE MAXIMIZE DBA PRODUCTIVITY NEXT STEPS OPTIMIZE ORACLE INFRASTRUCTURE ORACLE PERFORMANCE Optimize For OLTP, DW & Mixed Workloads AGILITY Deploy New IT Services Faster Without Disruption TCO Multi-Year Hardware, Software & Maintenance SERVER NETWORK STORAGE

  11. OPTIMIZE ORACLE INFRASTRUCTURE MAXIMIZE DBA PRODUCTIVITY NEXT STEPS IMPROVING IT AGILITY FOR CUSTOMERS NEW APPLICATIONS IN WEEKS Versus Months for Oracle RAC Databases NEW APPLICATIONS IN 2-3 DAYS Versus Months for Oracle & Microsoft NEW ORACLE SERVERS IN 30 MINUTESVersus Months for Oracle & Microsoft NEW ORACLE SERVERS IN 1 HOUR Versus Weeks for Oracle & Microsoft

  12. OPTIMIZE ORACLE INFRASTRUCTURE MAXIMIZE DBA PRODUCTIVITY NEXT STEPS VMWARE & ORACLE: KEY POINTS ORACLE SUPPORTS USE OF VMWARE PERFORMANCE NO LONGER AN ISSUE Average Oracle database fits easily in a VM Support Position For Oracle Products Running on VMware Virtualized Environments [ID 249212.1] 320 vCPU 1TB 1,00,000TB 400GB/S Oracle Support will assist customers running Oracle products on VMware in the following manner: Oracle will only provide support for issues that either are known to occur on the native OS, or can be demonstrated not to be as a result of running on VMware. If a problem is a known Oracle issue, Oracle support will recommend the appropriate solution on the native OS. For Oracle RAC, Oracle will only accept Service Requests as described in this note on Oracle RAC 11.2.0.2 and later. 2-4 CPU 4% Utilized 4-5 GB 50% Utilized 1,200 IOPS 2MB/S MEMORY CPU DISK IO NETWORK IO vSphere Oracle Support statement on Oracle.com and Vmware.com

  13. OPTIMIZE ORACLE INFRASTRUCTURE MAXIMIZE DBA PRODUCTIVITY NEXT STEPS VMWARE OPTIMIZES ORACLE LICENSES Run the same amount of Oracle on fewer CPU cores 2 Servers 2 Quad-Core Processors x 0.5 Intel Multiplier 8 Licences 8 RISC Servers 2 Single-Core Processors 16 Licences NEW CORES OUT PERFORM OLDER CPUS ENVIRONMENT NOW HAS FALLOVER ORACLE LICENSING COST REDUCED 50% PHYSICAL VIRTUAL

  14. OPTIMIZE ORACLE INFRASTRUCTURE MAXIMIZE DBA PRODUCTIVITY NEXT STEPS VIRTUALIZATION OF ORACLE & FLASH WITH FAST VP REDUCES ORACLE TCO AND REDUCES ORACLEDATABASE LICENSE SPEND $5.3M 26% $3.9M LOWER TCOHardware, Software & Maintenance 3 Year HW/SW/Maintenance Physical Servers No FlashStandard Memory Vmware20% Flash & FAST VPOptimized Memory Source: Wikibon, April 2013, Virtualization of Oracle Evolves to Best Practice for Production Systems

  15. OPTIMIZE ORACLE INFRASTRUCTURE MAXIMIZE DBA PRODUCTIVITY NEXT STEPS OPTIMIZE ORACLE INFRASTRUCTURE ORACLE PERFORMANCE Optimize For OLTP, DW &Mixed Workloads AGILITY Deploy New IT Services Faster Without Disruption TCO Multi-Year Hardware, Software & Maintenance SERVER NETWORK STORAGE

  16. OPTIMIZE ORACLE INFRASTRUCTURE MAXIMIZE DBA PRODUCTIVITY NEXT STEPS IT STANDARDIZATION ON THE RISE What Strategies Are You Employing To Reduce Time & Money Spent On Ongoing Database Management? STANDARDIZING OF IT INFRASTRUCTURE 53% INCREASING DATABASE OR DATA CENTER AUTOMATION 46% VIRTUALIZATION 43% 42% DATABASE OR DATA CENTER CONSOLIDATION

  17. OPTIMIZE ORACLE INFRASTRUCTURE MAXIMIZE DBA PRODUCTIVITY NEXT STEPS VBLOCK: STANDARDIZATION FOR MIXED ENVIRONMENTS Exchange • SharePoint • Oracle 11g • Oracle 12c • SQL Server • SAP MIXED DATABASE & APPLICATION ENVIRONMENTS 96% 50% 5x 4x FASTER DEPLOYMENT LESS ITCOSTS FASTER DEPLOYMENT MORE EFFICIENT IT RESOURCES Source: IDC White Paper, September 2013, Convergence With Vblock Systems, A Value Measurement

  18. OPTIMIZE ORACLE INFRASTRUCTURE MAXIMIZE DBA PRODUCTIVITY NEXT STEPS VBLOCK™ SPECIALIZED SYSTEMS FOR HIGHPERFORMANCE DATABASES Oracle OLTP • Oracle Data Warehousing • Oracle Test & Development #1 CONSOLIDATED INFRASTRUCUTRE FOR ORACLE #1 OLTP PERFORMANCE 3.7M SUSTAINED READ IOPS CONSOLIDATE ORACLE WORKLOADS #1 DW PERFORMANCE 21TB/H LOADS, 32GB/S SCANS VIRTUAL & PHYSICAL ON THE SAME INFRASTRUCTURE Source: EMC Proven Solution Testing Results

  19. OPTIMIZE ORACLE INFRASTRUCTURE MAXIMIZE DBA PRODUCTIVITY NEXT STEPS 77% MONITOR AVAILABILITY 75% DBA RESPONSIBILITIESINCREASING DIAGNOSE PERFORMANCE ISSUES 71% MANAGE BACKUP & RECOVERY 61% CAPACITY PLANNING 60% MANAGE DATA STORAGE & RETRIEVAL 59% PATCH SYSTEMS Source: 2013 IOUG Data Science Skills Survey

  20. OPTIMIZE ORACLE INFRASTRUCTURE MAXIMIZE DBA PRODUCTIVITY NEXT STEPS DATABASE MANAGEMENTGAP NEED: HAVE: Proactive Performance & Capacity Planning Detailed Storage Expertise Fast & Complete Backup & Recovery Advanced Backup & Recovery Solutions Optimized Availability & Data Protection Highest RPO/RTO Data Protection Solutions Source: 2013 IOUG Data Science Skills Survey

  21. OPTIMIZE ORACLE INFRASTRUCTURE MAXIMIZE DBA PRODUCTIVITY NEXT STEPS DATABASE MANAGEMENTCLOSING THE GAP Direct DBA Access To Key Storage Configuration Data & Alerts Choice Of Full Or Partial DBA Control Of Backup & Recovery Continuous Data Protection & Active-Active Availability For DBAs Source: 2013 IOUG Data Science Skills Survey

  22. OPTIMIZE ORACLE INFRASTRUCTURE MAXIMIZE DBA PRODUCTIVITY NEXT STEPS ORACLE MONITORING & TUNING TODAY DBA SEES ISSUE DBA ENGAGES STORAGE ADMIN DBA ADJUSTS DATABASE STORAGE ADMIN RESPONDS TO DBA STORAGE ADMIN DOES ANALYSIS

  23. OPTIMIZE ORACLE INFRASTRUCTURE MAXIMIZE DBA PRODUCTIVITY NEXT STEPS INTEGRATION WITH ORACLE ENTERPRISE MANAGER STORAGE VISIBILITY: CONFIGURATION | PERFORMANCE | AVAILABILITY DATA ORACLE ENTERPRISE MANAGER PLUG-IN Free & downloadable from Oracle extensibility exchange: www.oracle.com/goto/emextensibility

  24. REAL-TIME & HISTORICAL PERFORMANCEANALYSIS ON EMC VMAX & VNX CAPACITY UTILIZATION ANALYSIS ON EMC VMAX & VNX SINGLE DASHBOARD FOR DBAS

  25. OPTIMIZE ORACLE INFRASTRUCTURE MAXIMIZE DBA PRODUCTIVITY NEXT STEPS TRADITIONALORACLEBACKUP LONG BACKUP & RESTORE TIMES: WITH DOWNTIME IN MOST CASES IT INEFFICIENCY: BACKUP TO DISK AND THEN TO TAPE EXCESS COST: DISK & TAPE COSTS GROW AS ORACLE DATABASES SCALE

  26. OPTIMIZE ORACLE INFRASTRUCTURE MAXIMIZE DBA PRODUCTIVITY NEXT STEPS SIMPLIFIEDORACLE BACKUP & RECOVERY FASTERORACLE BACKUPS 50% LESSSTORAGE 10-30x DIRECT BACKUP TO DATA DOMAIN DBA CONTROL BACKUP, RECOVERY & REPLICATION ACCELERATE BACKUP & RECOVERY DD BOOST FOR ORACLE RECOVERY MANAGER (RMAN) DATA INTEGRITY DATA DOMAIN DATA INVULNERABILITY ARCHITECTURE

  27. OPTIMIZE ORACLE INFRASTRUCTURE MAXIMIZE DBA PRODUCTIVITY NEXT STEPS ORACLE AVAILABILITY CHALLENGES TODAY MANUAL & REACTIVE LIMITED USE OF STANDBY RESOURCES ORACLE PROTECTS ONLY ORACLE ACTIVE STANDBY/READ ONLY

  28. OPTIMIZE ORACLE INFRASTRUCTURE MAXIMIZE DBA PRODUCTIVITY NEXT STEPS ORACLE CONTINUOUS AVAILABILITY AUTOMATED & PROACTIVE LOGICAL & PHYSICAL PROTECTION BASED ON DBA POLICIES ACTIVE-ACTIVE ORACLE RAC STRETCHED OVER DISTANCE SINGLE SOLUTION FOR ALL DATABASES AND APPLICATIONS VPLEX RECOVERPOINT

  29. OPTIMIZE ORACLE INFRASTRUCTURE MAXIMIZE DBA PRODUCTIVITY NEXT STEPS EMC MAXIMIZES ORACLE DBA PRODUCTIVITY ≈30-50% STORAGE VISIBILITYORACLE ENTERPRISE MANAGER PLUG-IN MORE TIMEFOR VALUE-ADDACTIVITIES BACKUP & RECOVERYDD BOOST FOR RMAN CONTINUOUS AVAILABILITYORACLE ENTERPRISE MANAGER PLUG-IN

  30. OPTIMIZE ORACLE INFRASTRUCTURE MAXIMIZE DBA PRODUCTIVITY NEXT STEPS WHAT ARE YOUR AREAS OF INTEREST? OPTIMIZE ORACLE INFRASTRUCTURE MAXIMIZE DBA PRODUCTIVITY Oracle Performance Optimization Oracle & Virtualization Oracle & Converged Infrastructure Oracle Monitoring & Tuning Oracle Backup & Recovery Oracle Continuous Availability EMAIL

More Related