Loading in 2 Seconds...
Loading in 2 Seconds...
Oracle Database 11g and Sun Benefits Tom Mettling Sales Consulting Manager New England/Upstate NY. Oracle Database Innovation.
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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Oracle Database 11g and Sun Benefits Tom Mettling Sales Consulting Manager New England/Upstate NY
Oracle Database Innovation Audit Vault Database Vault Grid Computing Self Managing Database XML Database Oracle Data Guard Real Application Clusters Flashback Query Virtual Private DatabaseBuilt in Java VM Partitioning Support Built in Messaging Object Relational Support Multimedia SupportData Warehousing Optimizations Parallel Operations Distributed SQL & Transaction Support Cluster and MPP Support Multi-version Read Consistency Client/Server Support Platform Portability Commercial SQL Implementation 1977 2007 30 years of sustained innovation … … continuing with Oracle Database 11g
Scalable Execution Scale-up on Large SMPs Scale-out on Clusters Parallel Everything Query, DML, DDL, Loads, Unloads, Recovery Non-escalating Row Locks Read Consistency Scalable Storage Table Partitioning Automatic Storage Management Bigfile Tablespaces Transportable Tablespaces Nine Index Types Scalable Availability RAC Flashback Data Guard RMAN Online Table Redefinition Read-only Tablespaces Scalable Management Grid Control Automatic Tuning of Highly Complex Applications Database Resource Manager Automatic Workload Repository Oracle is Ready to Scale Today- 25 Years of Investment
Enabling Innovation with Oracle Database 11g • Better business insight into all data types • Managing data growth • Higher quality of service at lower cost • Pressure to manage change
New in Oracle Database 11g… Fast Mirror Resync More command line mgmt New in Oracle Database 11g… ADDM for RAC Performance Improvements Grid ComputingStandardize, Consolidate, Automate. FusionMiddleware Real Application Clusters Automatic Storage Management Grid Control
The Dark Underbelly of DB Workloads: Data Stalls • Data stalls dominate execution time • 46%-64% of execution time wasted on data stalls • True for both OLTP and DSS database workloads • Even more execution time wasted on instruction stalls • Especially for OLTP, where you waste a further 10%-15% • This problem applies to typical multi-core chips • Designed with sophisticated out-of-order cores and aggressive speculation • E.g. IBM Power, Intel Core Duo Source: “Database Servers on Chip Multiprocessors: Limitations and Opportunities” September 2006, Carnegie Mellon University
Everything Changes with Sun's CoolThreads CMT Systems • Data stalls drop to 13% • 76%-80% of execution time spent on useful computation • True for both OLTP and DSS database workloads • Instruction stalls are negligible • END RESULT: 70% higher throughput than traditional systems • BUT: not good for unsaturated workloads • Single-threaded workloads perform 41% worse • So CMT is a win, provided you keep the CPUs busy Source: “Database Servers on Chip Multiprocessors: Limitations and Opportunities” September 2006, Carnegie Mellon University
Oracle on Sun M-Series • Dynamic Reconfiguration • Add or remove system boards without Oracle instance downtime • Leverages Oracle Dynamic SGA and Solaris DISM • 5th generation feature on SPARC Enterprise Servers • Mixed processor support • Sun M-series supports mixed speed and mixed generation CPUs • Allows customers to implement rolling CPU upgrades without impacting Oracle instance uptime • Delivers greater ROI because customers not required to upgrade all CPUs
Oracle on SPARC Servers – Summary • Sun's CMT Server Advantages • Low power consumption • Maximum rack computational density • Logical Domains (LDoms) powerful and bundled • Sun's M-Series Server Advantages • Outstanding scalability • Enterprise-class RAS features • Flexible domaining • Solaris Containers run on both CMT and M-Series • Secure virtual OS instances, negligible perf overhead • Recognized by Oracle for licensing purposes
SecureFiles Any Type of DataEasy Integration of all you data New in Oracle Database 11g RFID DICOM 3D Binary XML Images
Offline Archive Storage Tier High Performance Storage Tier Low Cost Storage Tier Online Archive Storage Tier Information Lifecycle ManagementOptimize storage cost and performance Less Active Active Historical Archive
Advanced Compressionfor all applications • Compress Large Application Tables • Transaction processing, data warehousing • Compress All Data Types • Structured and unstructured data types • Typical Compression of 2-3 X • Cascade storage savings throughout data center Up To 3X Compression
Oracle on Sun Storage • Sun Storage F5100 Flash Array • Unprecedented performance and scalability • Up to 1.92TB capacity • 1.6m read IOPS, 1.2m write IOPS, 12GB/s throughput • Sun Flash Accelerator F20 PCIe Card • Low profile PCIe form factor • 96GB capacity • 100k read IOPS, 87k write IOPS, 1.1GB/s throughput • Windows, Solaris, OpenSolaris, Linux
Oracle Database 11gR2 Flash Cache • New SGA feature in 11gR2 on Solaris • Expands DB buffer cache beyond main memory to flash • ASM, file system file, raw device,... • Best with read-mostly and read-only workloads • Ideal with Sun Storage F5100 Flash Array, Sun Flash Accelerator F20 PCIe Card
Faster PerformanceOracle Database 11g Speed-Up Client SideCaching Database ResidentConnection Pool Java Just-In-TimeCompiler Query ResultCaching Up to22% Faster Up to 20 x connections Up to11 x Faster Up to25% Faster Optimizer StatsCollection Oracle SecureBackup Oracle StreamsEnhancements RAC PerformanceEnhancements Up to 10 x Faster Up to25% Faster Up to 2 x Faster Up to70% Faster
Unlocking the Value of Standby DBs Logical Standbyfor RealtimeQuery Standbyfor OnlineUpgrade,Auto Failover Standbyfor Testing,ReadablePhysical Standbyfor DRand Backup
Total RecallFlashback Data Archive • Flashback Data Archive • Easy, practical way to add “time dimension” to your data • For change tracking, ILM, auditing, compliance, … • Query data “AS OF” any time in the past • Efficient storage / retrieval of undo data Select * from ordersAS OF‘Midnight 31-Dec-2003’ ORDERS Archive Tables Changes User Tablespaces Flashback Data Archive
Database Vault Audit Vault Label Security Advanced Security Secure Backup ConfigurationMgmt Pack SecureDeployments Monitor, Alert, Consolidate Multi-factor DBA Controls Data Classification Encrypted Data Encrypted Data on Tape Database Security and Compliance
Advanced Security Strongly Authenticate and Authorize End Users Database Vault Add Multi-factor DBA Controls Transparent Data Encryption Encrypt data in the database Audit Vault Consolidate and Monitor Audit Information Oracle Secure Backup Encrypt Backups Security and ComplianceStrong, Complete, Integrated
Lifecycle of Change Management New Change Assurance Capabilities Detect and TunePerformance Changes Capture andReplay Workload Provision - Upgrade or Clone Set Up TestEnvironments Configure and Maintain Production System Package Incidentsfor Support Online ‘Hot’ Patching
Client Client Client … Real Application Testing Database Replay • Recreate actual production database workload in test environment • No test development required • Replay workload in test with production timing • Analyze & fix issues before production Test Production Replay DB Workload MiddleTier Capture DB Workload … … Test migration to RAC Storage
Application Service Levels Enterprise Manager Grid Control • Service Level Management • Set business service goals • Transactionperformance • Business processes • Report service levels • Diagnose root cause • Respond to change Low Cost, Multi-System Management Grid Platform • Grid Management • Capture configuration • Know what you have • Know what you are running • Drive to certified configs • Manage sets as one • Automate tasks Extended through to Oracle Support
Deep Observability Large amount of native Solaris tools to provide observability. DTrace provides deeper observability to Solaris and your application. No other OS can do what DTrace does. DTrace is a dynamic tracing framework that lets users turn on and off thousands of probe points inside the kernel and user applications DTrace's observability and interactive use greatly speeds the essentially iterative work of debugging and performance improvement. Application-specific probe points may be created by customers and seamlessly fit into the DTrace framework. DTrace's design makes these powerful features safe to use, even on the most critical production systems as well as development/QA. Solaris includes many GNU tools for SAs supporting both Solaris and RHEL.
Performance and Scalability Query Result Cache TimesTen Cache Enhancements RAC Scalability Enhancements High Availability Data Recovery Advisor Readable Physical Standby VLDB/ILM Interval and Referential Partitioning Enhanced Compression Manageability and Diagnosability Support Workbench SQL Performance Analyzer SQL Test Case Builder Security Tablespace and LOB Encryption Secure Configuration Business Intelligence BI Publisher Reporting Supermodels for Data Mining Unstructured Data Management Enhanced XML indexing Storage & Query of Semantic Content Developer Productivity APEX 3.0 including support for Flash Charting and PDF output Improved PHP Scalability .NET Improvements Simple compilation of PLSQL and Java Stored Procedures Other Oracle Database 11g Highlights
Excellent Performance & Scalability Solaris Scales linearly on SPARC or x86. Solaris has been proved to scale to: 512 hardware threads 4 Terabytes of RAM Many Petabytes of disk Achieve excellent network performance (throughput and latency). Performance: The overall #1 record for the 8-processor SAP SD benchmark was on Solaris and the Sun Fire X4640. The overall #1 record for the 2-processor SAP SD benchmark was on Solaris and the Sun Fire x4270. http://blogs.sun.com/BestPerf/entry/sun_solaris_leadership_in_sap
Solaris and SPARC: #1 platform Solaris and SPARC are world record holders in all seven key enterprise commercial benchmarks. #1 in OLTP Database: TPC-C #1 in Oracle BI EE: T5440 cluster #1 in Oracle Hyperion: M5000+7410 #1 in ERP: SAP-SD on M9000 #1 in PeopleSoft Payroll: M4000+F5100 #1 in Web/Network: SPECweb T5440 Sun Websvr M9000 M4000 Sun Storage F5100 Array M5000 T5440 Sun Unified Storage 7410
THANK YOU. 28