WIXLIB

Managing Oracle ExadataExadata'ss Lifecycle for Extreme PerformanceDeba Chatterjee : Principal Product Manager, OracleHari Srinivasan: Principal Product Manager , Oracle1Copyright 2011, Oracle and/or its affiliates. All rightsreserved.

Management ChallengesChallenges Reduce deployment cost and errors—rapid time to valueMigrate application while ensuring business continuityProactively monitor all componentsMaximize availabilityEnsure quality of serviceOracle Enterprise Manager Release 12.1 Manages all stages of Exadata lifecycle from deployment to maintenanceAutomates deployment reducing cost and effortMitigates migration riskMaximizes pperformance, availabilityy and service qqualityyCopyright 2011, Oracle and/or its affiliates. All rightsreserved.

Exadata ManagementSetup & Monitor Discovering Exadata for monitoring Monitoring the Database machineTest Consolidate on Exadata Validate Application PerformanceManage PerformanceP fDiagnosticsDiti Application SQL TuningMaintain Configuration Compliance Patch AutomationCopyright 2011, Oracle and/or its affiliates. All rightsreserved.

Discovering Exadata in Enterprise Manager 12.1Install Agenton ComputeNodeLaunch tialsMonitoringPropertiesReview Wizard driven guided discovery now significantly faster (10x) than 11g Exadata Cell and the Infiniband components discovered out-of-the box Exadata Plug-in bundled for all other targets (viz. KVM, PDU, Cisco Switch) Optionpto Discover New DB Machine or rediscover – Add DB Machine MembersCopyright 2011, Oracle and/or its affiliates. All rightsreserved.

Exadata Discovery Pre-Requisites CheckExadata discovery related checks documented in 1473912.11473912 1 DatabaseMachine.xml related checks (permission, version) EntriesE t i ini em.params filefil Match entries in DatabaseMachine.XML with entries inem.params Versions of storage server software, IB switch etc. Cipher entries in the storage servers and the compute NodesCopyright 2011, Oracle and/or its affiliates. All rightsreserved.

Exadata MonitoringDatabaseStorage ServerInfiniband NetworkKVM,, PDU,, ILOM,, CISCOSWITCHCopyright 2011, Oracle and/or its affiliates. All rightsreserved.

Exadata ManagementIntegrated View of Hardware and Software Hardware view Schematic of cells, compute nodes andswitches Hardware components alerts Software/system view Performance, availability, usage bydatabases, services, clusters Software alerts db,db cluster,cluster ASM Topology view of DB systems/clusters Configuration view Version summary of all componentsalong with patch recommendationsCopyright 2011, Oracle and/or its affiliates. All rightsreserved.

Storage Cell Management Storage Cell monitoring andadministration support– Cell Home page andperformance pages– Actions supported: Start/stopy, setuppCell,, verifyy connectivity,SSH Automatic discovery of Exadatacells Management by Cell Group– All cells used by a databaseautomatically placed in a group– Cell Group level administrationoperationsCopyright 2011, Oracle and/or its affiliates. All rightsreserved.

Storage Cell Management Perform Cell Administration tasks– Execute Cellcli commands on a set of cells or all cells Setup IORM for database targets9Copyright 2011, Oracle and/or its affiliates. All rightsreserved.

Infiniband Network Management Infiniband network and switches as GCtargets– Automatic discovery Network home page and performance page– Real time and historical Topology view of Network with switch andport level detailsCopyright 2011, Oracle and/or its affiliates. All rightsreserved. Full monitoring– AlertsAl t (switch( it h generatedt d andd EMgenerated)– Performance metrics– Configuration metrics – detect andnotify configuration changes/bestpractice violations

Infiniband Network Management Perform Infiniband Administration tasks– Enable Port– Disable Port– Clear Performance counters– Clear Error CountersCopyright 2011, Oracle and/or its affiliates. All rightsreserved.

Monitoring: ILOM, Cisco Switch, KVMCommon metrics monitored Power supply failure Fan failure Temperature out of rangeSpecific metrics monitored Cisco Switch– Configuration change tracking and reporting– Unauthorized SNMP access Keyboard,Keyboard VideoVideo, Mouse (KVM)– Server connected to KVM added/removed, powered on/offCopyright 2011, Oracle and/or its affiliates. All rightsreserved.

Monitoring: Power Distribution Unit (PDU) Measures power consumption used by Exadata components and provides earlywarning of impending thresholds Monitors electric current being used by equipment connected in Exadata rackCopyright 2011, Oracle and/or its affiliates. All rightsreserved.

Exadata Service Dashboards Service dashboard for executives and business owners Many components reporting up to one Exadata Service MOS Note 1458346.1 outlines the steps to create the dashboardCopyright 2011, Oracle and/or its affiliates. All rightsreserved.

Exadata ManagementSetup & Monitor Discovering Exadata for Monitoring Monitoring the Database MachineTest Consolidate on Exadata Validate Application PerformanceManage PerformanceP fDiagnosticsDiti Application SQL TuningMaintain Configuration Compliance Patch AutomationCopyright 2011, Oracle and/or its affiliates. All rightsreserved.

Deployment ChallengesWillperformanceimprove?How long willt k ?it take?What are therisks?A li tiApplicationsDatabaseWhich appsto consolidate?StorageOS Deploying application to Exadata involves multiple changes:– O/S migrations– Storage subsystem changes– Database upgrades– Single database instance to RAC Proper testing required for risk mitigation.Copyright 2011, Oracle and/or its affiliates. All rightsreserved.

Deploying Applications on ExadataIdentifyApplicationsCreate TestEnvironmentsValidatePerformance Migrating applications to Exadata can be a very time consuming Three step process– Identify which applications to be migrated to Exadata– Create test environment on Exadata– Validate application performanceCopyright 2011, Oracle and/or its affiliates. All rightsreserved.

Consolidation Planner Target resource utilization and configurationdata extracted from Enterprise Managerrepository– CPU, memory, storage, networkAdministrator specifies servers andconstraints for workload migration–Physical/virtual servers–Existing/planned servers–Business/technical constraintsRt dt il hlid t d workloadskl dReportsdetailhow consolidatedwould perform on target serversCopyright 2011, Oracle and/or its affiliates. All rightsreserved.

Secure Test System DeploymentProductionTestSSNSALARYLAST 0LAST NAME 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 Masking of heterogeneous databases via database gateways Command line (EMCLI) support for data masking actionsCopyright 2011, Oracle and/or its affiliates. All rightsreserved.SALARY

Validate Application PerformanceEnd-to-end testing with real workloadsCaptureWorkloadReplayWorkloadCreate TestSystemDeploy ReplayClients Database Replay SQL Performance Analyzer– Load, performance testing for throughput– SQL unit testing for response time– Remediate application concurrency problems– Identify and tune regressed SQL– Integrated with Oracle Application Testing Suite for– Integrated into SQL Tuning Advisor and SQLpcomprehensiveptestingg solutionsuperiorPlan Baseline Seamless integration with Data Masking to preserve data sensitivity complianceCopyright 2011, Oracle and/or its affiliates. All rightsreserved.

Exadata ManagementSetup & Monitor Discovering Exadata for monitoring Monitoring the Database machineTest Consolidate on Exadata Validate Application PerformanceManage PerformanceP fDiagnosticsDiti Application SQL TuningMaintain Configuration Compliance Patch AutomationCopyright 2011, Oracle and/or its affiliates. All rightsreserved.

Integration with the Database Performance Page Drill down fromdatabase Performancepage Provides compositeview of all healthindicators of a cell orcell group Helps triage Load imbalance ASM relatedproblemsbl Cell software orhardware failures Cell configurationissues Network relatedfailuresCopyright 2011, Oracle and/or its affiliates. All rightsreserved.

Performance Diagnostics and TuningBoost AdministratorProductivityIO / CPUIssuesEliminate PerformanceBottlenecksHighLoadSQLAutomatic WorkloadRepository Snapshots Self-DiagnosticEngine (ADDM)RACIssuesLower IT ManagementCostsPerformance &ManagementAdvisorsDeliver Higher Qualityof ServiceOracle Database 11g’s Automatic Performance Diagnostics helps maximizes Exadata performanceTop-down performance analysis using Automatic Workload RepositoryReal-time performance analysis with Automatic Database Diagnostic MonitorResolve performance issues faster with drill-down root-cause analysisClassification tree based on Oracle performance tuning expertiseFully automates database performance diagnosticsCopyright 2011, Oracle and/or its affiliates. All rightsreserved.

Performance Diagnostics and TuningGather Missing or Stale StatisticsCreate a SQL ProfileSQL ProfilingAdd Missing Access StructuresStatistics AnalysisModify SQL ConstructsAAccessPPathth AAnalysisl iSQL Restructure AnalysisAlternative Plan AnalysisParallel QueryAutomaticTuningAnalysisOptimizerAdopt Alternative Execution PlanSQL TuningAdvisorCreate Parallel SQL ProfileAdministratorComprehensive SQL TuningRecommendations Automatic SQL Tuning– Analyze high-load SQL Æ tune using SQL Profiles Æ implement improved SQL plans (optional) Comprehensive SQL analyses across 6 dimensions: statistics, SQL profiling, index, alternate plan,parallelization and SQL structure SQL Profiles tunes execution plan without changing SQL text Enables transparent tuning for packaged applicationsCopyright 2011, Oracle and/or its affiliates. All rightsreserved.

Exadata Aware SQL Monitoring Real time monitoringg ofapplication SQL I/O performance graphs withExadata information– Cell offload efficiency– Cell smart scan Rich metric data– CPU– I/O requests– I/O throughput– PGA Usage– Temp UsageCopyright 2011, Oracle and/or its affiliates. All rightsreserved.

Exadata ManagementSetup & Monitor Discovering Exadata for monitoring Monitoring the Database machineTest Consolidate on Exadata Validate Application PerformanceManage PerformanceP fDiagnosticsDiti Application SQL TuningMaintain Configuration Compliance Patch AutomationCopyright 2011, Oracle and/or its affiliates. All rightsreserved.

Root Cause Analysis of Hardware Problems Topology View of all Exadata components by– Uses– Used By– System Members– DB MachineM hi SSoftwareft Enables out of the box root cause analysis of issues.Copyright 2011, Oracle and/or its affiliates. All rightsreserved.

Defect Diagnostics Support Workbench– Exadata integrated with Database defect diagnostic framework– Support Workbench provides viewing and packaging of incidents– Correlated packaging from DB through ASM to Exadata Incident Management– Software and hardware incidents tracked via Incident Console– Track, manage and resolve critical incidents– Hardware alerts (temperature, cell down, power supply,etc.)t )– Hardware failures come with picture indicating failed partlocation– Best practice violations automatically alerted28Copyright 2011, Oracle and/or its affiliates. All rightsreserved.

Configuration ManagementEnforce StandardsEliminate DriftAutomated Configuration Management Enforcement of Exadata configurations using Policies Detection of configuration drifts and changes– From defined ggolden standards– Between storage servers and between database machines Detect database targets that do not have required patchesCopyright 2011, Oracle and/or its affiliates. All rightsreserved.