1 / 56

Martin Lambert Business Development Manager – Oracle Australia

Oracle Enterprise Manager: Empowering IT to Drive Business Value. Next Generation Database Management with Oracle 11 g. Martin Lambert Business Development Manager – Oracle Australia. Agenda. <Insert Picture Here>. The “Big 4” 11g features Real Application Testing Advanced Compression

marisa
Download Presentation

Martin Lambert Business Development Manager – Oracle Australia

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. Oracle Enterprise Manager:Empowering IT to Drive Business Value Next Generation Database Management with Oracle 11g Martin Lambert Business Development Manager – Oracle Australia

  2. Agenda <Insert Picture Here> • The “Big 4” 11g features • Real Application Testing • Advanced Compression • Active DataGuard • Total Recall • Enterprise Manager 11G and the DBA • “It’s not just about the database”

  3. Oracle Database 11g Highlights • High Availability • Logminer, Physical Standby, Streams support for XMLType, TDE • Fast Start Failover with Async Propagation • Faster Logical Standby Apply • Flashback Transaction • Data Repair Advisor • Integration • Faster Gateways • Gateways to Legacy Databases • Streams Synchronous Capture • Streams Faster Apply • Performance and Scalability • RAC Scalability Enhancements • Faster PL/SQL Triggers • Security • Tablespace and LOB Encryption • Secure By Default • Enterprise Manager support for TDE, OLS, VPD, EUS • TDE works with LOBS, log miner • Windows • VSS Writer for Point In Time Copies • Manageability and Diagnosability • Unified Automatic Memory Management • Scheduler supports remote jobs • Automatic Health Monitoring • Faster Database Upgrades • ASM • Variable extent sizes, Fast resync, Preferred reads • RAC • Highly optimized protocols • ADDM for RAC • Content Management Infrastructure • Binary XML storage • Enhanced XML indexing • Combined Text and Relational Indexes • DICOM Medical Imaging Support • Storage & Query of Semantic Content (RDF, OWL) • Business Intelligence • Next generation OLAP • Supermodels for Data Mining • Enterprise Manager is DW aware • PIVOT/UNPIVOT operators

  4. The Big 4 Features in 11g • Real Application Testing • Advanced Compression • Active Data Guard • Total Recall

  5. Analysis & Reporting Real Application Testing – Database Replay • Recreate actual production database workload in test environment • Identify, analyze and fix potential instabilities before making changes to production • Capture Workload in Production • Capture full production workload with real load & concurrency info • Move the captured workload to test system • Replay Workload in Test • Make the desired changes in test system • Replay workload with production load & concurrency • Honor commit ordering • Analyze & Report • Errors • Data divergence • Performance divergence

  6. Production ( 9.2.0.8) Test (  11.1) Clients … Replay Driver * Mid-Tier Linux … Windows Storage ASM File System Storage Transfer Replay Analysis & Reporting Capture Database Replay Workflow Pre- Process

  7. SQL Performance Analyzer Predicts impact of change on SQL response time Assess change by executing query part of SQL in isolation without concurrency Unit testing of SQL, e.g., optimizer stats/config, drop index, etc. Can use for upgrades from 9.2/10.1 10.2 or 11g 10.2 10.2 or 11g Database Replay Predicts impact of change on workload throughput Assess change by replaying workload with concurrency Comprehensive testing of DB stack, e.g, memory, RAC, concurrency related Can use for upgrades from 9.2 or 10.2 11g Real Application Testing • Real Application Testing = SPA + Database Replay • SPA + Database Replay are complementary • Together, provide comprehensive & flexible testing solution

  8. Snapshot Standby – Leverage Standby Database for Testing Physical Standby Apply Logs • Convert Physical Standby to Snapshot Standby and open for writes by testing applications • ALTER DATABASE CONVERT TO SNAPSHOT STANDBY; • Discard testing writes and catch-up to primary by applying logs • ALTER DATABASE CONVERT TO PHYSICAL STANDBY; • Preserves zero data loss • But no real time query or fast failover • No idle resources • Similar to storage snapshots, but: • Provides DR at the same time • Uses single copy of storage Open Database Back out Changes Snapshot Standby Perform Testing Continuous Redo Shipping

  9. The Big 4 New Features in 11g • Real Application Testing • Advanced Compression • Active Data Guard • Total Recall

  10. Advanced Compressionin Oracle Database 11g • Comprehensive set of data compression capabilities • Structured ( inline ), unstructured ( zlib ), rman ( zlib ), • network transport ( zlib ), datapump ( bzip2 ) • Reduces storage consumption by 2 – 3 times • Savings cascades into test, dev, QA, backup, DR environments • Enhances memory and network efficiency • Complete application transparency • Benefits diverse application workloads • Transaction Processing • Data Warehousing • Content Management Up To 3X Compression

  11. Compressed Block John=|Doe=|Jane=|Smith= 1•• 2•• 3•• 4 •  •  5•Jack• Free Space 1•John•Doe 2•Jane• Doe 3•John•Smith4• Jane • Doe Free Space OLTP Table Compression Uncompressed Block Header Header 1•John•Doe 2•Jane• Doe 3•John•Smith4• Jane • Doe 5•Jack •Smith Free Space Local Symbol Table More Data Per Block

  12. The Big 4 New Features in 11g • Real Application Testing • Advanced Compression • Active Data Guard • Total Recall

  13. Data Guard 11g Stop redo apply at 8am Open read-only for queries Active Data Guard Option Redo apply is always on Always open read only Data Guard vs Active Data Guard • By 4pm, data is 8 hours old • Queries and reports always see latest data • Any failover will be delayed due to backlog of data that must be applied • Failover is immediate when needed, standby database always up-to-date

  14. queries queries queries queries queries Active Data Guard 11g Scale-out Query Performance to Web-Scale* Active Data Guard Reader Farm Or Single Node updates Production Database StandbyDatabases DR included *

  15. The Big 4 New Features in 11g • Real Application Testing • Advanced Compression • Active Data Guard • Total Recall

  16. Managing Data History – Current Approaches • Application or mid-tier level • Combines business logic and archive policies • Increases complexity • No centralized management • Data integrity issues if underlying data is updated directly • Database level • Enabled using Triggers • Significant performance and maintenance overhead • External or Third-party • History stored in separate database • Cannot seamlessly query OLTP and history data

  17. Introducing Flashback Data Archive • Seamless access to archived historical data • Using “AS OF” SQL construct select * from product_information AS OF TIMESTAMP '02-MAY-05 12.00 AM‘ where product_id = 3060 • History is stored in automatically created history tables inside the archive • History is captured asynchronously by new background process (fbda)

  18. Agenda <Insert Picture Here> • The “Big 4” 11g features • Real Application Testing • Advanced Compression • Active DataGuard • Total Recall • Enterprise Manager 11G and the DBA • “It’s not just about the database”

  19. Top DBA Challenges Performance Management Sustain Optimal Performance Change Management Preserve Order Amid Change Ongoing Administration Manage More with Less

  20. Top DBA Challenges • Sustain Optimal Performance • Performance Diagnostics • Application Tuning Performance Management Change Management Preserve Order Amid Change Ongoing Administration Manage More with Less

  21. Automatic Performance DiagnosticsMaximize Performance With Self-Managing Database HighLoadSQL Boost Administrator Productivity Eliminate Performance Bottlenecks Lower IT Management Costs RACIssues IO / CPUIssues Deliver Higher Quality of Service Self-Diagnostic Engine Performance & Management Advisors Automatic Workload Repository Snapshots • Sustain maximum performance with self-managing database • Top-down analysis using Automatic Workload Repository snapshots • Real-time performance analysis with Automatic Database Diagnostic Monitor • Resolve performance issues faster with drill-down root-cause analysis • Classification tree based on Oracle performance tuning expertise • Performance expert; now a RAC specialist too in Oracle Database 11g

  22. Automatic Performance DiagnosticsNew in Oracle Enterprise Manager 11g CompositeApps Pre-PackagedApps • Enhanced ADDM • NEW: SQL impacting performance findings highlighted • Global AWR report for easier RAC diagnostics • Backward compatibility: Can analyze snapshots from earlier versions • Active Session History (ASH) • NEW: ASH for Standby: Facilitates performance analysis of Standby DB • Global ASH reports for RAC systems eCommerce Apps CustomApps Middleware 0110101100110 001010110110 0110101100110 001010110110 0110101100110 001010110110 0110101100110 001010110110 0110101100110 001010110110 0110101100110 001010110110 0110101100110 001010110110 0110101100110 001010110110 0110101100110 001010110110 0110101100110 001010110110 0110101100110 001010110110 0110101100110 001010110110 Application-to-Disk Database Physical & Virtual Servers Storage

  23. Performance Diagnostics NEW: Active Reports • Interactive reports for off-line analysis • Offer same level of interactivity with drill-downs for detailed analysis • Can be emailed to appropriate personnel for analysis • Does not require Oracle Enterprise Manager installation

  24. RAC Database ManageabilityNew in Oracle Enterprise Manager 11g • NEW: Monitoring and management of Clusterware • NEW: Grid Plug-and-Play support for policy-managed RAC databases • Addition and deletion of RAC nodes • ADDM shows blocking sessions across RAC instances

  25. High AvailabilityNew in Oracle Enterprise Manager 11g • Configuration-wide summary view with charts for RAC/HA setup • Provides recommendations for MAA implementation • NEW: Minimum downtime automation for single instance to MAA • Show Availability related events across the configuration • NEW:Manage role-based standby DBs, e.g. convert Physical Standby to Active Data Guard

  26. Top DBA Challenges • Sustain Optimal Performance • Performance Diagnostics • Application Tuning Performance Management Change Management Preserve Order Amid Change Ongoing Administration Manage More with Less

  27. Application TuningAutomatic SQL Tuning Well-Tuned SQL Packaged Apps +SQL Profile High-Load Customizable Apps + SQL Advice Auto SQL Tuning SQL Auto SQL Analysis Customizable Apps + Indexes & MVs + Partitions Access Analysis Applications Automatic Tuning Optimizer • Automatic SQL Tuning • Captures high-load SQL • Tunes SQL using SQL Profiles • Implements greatly improved SQL plans (optional) • Performance benefit of advice provided • SQL Profiling tunes execution plan without changing SQL text • Enables transparent tuning for packaged applications

  28. SQL Tuning Advisor New in Oracle Enterprise Manager 11g Gather Missing or Stale Statistics Create a SQL Profile Add Missing Access Structures Modify SQL Constructs Adopt AlternativeExecution Plan Create Parallel SQL Profile SQL Profiling Statistics Analysis Access Path Analysis SQL Restructure Analysis Alternative Plan Analysis Parallel Query Analysis SQL SQL SQL Tuning Advisor Automatic Tuning Optimizer ComprehensiveSQL TuningRecommendations • SQL Tuning Advisor • NEW: Identifies alternative execution plans using real-time and historical performance data • NEW: Recommends appropriate degree of parallelism to improve SQL performance Administrator

  29. Real-Time SQL MonitoringLooking Inside SQL Execution • Automatically monitors long running SQL • Enabled out-of-the-box with no performance impact • Monitors each SQL execution • Exposes monitoring statistics • Global execution level • Plan operation level • Parallel Execution level • Guides tuning efforts • NEW: Available as Active Reports inGrid Control 11.1 • NEW: Enhanced to monitor PL/SQL

  30. Top DBA Challenges Sustain Optimal Performance Performance Management • Preserve Order Amid Change • Change Detection • Change Testing • Change Automation Change Management Ongoing Administration Manage More with Less

  31. Detecting Configuration and Application Changes Reports Compare Monitoring Policies Security • Configuration Changes • Ensures system compliance with company standards • Detects unauthorized (malicious) changes • Over 300 out-of-box policies per Oracle “best practices” • Monitor compliance continuously • Application Changes • NEW: Real-time schema change detection • Schema compare capability help identify • Malicious SQL • Unauthorized access control changes • Changes to tables, procedures, triggers, functions • New/dropped indexes, etc.

  32. Top DBA Challenges Sustain Optimal Performance Performance Management • Preserve Order Amid Change • Change Detection • Change Testing • Change Automation Change Management Ongoing Administration Manage More with Less

  33. Secure Test System Deployment Oracle Data Masking Production Test • Deploy secure test system by masking sensitive data • Sensitive data never leaves the database • Extensible template library and policies for automation • Sophisticated masking: Condition-based, compound, deterministic • Integrated masking and cloning • Leverage masking templates for common data types • NEW: Command line (EMCLI) support for data masking actions

  34. Change TestingOracle Real Application Testing End-to-End Workflow Create Test System Capture Workload • SQL Performance Analyzer (SPA) • Unit testing of SQL response time • Database Replay • Concurrent load testing using Production workloads Replay Workload Deploy Replay Clients

  35. Oracle Real Application TestingSQL Performance Analyzer SQL Plans + StatsPre-Change Trial SQL Workload STS Analysis Report Compare SQL Performance SQL Plans + StatsPost-Change Trial • Test and predict impact of system changes on SQL query performance • Analyze performance changes for improvements or regression • Comprehensive performance analysis and reporting • Re-execute SQL queries in test environment • End-to-end solution: STS, SQL Plan Baselines, & SQL Tuning Advisor

  36. SPA Enhancements • Analyze performance of two workloads thru STS comparison • Allows comparing two different STS and generate SPA report • Better SPA trial accuracy through multiple test execution • SPA provides “Alternate Plans” recommendation for individual regressed SQL in a SPA trial • SPA Active Reports

  37. Oracle Real Application Testing Database Replay Production Test Clients Replay Driver • Reduce costs and risks of database changes • Fully automated workflow • Change Assurance for • Database and O/S upgrades, e.g. migration to Exadata V2 • Configuration changes, e.g., conversion from SI to RAC • Storage changes • O/S migrations, e.g., Windows to Linux • Supports upgrades from Oracle 9iR2 to 10gR2 and 11g! Storage Storage

  38. Top DBA Challenges Sustain Optimal Performance Performance Management • Preserve Order Amid Change • Change Detection • Change Testing • Change Automation Change Management Ongoing Administration Manage More with Less

  39. Testing AutomationReduce Time and Effort of Database Testing • Automate production to test workflow of Database Replay • Capture production workload, performance data • Copy workload, performance data to staging • Provision software, create test database • Deploy replay clients and orchestrate replay

  40. Deployment Automation Create Production RAC System Create Reference RAC System 4 1 2 3 Stage Gold Image Scale-Out RAC • Gold image based provisioning • Simplified RAC provisioning with automation • Single click RAC scale-out and scale-back • Provision full RAC and Clusterware systems • ASM Support

  41. Database Change AutomationSchema Changes Change Management • Schema change propagation • Capture development changes in baseline version • Preview changes before confirming • Propagate planned changes from baseline to multiple databases

  42. Software Change Automation: Patching My Oracle Support Analyze • My Oracle Support connection • Proactive advisories • CPUs • Feature based • Patch downloads • Patch Database • Patch/CPU/Patchset • Zero downtime patching for RAC • Lights-out patching for Linux • Automatic download from Oracle ULN Test Report Corporate DMZ Promote Verify Stage Patch

  43. Top DBA Challenges Performance Management Sustain Optimal Performance Change Management Preserve Order Amid Change • Manage More with Less • Space and Resource Management • AutomatedSelf-Management Ongoing Administration

  44. Space and Resource Management • Space Management • NEW: Compression Advisor (Oracle Database 11.2) • Analyzes objects to give estimate of space savings for different compressions methods • Helps in deciding correct compression level for application • Recommends various strategies for compression • Resource Manager • NEW: Instance Caging (Oracle Database 11.2) • More flexible alternative to server partitioning • Wide platform support than operating system resource managers • Lower administration overhead than virtualization • I/O Resource Management for Exadata • ASM Cluster File System support • NEW in Oracle Enterprise Manager 11g • Comprehensive administration • Proactive Monitoring • Security

  45. Top DBA Challenges Performance Management Sustain Optimal Performance Change Management Preserve Order Amid Change • Manage More with Less • Space and Resource Management • AutomatedSelf-Management Ongoing Administration

  46. High Availability Install, Upgrade, Security Resource Mgmt Fault Diagnostics Automatic Block Repair HA Console MAA Advisor Automation workflows for Grid migration Improved RAC install Easier Upgrade/Downgrade Enhanced pre-upgrade Checks Conditional Masking Compound Masking Integrated Clone and Mask Statistics Versioning On-demand Segment Creation Temp Tablespace Shrink Compression Advisor Resource Manager Instance Caging ACFS support Support Workbench Automatic Diagnostic Repository Incident Packaging Service Test Case Builder Automated Self-Management

  47. Oracle Database Manageability Empowering DBAs To Drive Business Value • Enhance Service Quality By Maximizing Application-to-Disk Performance • Improved IT Agility with Risk-free Change Management • Lower IT Costs Through Self-Managing Automation

  48. Agenda <Insert Picture Here> • The “Big 4” 11g features • Real Application Testing • Advanced Compression • Active DataGuard • Total Recall • Enterprise Manager 11G Update • “It’s not just about the database”

  49. Oracle Fusion Middleware Management Oracle Database Management Oracle Solaris & Oracle Enterprise Linux Management Oracle VM Management Oracle Sun Server Management 3rd Party Technology Management Complete and Integrated Solution Oracle Enterprise Manager Oracle Application Operations Management User Experience Management System Monitoring & Diagnostic Configuration Management Lifecycle Automation UI, Security, Integration, Data Management, My Oracle Support Integration

More Related