基于PCIe闪存卡的Oracle-高可用与高性能的解决方案_戴明明_v1.3

戴明明(Dave)[e-mail]••••••服务器：八路X86服务器操作系统：RedHat6.5CPU:IntelE7-8870v2*8内存：1T数据库：11.2.0.4测试工具：HammerDB••查看参数：SQLshowparameterflashNAMETYPEVALUE-----------------------------------------db_flash_cache_filestringdb_flash_cache_sizebiginteger0一般建议FlashCache设置为SGA的2-10倍：SQLaltersystemsetdb_flash_cache_file='/home/dave/oracle/flashdata/flashcache'scope=spfile;SQLaltersystemsetdb_flash_cache_size=50Gscope=spfile;Primary+PCIe闪存卡Standby+PCIe闪存卡IB直连：IPoIBIB直连：IPoIBX86服务器X86服务器PCIe闪存卡PCIe闪存卡PCIe闪存卡InfiniBand交换机InfiniBand交换机Oraclecalibrate-io测试：SQLSELECTdg.nameASdiskgroup,t.name,t.stripe,t.redundancy,t.primary_region,t.mirror_regionFROMV$ASM_DISKGROUPdg,V$ASM_TEMPLATEtWHEREdg.group_number=t.group_numberANDdg.name='DATA'andt.name='ONLINELOG'ORDERBYt.name;DISKGROUPNAMESTRIPEREDUNDPRIMMIRR------------------------------------------------------------DATAONLINELOGCOARSEMIRRORCOLDCOLDSQLalterdiskgroupdatamodifytemplateonlinelogattributes(fine);Diskgroupaltered.DISKGROUPNAMESTRIPEREDUNDPRIMMIRR--------------------------------------------------------------DATAONLINELOGFINEMIRRORCOLDCOLDQ&A