1 / 56

Jason Arneil Exadata Consultant

Jason Arneil Exadata Consultant. Exadata From Installation to Go Live: Experiences from Banking and Retail. Jason Arneil Exadata Consultant. “Things you want to think about when considering buying Exadata to size it correctly and things to configure before you go live”.

manning
Download Presentation

Jason Arneil Exadata Consultant

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. Jason ArneilExadata Consultant Exadata From Installation to Go Live: Experiences from Banking and Retail

  2. Jason ArneilExadata Consultant “Things you want to think about when considering buying Exadata to size it correctly and things to configure beforeyou go live”

  3. jarneil.wordpress.com @jarneil

  4. Customers

  5. Agenda Capacity Planning

  6. Agenda

  7. Consolidation

  8. Capacity Planning 186TB 504TB

  9. System Partitions DATA RECO DATA RECO DBFS

  10. Hybrid Columnar Compression Compression Unit block header block header block header Col B Col D Col A CU header Col C

  11. Hybrid Columnar Compression Table Size Reduction – Retail Data

  12. Hybrid Columnar Compression Compression Ratio – Retail Data

  13. Hybrid Columnar Compression Compression Ratio – Logging Data

  14. Hybrid Columnar Compression Total Database Size Reduction

  15. Capacity Planning IOPS

  16. Capacity Planning High Performance High Capacity 504 TB

  17. Capacity Planning

  18. Capacity Planning

  19. Capacity Planning

  20. Capacity Planning

  21. Capacity Planning

  22. Capacity Planning CPU

  23. Capacity Planning Current Allocated CPU

  24. Capacity Planning Utilisation

  25. Capacity Planning Current CPU Requirement

  26. Capacity Planning SPEC

  27. Capacity Planning OFFLOADING

  28. Current CPU Capacity Planning X Utilisation X Required Exadata CPU  SPEC Scale Factor X Offloading Factor

  29. Capacity Planning

  30. Capacity Planning Memory

  31. Capacity Planning

  32. Consolidation

  33. Consolidation

  34. Consolidation Instance Caging

  35. Consolidation cpu_count

  36. Consolidation resource_manager_plan

  37. Consolidation resmgr: cpu quantum

  38. Consolidation V$rsrcmgrmetric_history

  39. Capacity Planning oversubscribe

  40. Consolidation Memory

  41. Consolidation Huge Pages

  42. Consolidation vm.nr_hugepages

  43. Consolidation use_large_pages=only

  44. Consolidation IORM

  45. Consolidation DATABASE ALLOCATION LIMIT A 45% 75% B 30% 60% C 25% 50%

More Related