Exadata’s “secret sauce” for diﬀerent workloads
“DW / Reporing”
• Long running SQL statements
• Executed less frequently
• Secret Sauce: Smart Scans + Oﬄoading + Storage Indexes
• SQL statements should use full table scans + hash joins
• Short SQL statements
• Executed very frequently
• Secret Sauce: Flash Cache
• SQL & performance tuning is the same as usual!
New OA Framework 12.2.6 Update 5 Now Available - Web-based content in Oracle E-Business Suite Release 12 runs on the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface l...
Acum 5 zile