560 likes | 708 Views
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”.
E N D
Jason ArneilExadata Consultant Exadata From Installation to Go Live: Experiences from Banking and Retail
Jason ArneilExadata Consultant “Things you want to think about when considering buying Exadata to size it correctly and things to configure beforeyou go live”
jarneil.wordpress.com @jarneil
Agenda Capacity Planning
Capacity Planning 186TB 504TB
System Partitions DATA RECO DATA RECO DBFS
Hybrid Columnar Compression Compression Unit block header block header block header Col B Col D Col A CU header Col C
Hybrid Columnar Compression Table Size Reduction – Retail Data
Hybrid Columnar Compression Compression Ratio – Retail Data
Hybrid Columnar Compression Compression Ratio – Logging Data
Hybrid Columnar Compression Total Database Size Reduction
Capacity Planning IOPS
Capacity Planning High Performance High Capacity 504 TB
Capacity Planning Current Allocated CPU
Capacity Planning Utilisation
Capacity Planning Current CPU Requirement
Capacity Planning SPEC
Capacity Planning OFFLOADING
Current CPU Capacity Planning X Utilisation X Required Exadata CPU SPEC Scale Factor X Offloading Factor
Capacity Planning Memory
Consolidation Instance Caging
Consolidation cpu_count
Consolidation resource_manager_plan
Consolidation resmgr: cpu quantum
Consolidation V$rsrcmgrmetric_history
Capacity Planning oversubscribe
Consolidation Memory
Consolidation Huge Pages
Consolidation vm.nr_hugepages
Consolidation use_large_pages=only
Consolidation IORM
Consolidation DATABASE ALLOCATION LIMIT A 45% 75% B 30% 60% C 25% 50%