Oracle Exadata©Ê¯àÀu¤Æ ( ²Åé ¦r) |
§@ªÌ¡G¥Û¤ªµØ¡B³¯¯E¡BÄǦB | Ãþ§O¡G1. -> ¸ê®Æ®w -> Oracle |
ĶªÌ¡G |
¥Xª©ªÀ¡G²MµØ¤j¾Ç¥Xª©ªÀ | 3dWoo®Ñ¸¹¡G 52334 ¸ß°Ý®ÑÄy½Ð»¡¥X¦¹®Ñ¸¹¡I¡i¯Ê®Ñ¡j NT°â»ù¡G 445 ¤¸ |
¥Xª©¤é¡G1/1/2020 |
¶¼Æ¡G315 |
¥úºÐ¼Æ¡G0 |
|
¯¸ªø±ÀÂË¡G |
¦L¨ê¡G¶Â¥Õ¦L¨ê | »y¨t¡G ( ²Åé ª© ) |
|
¥[¤JÁʪ«¨® ¢x¥[¨ì§Úªº³Ì·R (½Ð¥ýµn¤J·|û) |
ISBN¡G9787302532903 |
§@ªÌ§Ç¡@|¡@ĶªÌ§Ç¡@|¡@«e¨¥¡@|¡@¤º®e²¤¶¡@|¡@¥Ø¿ý¡@|¡@§Ç |
(²Åé®Ñ¤W©Òz¤§¤U¸ü³sµ²¯Ó®É¶O¥\, ®¤¤£¾A¥Î¦b¥xÆW, YŪªÌ»Ýn½Ð¦Û¦æ¹Á¸Õ, ®¤¤£«OÃÒ) |
§@ªÌ§Ç¡G |
ĶªÌ§Ç¡G |
«e¨¥¡GExadata¬OOracle¤½¥q¸ó®É¥Nªº¤@´Ú²£«~¡C¹B¦æ¦bExadata¬[ºc¤WªºOracle¼Æ¾Ú®w¡A¨ä¾ãÅé©Ê¯à¤ñ¹B¦æ¦b¶Ç²Î¬[ºc¤WªºOracle¼Æ¾Ú®w°ª¥X¤Q´X¿¡A¦b¤@¨Ç¯S®íªº·~°È³õ´º¡A¨ä©Ê¯àªí²{ÁÙ¥i¥H§ó¥[Àu¨q¡C ¦³¤H¥i¯à·|»¡¡AExadata¬[ºc¤W¤º¸m¤FInfiniband¥æ´«¾÷¡A¦P®É¦b¦sÀx©³¼h¨Ï¥Î¤FPCIúQE°{¦s¥d¡A»P¶Ç²ÎªºSAN¦sÀxÀô¹Ò¬Û¤ñ¡A¨äIO±a¼e´£¤É¤F¦n´X¿¡A©Ê¯à·íµM§ó¥[Àu¨q¤F¡C¨S¿ù¡A¦ý³o¶È¶È¬OExadata¬[ºc©Ê¯à´£¤Éªº¤@Ó¤p¤pªº¦]¯À¦Ó¤w¡C ¥Ø«e¡A°ê¤º¤w¸g¦³«Ü¦h¥ø·~¯É¯É®Ä¥éExadata¬[ºc¡A¨³³t±À¥X¤F¦Û¤vªº¼Æ¾Ú®w¤@Åé¾÷²£«~¡A¦ý³oºØ®Ä¥é¶È¶È¬Oµw¥ó¬[ºc¼h±ªº¼Ò¥é¡A¹ï¤_Exadataªº®Ö¤ß§Þ³NÁÙ¬O¨S¿ìªk¼Ò¥éªº¡C Exadata¤WªºOracle¼Æ¾Ú®w¤§©Ò¥H¹B¦æ³t«×³o¤\§Ö¡A¦}¤£¬O¥¦ªºµw¥ó¦³¦h¤\¦n¡]¨ä¹ê¥¦ªºµw¥ó´N¬O¤@°ïPCªA°È¾¹¦Ó¤w¡A³æ¯Â´Nµw¥óªº¹Bºâ¯à¤O¶i¦æ¹ï¤ñ¡A¥¦´NµLªk»PIBM¤p«¬¾÷§Ü¿Å¡^¡A¥Dn¦b¤_¥¦¦³¿W¯Sªº®Ö¤ß§Þ³N¡C¨º¤\Exadataªº®Ö¤ß§Þ³N¬O¤°¤\©O¡H®Ö¤ß§Þ³N´N¬O¦sÀxºÞ²z³n¥ó¼h±¤Wªº¯S©Ê¡A¦p´¼¯à±½´y¡BFlashCacheµ¥¡C ¤@¦~«e¡A¦bµ§ªÌ½s¼gªº²Ä¤@¥»Exadata±MµÛ¡mExadata¹ê¬I¹Bºû«ü«n¡n¤¤¡A¶È¶È¯A¤Î¤FExadataªº¨ê¾÷¦w¸Ë¡BºÞ²z¤u¨ã¡Bµw¥ó§ó´«¡B²Õ¥ó¤É¯Å³o´X³¡¤À¤º®e¡C³o¤@¤è±¬O¥Ñ¤_¹Ï®Ñ½g´Tªº¨î¡A¥t¤@¤è±¥Dn¦]¬°µ§ªÌ»{¬°Exadata³n¥ó¯S©Ê¤~¬OExadata¬[ºcªº®Ö¤ß¡A¦³¥²n§â³o³¡¤À¤º®e³æ¿W®³¥X¨Ó²`¤J¦a¶i¦æÁ¿¸Ñ¡C ¥»®Ñ´N±a»â¤j®a¨B¤JExadataªº³n¥ó¥@¬É¡A¤F¸ÑExadataªº®Ö¤ß¯S©Ê¡C¥u¦³¯u¥¿²z¸Ñ¤F³o¨Ç®Ö¤ß¯S©Ê¡A¤~¯à§ó¦n¦a¶i¦æExadataÀu¤Æ¤u§@¡C ¥Ñ¤_Oracle¤½¥q¤£¥i¯à¤½¶}Exadata·½¥N½X¡AExadata¬[ºc¤¤«Ü¦h³n¥ó¯S©Êªº¨ãÅé¹ê²{ºâªk¬O«Ê³¬ªº¡A¥~³¡¤Hû°ò¥»¤W¤£¥i¯à±µÄ²¨ì³o¨Ç²Ó¸`ªº§Þ³N«H®§¡C¦b¥»®Ñ¤¤¡A¦³¨Ç³n¥ó¯S©Êªº©³¼h¹ê²{ì²z¬OÓ¤H±À´úªº¡A³o´NÃø§K¦s¦b¤@¨Ç²¨º|¡A¦³«ÝŪªÌ«ü¥X¦}קï¡A¤]§Æ±æ¤j®a¯à¤ÏõX¬ÛÃö·N¨£¡A¨Ï¥»®Ñ±o¨ì§ó¦nªº×½s¡B§ï¶i¡C PÁ º¥ý¡A·PÁÂ¥_¨Ê®ü¤Ñ°_ÂI§Þ³NªA°ÈªÑ¥÷¦³¤½¥q¡A¨S¦³³o¼Ëªº¤@Ó¥»O¡A§ÚÌ¥i¯à³s±µÄ²Exadataªº¾÷·|³£¨S¦³¡A¦ÛµM¤]´N¤£¥i¯à¦³¥»®Ñªº¥Xª©¡C ¨ä¦¸¡A·PÁÂÄǦB¡B³¯¯E©M§Ú¤@°_¦X¤O§¹¦¨¤F¥»®Ñ¡F ·PÁ¼B¤å«Ø¡B¤ý´I¶Q¦b§Ú̹J¨ìExadataµw¥ó¤è±ªº¬G»Ù®É¡A´£¨Ñªº¦UºØ«ä¸ô»PÀ°§U¡F ¦P®É·PÁ§ڪº¨ä¥L¦P¨Æ¦b¥»®Ñªº¼g§@¹Lµ{¤¤µ¹¤©ªº«Ü¤jÀ°§U¡C ³Ì¦Z¡A·PÁ²MµØ¤j¾Ç¥Xª©ªÀªº¦U¦ì½s¿è¦Ñ®v¬°¥»®Ñªº¥Xª©©Ò°µªº²ÓP¤J·Lªº¤u§@¡A¯S§O·PÁ²±ªF«G¦Ñ®v¡A¥L¦b¥»®Ñªº¼g§@¹Lµ{¤¤¦h¦¸´£¥Xקï«Øij¡C
½sµÛªÌ2019¦~11¤ë |
¤º®e²¤¶¡G¥»®Ñ¾A¥Î¤_¼Æ¾Ú®wºÞ²zû¡B¼Æ¾Ú®w¶}µoªÌ¡B¨t²Î¬[ºc®v¡B¼Æ¾Ú®w·R¦nªÌ¡C¥»®Ñ°²©wŪªÌ¤w¸g¼ô±xOracle¼Æ¾Ú®w¡A©Ò¥H¨S¦³¸Ô²Ó¸ÑÄÀOracle¼Æ¾Ú®wªº¤u§@ì²z¡A°£«D¼Æ¾Ú®w¯A¤Î¨ìExadata¬ÛÃöªº¯S©Ê¡C |
¥Ø¿ý¡G²Ä1³¹´¼¯à±½´y 1.1¤°¤\¬O´¼¯à±½´y 1.1.1¦æ¹LÂo 1.1.2¦C¬M®g 1.1.3¥¬¶©¹LÂo 1.1.4¨ç¼Æ¹LÂo 1.2´¼¯à±½´y«e´£±ø¥ó 1.2.1«e´£±ø¥ó 1.2.2º¡¨¬±ø¥ó¦ý¤£Ä²µo´¼¯à±½´y 1.3¦p¦ó½T©w¥¿¦bµo¥Í´¼¯à±½´y 1.3.1°õ¦æp¹º¤¤¥X²{¥þ±½´y¦}¤£¥Nªí¤w¸g´¼¯à±½´y 1.3.2¦p¦ó½T»{´¼¯à±½´y¤w¸g¤u§@ 1.4¦ê¦æª½±µ¸ô®|ºâªk 1.4.1_small_table_threshold°Ñ¼Æ 1.4.2_very_large_object_threshold°Ñ¼Æ 1.4.3¦ê¦æDirectPathReadºâªk 1.4.4_direct_read_decision_statistics_driven°Ñ¼Æ 1.5¤Þ¾ÉSQL»y¥y¨Ï¥Î´¼¯à±½´y 1.6¶EÂ_´¼¯à±½´y¿ù»~µ²ªG¶° 1.6.1´¼¯à±½´y¬yµ{¹Ï 1.6.2´¼¯à±½´y¿ù»~µ²ªG¶°ªº¶EÂ_ 1.7¶EÂ_´¼¯à±½´y©Ê¯à°ÝÃD 1.7.1´¼¯à±½´y©Ê¯à°ÝÃD±`¨£ì¦] 1.7.2´¼¯à±½´y©Ê¯à°ÝÃD¶EÂ_¤u¨ã ²Ä2³¹¦sÀx¯Á¤Þ 2.1¦sÀx¯Á¤Þ¤u§@ì²z 2.2ÀË´úSQL»y¥y¬O§_§Q¥Î¦sÀx¯Á¤Þ 2.3¦C¼Æ¾Ú¤À¥¬¹ï¦sÀx¯Á¤Þªº¼vÅT 2.4¸T¥Î¦sÀx¯Á¤Þ¯S©Ê 2.5¸òÂܦsÀx¯Á¤Þ 2.6¦sÀx¯Á¤Þ¯S©Ê¼W±j 2.6.1¦sÀx¯Á¤Þ«©w¦ì 2.6.2Àu¤ÆMIN()©MMAX()¨ç¼Æ 2.7¦sÀx¯Á¤Þ¤£¤u§@³õ´º 2.7.1_kcfis_storageidx_disabled°Ñ¼Æ 2.7.2_smu_debug_mode°Ñ¼Æ 2.7.3ªø¨Æ°È 2.7.4¦sÀx¯Á¤Þ¶W¹L8Ó¦r¬q
²Ä3³¹ExadataSmartFlashLog 3.1FlashLog¤u§@ì²z 3.2ºÞ²zFlashLog 3.2.1FlashLog¤é±`ºÞ²z 3.2.2Ãö³¬FlashLog¯S©Ê 3.3FlashLog¶EÂ_ 3.4ºÊ±±FlashLog©Ê¯à 3.4.1FlashLog©Ê¯à«ü¼Ð 3.4.2FlashLog©Ê¯à¤ÀªR ²Ä4³¹ExadataFlashCache 4.1Exadata¤WPCIúQE°{¦s¥dÅܾE¥v 4.1.1X2¨t¦CF20¥d 4.1.2X3¨t¦CF40¥d 4.1.3X4¨t¦CF80¥d 4.1.4X5¨t¦CF160¥d 4.1.5X6¨t¦CF320¥d 4.1.6X7¨t¦CF640¥d 4.2Exadata¤WPCIúQE°{¦s¥dªº¤£¦P¥Î³~ 4.3ExadataFlashCacheì²z 4.3.1°w¹ï¤jªí©Î´¼¯à±½´y¼Æ¾Ú¶ôªº½w¦s 4.3.2þ¨Ç¼Æ¾Ú¶ô·|½w¦s¨ìFlashCache¤¤ 4.3.3¤â°Ê±N¹ï¶Hkeep¦bFlashCache¤¤ 4.3.4FlashCachekeepÄÝ©ÊȦ۰ʥ¢®Ä 4.3.5FlashCache(writeúQthrough¼Ò¦¡)IO½Ð¨D 4.3.6³]¸mGriddiskªºCacheµ¦²¤ 4.4FlashCacheÀ£ÁY¯S©Ê 4.4.1FlashCacheÀ£ÁY¯S©Ê»Ý¨D 4.4.2FlashCacheÀ£ÁY¤º³¡ì²z 4.4.3FlashCacheÀ£ÁY¯S©Êªº¶}±Ò»PÃö³¬ 4.5FlashCachewriteúQback¼Ò¦¡ 4.5.1¬°¤°¤\¶}±ÒFlashCacheªºwriteúQback¼Ò¦¡ 4.5.2FlashCachewriteúQback¼Ò¦¡»Ý¨D 4.5.3FlashCachewriteúQback¼Ò¦¡IO½Ð¨D 4.5.4writeúQback»PwriteúQthrough¼Ò¦¡¤Á´« 4.5.5writeúQback¼Ò¦¡ªºflush¾Þ§@ 4.5.6ª½±µ¸ô®|¼g¤J¹ïwriteúQback¼Ò¦¡ªº¼vÅT 4.6ºÊ±±FlashCache©Ê¯à 4.6.1flashcachecontent«ü¼Ð 4.6.2½T»{FlashCacheªº©R¤¤²v 4.6.3FlashCache¤º®e¤ÀªR¤u¨ã 4.6.4¬YӼƾڮw¥e¥ÎªºFlashCache¤j¤p ²Ä5³¹²V¦X¦CÀ£ÁY 5.1¼Æ¾ÚÀ£ÁYì²z 5.1.1OLTPÀ£ÁYì²z 5.1.2²V¦X¦CÀ£ÁYì²z»PS³ò 5.2²V¦X¦CÀ£ÁYªí¸ÑÀ£ÁY 5.3DML¾Þ§@¹ï²V¦X¦CÀ£ÁYªíªº¼vÅT 5.4¦}µo¾Þ§@¹ï²V¦X¦CÀ£ÁYªíªº¼vÅT 5.5²V¦X¦CÀ£ÁY«Øij ²Ä6³¹IO¸ê·½ºÞ²z 6.1IORM·§n 6.2IO½Õ«×¹ï¤ñ 6.3IORM¥Ø¼Ð¼Ò¦¡ 6.4IORM¹ê¬I¤ÀÃþ 6.4.1InterúQDatabaseÃþ«¬ 6.4.2IntraúQDatabaseÃþ«¬ 6.4.3CategoryÃþ«¬ 6.4.4MixedÃþ«¬ 6.5ºÊ±±IORM©Ê¯à 6.5.1¦¬¶°IORM°t¸m«H®§ 6.5.2metric_iorm.pl¸}¥» ²Ä7³¹ºÏ½LÀ¿¬~¯S©Ê 7.1¡§¦Û°ÊºÏ½LÀ¿¬~©M×´_¡¨¯S©Ê»Ý¨D 7.2¦Û°ÊºÏ½LÀ¿¬~©M×´_¯S©Ê¹ïIOªº¼vÅT 7.3¦Û¾AÀ³ªººÏ½LÀ¿¬~½Õ«×¯S©Ê 7.4¡§¦Û°ÊºÏ½LÀ¿¬~©M×´_¡¨¯S©Ê¼W±j 7.5¡§ASMºÏ½LÀ¿¬~¡¨¯S©Ê ²Ä8³¹ExadataÀu¤Æ»~°Ï 8.1Exadata¤W¬O§_»Ýn¯Á¤Þ 8.2Exadata¤W¶}±Ò¦}¦æ 8.3Exadata¤WSGA³]¸m 8.4Exadata¤W¬O§_»Ýn¤À°Ï 8.5Exadata¤WªºSQL¬O§_»ÝnÀu¤Æ ²Ä9³¹µ¥«Ý¨Æ¥ó»P©Ê¯à«ü¼Ð 9.1Exadataµ¥«Ý¨Æ¥ó 9.1.1cellsmarttablescan©Mcellsmartindexscanµ¥«Ý¨Æ¥ó 9.1.2cellsingleblockphysicalreadµ¥«Ý¨Æ¥ó 9.1.3cellmultiblockphysicalreadµ¥«Ý¨Æ¥ó 9.1.4celllistofblocksphysicalreadµ¥«Ý¨Æ¥ó 9.2ºÊ±±©Ê¯à«ü¼Ð 9.2.1«ü¼ÐÃþ«¬ 9.2.2¦sÀx¸`ÂI¬ÛÃö«ü¼Ð 9.2.3Celldisk¬ÛÃö«ü¼Ð 9.2.4FlashCache¬ÛÃö«ü¼Ð 9.2.5FlashLog¬ÛÃö«ü¼Ð 9.2.6SmartIO¬ÛÃö«ü¼Ð 9.2.7¸ê·½¾ã¦X¬ÛÃö«ü¼Ð ²Ä10³¹ExadataÀu¤Æ®×¨Ò 10.1®×¨Ò1(FlashCachewriteúQback¦]¯À) 10.2®×¨Ò2(FlashCache¸ê·½¨Ï¥Î¤£§¡¦]¯À) 10.3®×¨Ò3(IOÅTÀ³©µ®É) 10.4®×¨Ò4(ºôµ¸¦]¯À) 10.5®×¨Ò5(´¼¯à±½´y¦]¯À) 10.6®×¨Ò6(ºî¦X¦]¯À) 10.7®×¨Ò7(´¼¯à±½´y¤Þµo©Ê¯à°ÝÃD) 10.8®×¨Ò8(¾ã¦XÀô¹Ò¤Þµo©Ê¯à°ÝÃD) 10.9®×¨Ò9(FlashCacheºÞ²z¯Ê³´) µ²§ô»y |
§Ç¡G |