-- ·|­û / µù¥U -- ¡@
¡@±b¸¹¡G
¡@±K½X¡G
¡@ | µù¥U | §Ñ°O±K½X
3/26 ·s®Ñ¨ì¡I 3/19 ·s®Ñ¨ì¡I 3/14 ·s®Ñ¨ì¡I 12/12 ·s®Ñ¨ì¡I
ÁʮѬyµ{¡EQ & A¡E¯¸°È¯d¨¥ª©¡E«ÈªA«H½c
¢x 3ds Max¢x Maya¢x Rhino¢x After Effects¢x SketchUp¢x ZBrush¢x Painter¢x Unity¢x
¢x PhotoShop¢x AutoCad¢x MasterCam¢x SolidWorks¢x Creo¢x UG¢x Revit¢x Nuke¢x
¢x C#¢x C¢x C++¢x Java¢x ¹CÀ¸µ{¦¡¢x Linux¢x ´O¤J¦¡¢x PLC¢x FPGA¢x Matlab¢x
¢x Àb«È¢x ¸ê®Æ®w¢x ·j¯Á¤ÞÀº¢x ¼v¹³³B²z¢x Fluent¢x VR+AR¢x ANSYS¢x ²`«×¾Ç²ß¢x
¢x ³æ´¹¤ù¢x AVR¢x OpenGL¢x Arduino¢x Raspberry Pi¢x ¹q¸ô³]­p¢x Cadence¢x Protel¢x
¢x Hadoop¢x Python¢x Stm32¢x Cortex¢x Labview¢x ¤â¾÷µ{¦¡¢x Android¢x iPhone¢x
¥i¬d®Ñ¦W,§@ªÌ,ISBN,3dwoo®Ñ¸¹
¸Ô²Ó®ÑÄy¤ÀÃþ

Oracle Exadata©Ê¯àÀu¤Æ

( ²Åé ¦r)
§@ªÌ¡G¥Û¤ªµØ¡B³¯¯E¡BÄǦBÃþ§O¡G1. -> ¸ê®Æ®w -> Oracle
ĶªÌ¡G
¥Xª©ªÀ¡G²MµØ¤j¾Ç¥Xª©ªÀOracle Exadata©Ê¯àÀu¤Æ 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¨¥¡G

Exadata¬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¥D­n¦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¤@¤è­±¥D­n¦]¬°µ§ªÌ»{¬°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»P­S³ò
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