Presentation Transcript

1. Best Practices for Supporting Exadata Bennett FleisherExadata Enterprise Support Team – Director Jaime Figueroa Exadata Enterprise Support Team – Senior Principal Support Engineer
2. The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.
3. Program Agenda Introduction Best Practices and Recommendations Additional Tips and Resources Q&A
4. Oracle Services Enabling the success of your Oracle hardware and software investments Oracle Experts Helping You Succeed withYour Oracle Investments Complete Support for Oracle Hardware, Software, and Engineered Systems Mission Critical Support Services for All Oracle Applications and Technologies Your Complete Training Source for Oracle Hardware and Software Extend Your Oracle Investments to the Cloud with Value, Choice, and Confidence
5. Oracle Premier Support Comprehensive Coverage Tools and Resources Service and Support Product Innovation Quickly diagnose and resolve issues Expert technical support Rapid-response field service Lifetime Support Get the most of your Oracle products with proactive services Oracle knowledgebase Product health checks My Oracle Support Community Keep pace with change and capitalize on new opportunities Updates New releases Tools to assist with patching and upgrades
6. Get Proactive Portfolio—an integral component of your Premier Support Contract Helping you get the most value fromOracle Premier Support
7. Oracle SupportBest Practices and Recommendations for Exadata
8. Top Reasons for Creating Service Requests What we see the most: Configuration Changes Consultative Software Defects Hardware Failures
9. Diagnostic tools MOS Document 888828.1 Reference document for information regarding: Latest releases Version Compatibility Patching overview and guidelines Critical issues Configure your MOS portal account settings to receive alerts regarding Exadata Storage product Hot Topics E-Mail under My Account
10. Diagnostic tools Best Practices 757552.1 Defined by Oracle Development but also based on feedback from thousands of installations Guidelines for configuration Input data for exachk Organized on individual notes/areas: Setup & Configuration, Performance, High Availability, Backup & Recovery and more Covers all components of the database machine
11. Diagnostic tools exachk exachk Useful both proactively and reactively Always use the latest version published in MOS note (Doc ID 1070954.1) If you need support to review the results upload the complete zip file generated by exachk
12. Diagnostic tools Select to view details exachk output example
13. Diagnostic tools Verify vm.min_free_kbytes details
14. Diagnostic tools Verify vm.min_free_kbytes details
15. Diagnostic tools oswatcher /opt/oracle.oswatcher/osw/archive Useful when diagnosing hangs, crashes or performance problems Has a default retention period of seven days Both the Storage Servers and Database Servers collect OSW data
16. Diagnostic tools oswatcher oswmeminfo
17. Diagnostic tools sundiag /opt/oracle.SupportTools/sundiag.sh [osw] [ilom|snapshot] Useful when diagnosing hardware and Storage Server software issues
18. Diagnostic tools sundiag cell raid cell ilom ilom raid
19. Diagnostic tools Networking Network Diagnostics information for Oracle Database Machine Environments (Doc ID 1053498.1) Set of commands executed as a script rds-ping,rds-info,verify-topology, ibhosts, ibswitches, ibnetdiscover, ibqueryerrors, ibdiagnet, sminfo, iblinkinfo, infinicheck
20. Diagnostic tools Networking
21. Diagnostic tools Performance Issues oswatcher, sundiag awr v$cell_stat metric_iorm.pl awrsprio.sql
22. Diagnostic tools Performance Issues AWR & V$CELL_STAT
23. Diagnostic tools PerformanceIssues set long 20000 select cell_name, xmltype(STATISTICS_VALUE).getclobval(2,2) from v$cell_state where STATISTICS_TYPE = 'PREDIO';
24. Diagnostic tools Performance Issues Tool for Gathering I/O Resource Manager Metrics: metric_iorm.plDoc ID 1337265.1 Use of metrics from the storage cells Collect current or historic data Can be used to identify: Type of workload causing most the IO usage If IO usage comes from a specific database Cell metrics summary metric_iorm.pl
25. Diagnostic tools #cellcli –e list metrichistory where name like ‘FC.*’ and collectiontime > ‘2013-09-17T00:00:00-06:00’ and collectiontime < ‘2013-09-17T02:00:00-06:00’ Performance Issues Use sundiag to validate health of flashcache Use cellmetrics to get complete information about flashcache FlashCache
26. Diagnostic tools Performance Issues When using WriteThrough mode use script awrsprio.sql to identify candidates to keep in flashcache Flashcache
27. Diagnostic tools Performance Issues
28. Diagnostic tools Performance Issues
29. Diagnostic tools FlashCache System performance can get improved if flashcache is configured as WriteBackmode. If HardDisks are write IO bound ExadataWrite-Back Flash Cache - FAQ (Doc ID 1500257.1)
30. Additional Tipsand Resources
31. Other Helpful Hints and Tips Exadata Community https://communities.oracle.com/portal/server.pt/community/ Forum participation by your peers and moderated by Oracle Support Popular articles Advisor Webcasts: Using Exadata'shealthcheck tool: Exachk Using Exadata's Diagnostic Tool: Diagnostic Assistant Plus many more archived
32. Patching performed by Oracle engineers 24/7 proactive remote fault monitoring Higher support levels for Oracle stack Faster response times Available now for certified configurations on Oracle Exadata Database Machine, Oracle Exalogic ElasticCloud and Oracle SuperCluster Performance-Oriented Support for Oracle Engineered Systems ORACLE PLATINUM SERVICES Proactive approach to maximizing system health and availability Critical issue prevention and faster resolution Reduced operational cost and IT staff workload No Additional Cost
33. Oracle Platinum Services Extensions ADVANCED MONITORING & RESOLUTION 275 additional monitoring metrics customizable to customer specific service level targets Extend monitoring coverage to non-Platinum Oracle environments Complete closed-loop resolution performed by Oracle Advanced Support Engineers Proactive & predictive recommendations based on usage pattern analysis PLATINUM SERVICES END USER PERFORMANCE MONITORING Extend performance monitoring coverage to end user / Oracle application layer Determines how and where end user performance problems impact business Trend analysis utilizing 13 month rolling data repository for customer analytics SOLUTION SUPPORT CENTER Dedicated Support Team with intimate knowledge of customer business & systems Local / onsite Oracle Technical Account Manager 24/7 dedicated customer hotline with response SLA Proactive performance and configuration reviews Root cause analysis and corrective action plans
34. While You’re at Oracle OpenWorld… Support Stars BarMoscone West, Level 2 Oracle experts Live demos Mini-briefings Videos Support Breakout Sessions Oracle Database Oracle E-Business Suite SQL Tuning Oracle Exadata Siebel CRM PeopleSoft JD Edwards Oracle Business Analytics Oracle Fusion Middleware Oracle Solaris Oracle RAC Cluster Oracle Communications Solutions Sun Server and Storage Systems
35. 4th Annual My Oracle Support Community Meet Up Event Monday, September 23 6:30 – 9:30 pm Join us for fun, networking, beverages and appetizers Meet fellow Community members and Oracle moderators Admission is free but registration is required Details and registration at: www.bit.ly/MeetUpEvent2013
36. Recap Recommendations Reference Notes 888828.1 Database Machine and Exadata Storage Server 11g Release 2 (11.2) 1500257.1Exadata Write-Back Flash Cache – FAQ 1337265.1 Tool for Gathering I/O Resource Manager Metrics: metric_iorm.pl 1053498.1 Network Diagnostics information for Oracle Database Machine Environments 1070954.1 Oracle Exadata Database Machine exachk or HealthCheck 757552.1 Oracle Exadata Best Practices 1353073.1 ExadataDiagnostic Collection Guide
37. Q&A and Important Support Resources Discover more about Get Proactive: http://www.oracle.com/goto/proactivesupport MOS Community:https://communities.oracle.com/portal/server.pt/community/engineered_systems/359 https://communities.oracle.com/portal/server.pt/community/exadata_general/360
38. Thank you!