http://blog.tanelpoder.com/files/Tanel_Poder_Drilling_Deep_Into_Exadata_Performance.pdf
Exadata’s “secret sauce” for different workloads
“DW / Reporing”
• Long running SQL statements
• Executed less frequently
• Secret Sauce: Smart Scans + Offloading + Storage Indexes
• SQL statements should use full table scans + hash joins
“OLTP”
• Short SQL statements
• Executed very frequently
• Secret Sauce: Flash Cache
• SQL & performance tuning is the same as usual!
Grid Infrastructure --- OCR and Voting Disks Location at Installation
-
In Oracle Grid Infrastructure, the OCR (Oracle Cluster Registry) and
Voting "Disks" must be on Shared Storage accessible by all the nodes of the
Cluster...
Acum 4 zile
Niciun comentariu:
Trimiteți un comentariu