鎽� 瑕�:鏍规摎(j霉)娣卞湷鍦伴惖AFC绯荤当(t菕ng)鏁�(sh霉)鎿�(j霉)宀搁伕鍨�銆佽ō瑷�銆佹噳鐢ㄧ殑瀵﹂殯缍�(j墨ng)椹�锛岄棥杩颁簡AFC绯荤当(t菕ng)鏁�(sh霉)鎿�(j霉)搴董璀风殑瀵︾従(xi脿n)鏂规硶鍜屽劒(y艒u)鍖栫瓥鐣�锛屼互閬斿埌AFC绯荤当(t菕ng)鏁�(sh霉)鎿�(j霉)搴妧琛�(sh霉)鎬ц兘鍙婄┅(w臎n)瀹氭€т笉鏂锋彁楂樼殑鐩殑銆� 闂�(gu膩n)鍋ヨ:鑷嫊鍞绁ㄧ郴绲�(t菕ng);鏁�(sh霉)鎿�(j霉)搴�;鎳夌敤;缍;鍎�(y艒u)鍖� 銆€銆€娣卞湷鍦伴惖AFC绯荤当(t菕ng)鏄互闈炴帴瑙稿紡IC鍗＄偤杌婄エ浠嬭唱(zh矛)锛岄噰鐢∣racle鏁�(sh霉)鎿�(j霉)搴钩鑷虹殑鑷嫊鍞绁ㄧ郴绲�(t菕ng)銆傝┎绯荤当(t菕ng)鑳藉瀹屾垚鍦伴惖閬嬬嚐鐨勮粖绁ㄥ埗浣溿€佸敭绁�銆佹绁�銆佽病鍕�銆佺当(t菕ng)瑷�銆佸垎鏋愮瓑鍏ㄩ亷绋嬫キ(y猫)鍕欑殑瀵︽檪绠＄悊宸ヤ綔銆傞憭浜嶢FC绯荤当(t菕ng)鑸囧湴閻甸亱鐕熺殑璨″嫏鏀剁泭瀵嗗垏鐩搁棞(gu膩n)锛屽洜姝�锛孉FC绯荤当(t菕ng)鏁�(sh霉)鎿�(j霉)鐨勫畨鍏ㄦ€�銆佸鏅傛€с€佸畬鏁存€х瓑闇€瑕佸緱鍒拌冻澶犵殑閲嶈銆� 1 姒傛硜 銆€銆€1.1鏁�(sh霉)鎿�(j霉)搴伕鍨� 銆€銆€娣卞湷鍦伴惖AFC绯荤当(t菕ng)寰炶ō瑷堜箣鍒濆氨鍏呭垎鑰冩叜鍒颁簡AFC绯荤当(t菕ng)鏁�(sh霉)鎿�(j霉)閲�銆佹€ц兘瑕佹眰銆佸彲闈犳€ц姹備互鍙婃€у児姣旂瓑鍚勬柟闈㈠洜绱狅紝閬告搰浜嗗ぇ鍨嬫暩(sh霉)鎿�(j霉)搴鐞嗙郴绲�(t菕ng)Oracle9. i銆傚悓鏅傜偤淇濊瓑AFC鏁�(sh霉)鎿�(j霉)鐨勫畬鏁存€у拰涓€鑷存€�锛屼腑蹇冨拰杌婄珯閲囩敤涓€鑷寸殑鏁�(sh霉)鎿�(j霉)搴郴绲�(t菕ng)銆傚緸澧炲姞绁ㄥ嫏鏀剁泭鍜屾彁楂樻湇鍕欒唱(zh矛)閲忕殑瑙掑害锛屾繁鍦冲湴閻礎FC绠＄悊涓績寰炲鏂归潰閲囧彇鎺柦锛岀⒑淇濇暩(sh霉)鎿�(j霉)搴郴绲�(t菕ng)瀹夊叏銆佸彲闈犻亱琛�锛屽苟缍�(j墨ng)姝蜂簡澶氭澶у娴佽€冮銆傚埌鐩墠鐐烘锛屾繁鍦冲湴閻礎FC绯荤当(t菕ng)鏁�(sh霉)鎿�(j霉)搴竴鐩翠繚鎸佺┅(w臎n)瀹氶亱琛�銆� 銆€銆€1.2鏁�(sh霉)鎿�(j霉)搴ō瑷� 銆€銆€寰炴キ(y猫)鍕欏拰绠＄悊瑙掑害渚嗛€茶鏁�(sh霉)鎿�(j霉)搴ō瑷�锛屽皣鏁�(sh霉)鎿�(j霉)鎸夊叾鍏�(n猫i)瀹�銆佺敤閫斿拰妤�(y猫)鍕欒寖鍦嶄笉鍚屽垎椤�銆傚緸鏁�(sh霉)鎿�(j霉)鐨勪竴鑷存€т締瑾�锛岃粖绔欏拰涓績瑕佷繚鎸佷竴妯ｇ殑鏁�(sh霉)鎿�(j霉)瀹氱京椤炲瀷銆傛繁鍦冲湴閻电殑鏁�(sh霉)鎿�(j霉)椤炲瀷鍏烽珨鍒嗙偤涓嬪垪骞鹃銆� 銆€銆€浜ゆ槗淇℃伅椤�:浜ゆ槗妤�(y猫)鍕欒檿鐞嗙敘(ch菐n)鐢熺殑鍚勭ó淇℃伅銆� 銆€銆€绯荤当(t菕ng)缍椤�:杓斿姪绯荤当(t菕ng)閬嬭鍜岀董璀风殑鍚勭ó鍙冩暩(sh霉)淇℃伅銆佸熀绀庨厤缃俊鎭拰鐢ㄤ簬闈炴キ(y猫)鍕欓鎺у埗绠＄悊鐨勪俊鎭�銆� 銆€銆€閬嬬嚐绠＄悊椤�:瑷倷绠＄悊銆侀亱鐕熺洠(ji膩n)鎺�銆侀亱鐕熺董璀风瓑鏂归潰鐨勪俊鎭€� 銆€銆€绁ㄥ嫏绠＄悊椤�:绁ㄥ崱椤炲瀷銆佺エ鍍硅ō瀹氥€侀亱鐕熼粸绠＄悊绛夋柟闈㈢殑淇℃伅銆� 銆€銆€绲�(ji茅)绠楃鐞嗛:鎻忚堪绲�(ji茅)绠楀尟绺藉拰甯虫埗铏曠悊鏂归潰鐨勪俊鎭�銆� 銆€銆€搴瓨绠＄悊椤�:杌婄エ搴瓨瑾�(di脿o)浜�銆佽(di脿o)鍑�锛岀エ鍗″垎椤炵瓑鏂归潰鐨勪俊鎭�銆� 2 鏁�(sh霉)鎿�(j霉)搴殑缍 銆€銆€鐐虹⒑淇濇繁鍦冲湴閻礎FC绯荤当(t菕ng)闀锋湡銆佺┅(w臎n)瀹氥€侀珮鏁堢殑閬嬩綔锛屾暩(sh霉)鎿�(j霉)搴殑缍鏄竴闋呬緥琛岀殑銆佷笉鍙己灏戠殑宸ヤ綔銆傜偤姝�锛岄渶瑕侀€氶亷鏃ュ父鐩�(ji膩n)鎺�銆佹棩甯哥董璀�銆佸倷浠界瓑鐠�(hu谩n)绡€(ji茅)淇濊瓑AFC绯荤当(t菕ng)鏁�(sh霉)鎿�(j霉)搴檿鍦ㄨ壇濂介亱浣滅媭鎱�(t脿i)涔嬩笅銆� 銆€銆€2.1鏃ュ父鐩�(ji膩n)鎺� 銆€?銆�?锛夐璀夋暩(sh霉)鎿�(j霉)搴強閫ｉ€氭€�銆傚畾鏅傚皪鏁�(sh霉)鎿�(j霉)搴殑閫ｆ帴鎯呮硜閫茶妾㈡煡锛屾煡鐪嬭垏鏁�(sh霉)鎿�(j霉)搴缓绔嬬殑鏈冭┍鏁�(sh霉)鐩槸涓嶆槸姝ｅ父锛屽鏋滃缓绔嬩簡閬庡鐨勯€ｆ帴锛屾渻娑堣€楁暩(sh霉)鎿�(j霉)搴殑璩囨簮銆傚悓鏅�锛屽皪涓€浜涒€滄帥姝烩€濈殑閫ｆ帴锛屽墖闇€瑕佹墜宸ラ€茶娓呯悊銆� 銆€?銆�?锛夋煡鐪嬭鍛婃棩蹇�銆傛瘡澶╅璀夋暩(sh霉)鎿�(j霉)搴鍦ㄩ亱琛宭(w猫i)istener骞跺彲浠ヨí鍟忔噳鐢ㄧ▼搴忓悗锛屽氨鎳夎┎闁嬪妾㈡煡鏁�(sh霉)鎿�(j霉)搴棩蹇楋紙alert .log 锛�锛屽湪鏌ョ湅alert.log鐨勫収(n猫i)瀹规檪锛屾枃浠朵腑鐨勮ū澶氫俊鎭兘鏄父瑕�(gu墨)鐨�锛屾瘮濡傛暩(sh霉)鎿�(j霉)搴殑鍟熷嫊銆佹鏌ラ粸鍜屾棩蹇楁枃浠剁殑闁嬮棞(gu膩n)銆傞渶鐩�(ji膩n)鎺ч€欎簺娑堟伅鍑虹従(xi脿n)鐨勯牷鐜�锛岄璀夋暩(sh霉)鎿�(j霉)搴槸鍚︽寜鐓цō瑷堟柟妗堥亱琛�銆傛甯告儏娉佷笅锛屾暩(sh霉)鎿�(j霉)搴湪alert.lo g涓矑鏈夊ぇ閲忕殑閷锛屽鏋滅湅鍒伴浼糘RA-1031閫欐ǎ鐨勯尟瑾ゆ秷鎭�锛屽氨闇€瑕佸竟搴曞湴瑾�(di脿o)鏌�. 銆€銆€2.2鏃ュ父缍 銆€?銆�?锛夎〃绌洪枔鐨勭鐞�銆傞€氶亷Oracle鏁�(sh霉)鎿�(j霉)搴彁渚涚殑Oracle En-terprise Manager Console锛屾鏌ユ暩(sh霉)鎿�(j霉)搴〃绌洪枔鐨勪娇鐢ㄦ儏娉�銆傚寘鎷壍(chu脿ng)寤鸿〃绌洪枔锛屽悜琛ㄧ┖闁撲腑娣诲姞鏁�(sh霉)鎿�(j霉)鏂囦欢銆傞毃钁楁暩(sh霉)鎿�(j霉)琛ㄥ拰绱㈠紩鐨勫闀风洠(ji膩n)鎺х┖闁戠┖闁�锛岀暥琛ㄧ┖闁撳埄鐢ㄧ巼瓒呴亷85%浠ヤ笂鏅�锛岄€氶亷鎿村厖鏁�(sh霉)鎿�(j霉)鏂囦欢鐨勬柟娉曟摯澶ф暩(sh霉)鎿�(j霉)搴浉鎳夌殑琛ㄧ┖闁�銆� 銆€?銆�?锛夎〃绌洪枔绌洪枒濉婄殑缍銆傛暩(sh霉)鎿�(j霉)搴亱琛屼簡涓€娈垫檪闁撳悗锛岀敱浜庝笉鏂峰湴鍦ㄨ〃绌洪枔涓婂壍(chu脿ng)寤哄拰鍒櫎灏嶈薄锛屾渻鍦ㄨ〃绌洪枔涓婄敘(ch菐n)鐢熷ぇ閲忕殑纰庣墖锛岄€欐檪瑕佹鏌ヨ〃绌洪枔鐨勭鐗囧拰鍙敤绌洪枔鎯呮硜锛屾焙瀹氭槸鍚﹁灏嶇鐗囬€茶鏁寸悊鎴栫偤琛ㄧ┖闁撳鍔犳暩(sh霉)鎿�(j霉)鏂囦欢銆� 銆€?銆�?锛夊叡浜睜鐨勭董璀�銆傞€氶亷Oracle鏁�(sh霉)鎿�(j霉)搴彁渚涚殑Oracle En-terprise Manager Console锛屾鏌ュ彲鐢ㄥ叡浜睜鐨勪娇鐢ㄦ儏娉�锛岀暥鍙敤鐧惧垎姣斿皬浜�6%锛屾キ(y猫)鍕欒檿鐞嗛€熷害鏈冭畩鎱�锛屽鍠▼绁ㄥ垵濮嬪寲姗熺殑铏曠悊閫熷害鏈冧笅闄�锛岄€欐檪闇€瑕侀€氶亷鍒锋柊鍏变韩姹犵殑鏂规硶鎻愰珮鍙敤鐜�銆� 銆€銆€2.3鏁�(sh霉)鎿�(j霉)搴倷浠� 銆€銆€鐐虹⒑淇滱FC绯荤当(t菕ng)鏁�(sh霉)鎿�(j霉)瀹屾暣锛屾繁鍦冲湴閻靛埗瀹氫簡鐩告噳鐨勫倷浠界瓥鐣�锛屽毚鏍煎仛濂芥暩(sh霉)鎿�(j霉)搴倷浠藉伐浣�銆傚倷浠界殑鏁�(sh霉)鎿�(j霉)鐐轰腑蹇冩暩(sh霉)鎿�(j霉)搴俊鎭€佷腑蹇僐MAN鏁�(sh霉)鎿�(j霉)搴俊鎭�銆乀SM鏁�(sh霉)鎿�(j霉)搴俊鎭�銆佽粖绔欐暩(sh霉)鎿�(j霉)搴俊鎭�銆傚倷浠戒粙璩�(zh矛)鏈夋槑纰烘璀橈紝鍒嗛淇濈銆� 銆€銆€涓績鏁�(sh霉)鎿�(j霉)搴噰鐢═ivoli杌熶欢鑷嫊鍌欎唤锛屽倷浠戒粙璩�(zh矛)鐐篒BM LTO纾佸付锛屽倷浠藉収(n猫i)瀹圭偤鍏ㄥ倷浠�銆佸閲忓倷浠藉拰姝告獢鏃ュ織鍌欎唤锛屽叏鍌欎唤姣忓懆閫茶涓€娆�锛屽閲忓倷浠藉拰姝告獢鏃ュ織鍌欎唤姣忓ぉ閫茶1娆°€� 銆€銆€涓績RMAN鏁�(sh霉)鎿�(j霉)搴噰鐢║NIX鑵虫湰鑷嫊鍌欎唤锛屼腑蹇僒SM鏁�(sh霉)鎿�(j霉)搴噰鐢═ivoli杌熶欢鑷嫊鍌欎唤锛屽皣涓€鍛ㄧ殑鍌欎唤鏂囦欢鍒婚寗鑷冲厜鐩や繚瀛樸€� 銆€銆€杌婄珯鏁�(sh霉)鎿�(j霉)搴倷浠介噰鐢∣RACLE閭忚集鍌欎唤锛堥€氶亷EXP鍛戒护锛�锛屽湪杌婄珯鏈嶅嫏鍣ㄥ拰杌婄珯鐩�(ji膩n)鎺ф涓婇洐姗熶簰鍌�銆� 3 鏁�(sh霉)鎿�(j霉)搴殑鍎�(y艒u)鍖� 銆€銆€Oracle鏁�(sh霉)鎿�(j霉)搴殑鎬ц兘鍎�(y艒u)鍖栦竴鐩存槸鏁�(sh霉)鎿�(j霉)搴鐞嗕腑鐨勯噸瑕佺挵(hu谩n)绡€(ji茅)锛屼篃鏄渶寰╅洔鐨勫収(n猫i)瀹逛箣涓€銆傚緸鏁�(sh霉)鎿�(j霉)搴妧琛�(sh霉)瑙掑害鑰岃█锛屾暩(sh霉)鎿�(j霉)搴缓绔嬭捣渚嗗悗锛屼富瑕佺殑宸ヤ綔鍏�(n猫i)瀹规湁:鍎�(y艒u)鍖�銆佹仮寰╁拰鍌欎唤銆傝瀵︾従(xi脿n)楂樻晥鍦伴亱琛孫racle鏁�(sh霉)鎿�(j霉)搴�锛屽劒(y艒u)鍖栨€ц兘鑷冲皯鍗犱簡70%鐨勫伐浣滈噺锛屼富瑕佸寘鎷劒(y艒u)鍖栧伐鍏枫€佸瓨鍎插劒(y艒u)鍖�銆佸収(n猫i)瀛樿(di脿o)鏁�銆丼QL鍎�(y艒u)鍖栫瓑澶氬€嬫柟闈�銆備富瑕佸伐浣滃寘鎷涓嬪咕鍊嬮儴鍒嗐€� 銆€?銆�?锛夎(di脿o)鏁存暩(sh霉)鎿�(j霉)绲�(ji茅)妲�(g貌u)鐨勮ō瑷�銆備富瑕侀嚌灏峅racle鏁�(sh霉)鎿�(j霉)搴殑鍒嗗崁(q奴)鍔熻兘锛屽皪浜庣稉(j墨ng)甯歌í鍟忕殑鏁�(sh霉)鎿�(j霉)搴〃寤虹珛绱㈠紩绛�銆傚湪鏁�(sh霉)鎿�(j霉)搴殑琛ㄧ┖闁撳妰鍒嗕笂锛屾瘡鍊嬫湀鍗犵敤涓€鍊嬬崹绔嬬殑鍒嗗崁(q奴)锛屾瘡鍊嬪垎鍗€(q奴)鍗犵敤涓€鍊嬭〃绌洪枔锛屼竴鍊嬪垎鍗€(q奴)鍙堢敱澶氬€嬫暩(sh霉)鎿�(j霉)鏂囦欢绲勬垚锛屽皪绱㈠紩鐨勫缓绔嬩篃鏄寜鏈堜締鍒嗛厤鐨�銆� 銆€銆€锛�2锛夎(di脿o)鏁存噳鐢ㄧ▼搴忕祼(ji茅)妲�(g貌u)瑷▓銆傞€欎竴閮ㄥ垎涔熸槸鍦ㄦ繁鍦冲湴閻礎FC鎳夌敤绯荤当(t菕ng)瑷▓涔嬪墠瀹屾垚锛屾繁鍦冲湴閻礎FC鎳夌敤绯荤当(t菕ng)閲囩敤Client/Server楂旂郴绲�(ji茅)妲�(g貌u)锛岀敱鏁�(sh霉)鎿�(j霉)搴噳鐢ㄧ▼搴忓揩閫熼枊鐧�(f膩)宸ュ叿PowerBulider8瑷▓闁嬬櫦(f膩)瀹屾垚銆� 銆€銆€锛�3锛夎(di脿o)鏁存暩(sh霉)鎿�(j霉)搴玈QL瑾炲彞銆傛垜鍊戜娇鐢∣racle瑾炲彞鍎�(y艒u)鍖栧櫒锛圤racle Optimizer锛夊拰琛岄帠绠＄悊鍣紙 Row-level Manager锛変締瑾�(di脿o)鏁村劒(y艒u)鍖朣QL瑾炲彞銆� 銆€?銆�?锛夎(di脿o)鏁碅FC涓ぎ涓绘鍏�(n猫i)瀛樺垎閰�銆傚収(n猫i)瀛樺垎閰嶆槸鍦ㄤ富姗熼亱琛岄亷绋嬩腑鍎�(y艒u)鍖栭厤缃殑锛屼富姗熸牴鎿�(j霉)鏁�(sh霉)鎿�(j霉)搴亱琛岀媭娉佽(di脿o)鏁存暩(sh霉)鎿�(j霉)搴郴绲�(t菕ng)鍏ㄥ眬鍗€(q奴)锛圫GA锛夌殑鏁�(sh霉)鎿�(j霉)绶╂矕鍗€(q奴)銆佹棩蹇楃珐娌栧崁(q奴)鍜屽叡浜睜鐨勫ぇ灏�锛岄倓鍙互瑾�(di脿o)鏁寸▼搴忓叏灞€鍗€(q奴)锛圥GA锛夌殑澶у皬銆傜郴绲�(t菕ng)鍏ㄥ眬鍗€(q奴)锛圫GA锛夋槸Oracle鏁�(sh霉)鎿�(j霉)搴殑蹇冭嚐锛岄渶瑕佹敞鎰忕殑鏄�锛孲GA鍗€(q奴)涓嶆槸瓒婂ぇ瓒婂ソ锛孲GA鍗€(q奴)閬庡ぇ鏈冨崰鐢ㄦ搷浣滅郴绲�(t菕ng)浣跨敤鐨勫収(n猫i)瀛樿€屽紩璧疯櫅鎿収(n猫i)瀛樼殑闋侀潰浜ゆ彌锛岄€欐ǎ鍙嶈€屾渻闄嶄綆绯荤当(t菕ng)鎬ц兘銆� 銆€?銆�?锛夎(di脿o)鏁寸‖鐩/O銆傚皣绲勬垚鍚屼竴鍊嬭〃绌洪枔鐨勬暩(sh霉)鎿�(j霉)鏂囦欢鏀惧湪涓嶅悓鐨勭‖鐩や笂锛屽仛鍒扮‖鐩や箣闁揑/O璨犺級鍧囪　銆� 銆€?銆�?锛夎(di脿o)鏁存搷浣滅郴绲�(t菕ng)鍙冩暩(sh霉).Oracle鏁�(sh霉)鎿�(j霉)搴湇鍕欏櫒鏄暣鍊嬬郴绲�(t菕ng)鐨勬牳蹇�锛屽畠鐨勬€ц兘楂樹綆鐩存帴褰遍熆鏁村€嬬郴绲�(t菕ng)鐨勬€ц兘銆傛繁鍦冲湴閻礎FC绯荤当(t菕ng)涓绘閬嬭鍦║nix鎿嶄綔绯荤当(t菕ng)涔嬩笂锛岀洝鍙兘浣縊racle浣跨敤璩囨簮鏈€澶у寲锛岄渶瑾�(di脿o)鏁碪nix鏁�(sh霉)鎿�(j霉)绶╂矕姹犵殑澶у皬銆佹瘡鍊嬮€茬▼鎵€鑳戒娇鐢ㄧ殑鍏�(n猫i)瀛樺ぇ灏忕瓑鍙冩暩(sh霉)銆� 銆€銆€娣卞湷鍦伴惖AFC绯荤当(t菕ng)鏁�(sh霉)鎿�(j霉)搴倷浠界鐞嗘柟闈�锛岄櫎浜嗗仛鏃ュ父缍鍌欎唤澶栵紝鍦ㄦ暩(sh霉)鎿�(j霉)搴亱浣滈亷绋嬩腑锛屾垜鍊戦倓閫氶亷瑾�(di脿o)鏁村垎鍗€(q奴)锛屽皪缍�(j墨ng)甯歌í鍟忕殑鏁�(sh霉)鎿�(j霉)搴〃寤虹珛绱㈠紩锛屼互鍙婂皪妤�(y猫)鍕欐祦绋嬪畬鎴愬悗涓嶅啀璁婂嫊鐨勬暩(sh霉)鎿�(j霉)閲囩敤姝告獢鐨勬柟娉曚締鍎�(y艒u)鍖栨暩(sh霉)鎿�(j霉)搴€� 4 鏁�(sh霉)鎿�(j霉)搴噳鐢ㄦ帰绱� 銆€?銆�?锛夋噳鐢ㄦ暩(sh霉)鎿�(j霉)搴祼(ji茅)妲�(g貌u)瑷▓鎳夊厖鍒嗚€冩叜閫氱敤鎬у拰鏄撶敤鎬�銆傝憲鐪间簬娣卞湷杌岄亾浜ら€氱櫦(f膩)灞曚竴楂斿寲鐨勯暦閬犵溂鍏�锛屾繁鍦冲湴閻礎FC绯荤当(t菕ng)鏁�(sh霉)鎿�(j霉)搴緸瑷▓涔嬪垵锛屽咕鍊嬪熀鏈殑鏁�(sh霉)鎿�(j霉)搴〃灏遍噰鐢ㄥ拰娣卞湷閫氬叕鍙革紙鐝�(xi脿n)鐐衡€滄繁鍦抽€氱祼(ji茅)绠椾腑蹇冣€濓紝灏囩櫦(f膩)灞曠偤娣卞湷鍩庡競鈥滀竴鍗￠€氣€濈殑娓呭垎鍜岀祼(ji茅)绠椾腑蹇冿級鏁�(sh霉)鎿�(j霉)搴浉鍚岀殑鏁�(sh霉)鎿�(j霉)椤炲瀷鍔冨垎鍜岃〃鐨勮ō瑷�銆傚氨鐣舵檪鐨勬儏娉佽€岃█锛屾豢瓒充簡鍦伴惖鑸団€滄繁鍦抽€氣€濇暩(sh霉)鎿�(j霉)浜掗€氬拰绲�(ji茅)绠楃殑鍩烘湰瑕佹眰锛岀偤瀵︾従(xi脿n)娣卞湷鈥滀竴鍗￠€氣€濆瀹氫簡鏍瑰熀?锛孎(xi脿n)鍦�锛屾繁鍦冲湴閻礎FC绯荤当(t菕ng)鐨勬暩(sh霉)鎿�(j霉)宸茶兘澶犻€氶亷鍜屸€滄繁鍦抽€氣€濋€ｆ帴鐨勫箑涓辜灏堢窔閫茶鏁�(sh霉)鎿�(j霉)浜ゆ彌锛岀偤鈥滄繁鍦抽€氣€濆湪澶氬閬嬬嚐鍟嗕箣闁撴竻鍒�銆佺祼(ji茅)绠楁彁渚涙暩(sh霉)鎿�(j霉)淇濊瓑銆� 銆€?銆�?锛夊緸鏁�(sh霉)鎿�(j霉)搴郴绲�(t菕ng)涓绘鐨勫畨鍏ㄥ伐浣滆搴�锛屾彁楂樻暩(sh霉)鎿�(j霉)搴殑瀹夊叏鎬у拰瀹圭伣鎬�銆侫FC绯荤当(t菕ng)鐨勨€滅敓鍛界窔鈥濆氨鏄暩(sh霉)鎿�(j霉)搴殑瀹夊叏鍜屾暩(sh霉)鎿�(j霉)鐨勫畬鏁�銆傛繁鍦冲湴閻礎FC绯荤当(t菕ng)闄や簡鍋氬ソ鏁�(sh霉)鎿�(j霉)搴喎銆佺啽鍌欎唤澶�锛屽湪淇濊瓑鏁�(sh霉)鎿�(j霉)搴郴绲�(t菕ng)涓绘瀹夊叏閬嬩綔锛屽鐏藉倷浠芥柟闈�锛屾垜鍊戦噰鐢�2鑷篒BM P650灏忓瀷姗熷仛涓绘浜掑倷锛屼互鍙奟AIDS鍐椾綑纾佺洡闄ｅ垪楂旂郴銆傞櫎姝や箣澶�锛岄倓鏂板1鑷篒BM P520灏忓瀷姗燂紝灏堥杸鐢ㄥ仛2鑷篈FC绯荤当(t菕ng)涓绘鐨勫倷鐢ㄦ銆傚湪闈炲父蹇呰涔嬫檪锛岄€欒嚭灏忓瀷姗熷彲闋傛浛AFC绯荤当(t菕ng)涓绘宸ヤ綔銆� 銆€?銆�?锛夊皪琛ㄥ拰绱㈠紩鍋氬畾鏈熺殑缍鍎�(y艒u)鍖�锛屽ぇ琛ㄥ缓绔嬪垎鍗€(q奴)鍔熻兘銆傚皣澶ц〃鐨勬鍙叉暩(sh霉)鎿�(j霉)鎸夊勾浠芥妾�锛屼互楱板嚭瓒冲鐨勭┖闁撲緵鏁�(sh霉)鎿�(j霉)搴湇鍕欏櫒閫ｇ簩(x霉)浣跨敤?锛孎(xi脿n)鍦�锛屾垜鍊戝凡鎴愬姛瀹屾垚浜�2005骞存暩(sh霉)鎿�(j霉)鐨勬妾斿伐浣�锛屽皣娣卞湷鍦伴惖AFC绯荤当(t菕ng)2005骞村叏骞寸殑鏁�(sh霉)鎿�(j霉)灏庡嚭鍒癆FC涓绘鐨勫倷姗熶箣涓�锛屼娇AFC绯荤当(t菕ng)涓绘涓婄殑纭洡绌洪枔寰椾互閲嶇敤锛屾彁鍗囦簡涓绘鍜屾暩(sh霉)鎿�(j霉)搴郴绲�(t菕ng)鎬ц兘銆� 銆€銆€鐣舵暩(sh霉)鎿�(j霉)搴缓绔嬬储寮曞悗锛屽鍔犳暩(sh霉)鎿�(j霉)鏅�锛屼篃鏈冨鍔犵储寮曟暩(sh霉)鎿�(j霉)锛屼絾鏄埅闄ゆ暩(sh霉)鎿�(j霉)鏅�锛屾暩(sh霉)鎿�(j霉)搴笉鏈冭嚜鍕曞埅闄よ┎瑷橀寗鐨勭储寮曟暩(sh霉)鎿�(j霉)銆傛墍浠ュ皪浜庢彃浜哄埅闄ゆ瘮杓冮牷绻佺殑琛紝濡傛灉浣跨敤涓€娈垫檪闁撳悗锛岀储寮曟暩(sh霉)鎿�(j霉)涓瓨鍦ㄨ憲寰堝鐒℃晥鐨勬暩(sh霉)鎿�(j霉)锛岄€欐ǎ鏈冨奖闊跨郴绲�(t菕ng)鐨勬€ц兘銆傚皪浜庨€欑ó椤炲瀷鐨勮〃锛屾垜鍊戣瀹氭湡閲嶅缓绱㈠紩锛屾彁楂樼储寮曠殑鍒╃敤鐜�銆� 銆€銆€灏嶄氦鏄撴暩(sh霉)鎿�(j霉)銆佺储寮曠瓑澶ц〃寤虹珛鍒嗗崁(q奴)琛�锛屾寜鏈堥€茶鏁�(sh霉)鎿�(j霉)鍔冨垎銆傛瘡鍊嬫湀鏁�(sh霉)鎿�(j霉)搴嚜鍕曠敓鎴愬苟瑾�(di脿o)鐢ㄤ竴鍊嬪垎鍗€(q奴)琛�锛屾暣鍊嬫湀鐨勬暩(sh霉)鎿�(j霉)鍗犵敤鐛ㄧ珛鐨勫垎鍗€(q奴)琛�锛岄€欐ǎ寰炲劒(y艒u)鍖栨暩(sh霉)鎿�(j霉)搴祼(ji茅)妲�(g貌u)銆佹彁楂樻暩(sh霉)鎿�(j霉)搴í鍟忛€熷害銆佷究浜庣鐞嗐€佹柟渚跨董璀风瓑瑙掑害渚嗙湅閮芥槸鍙湀鍙粸鐨�銆� 銆€?銆�?锛夊厖鍒嗗埄鐢ㄦ暩(sh霉)鎿�(j霉)搴叿鏈夌殑楂樼礆鍔熻兘锛屽Oracle鐨勬暩(sh霉)鎿�(j霉)搴張鎺ャ€佸悓缇╄銆侀珮绱氬京鍒剁瓑銆傚湪Oracle鏁�(sh霉)鎿�(j霉)搴噳鐢ㄧ郴绲�(t菕ng)涓紝甯稿父闇€瑕佸湪鍚勫€嬫暩(sh霉)鎿�(j霉)搴箣鍓嶉€茶鏁�(sh霉)鎿�(j霉)鐨勫偝杓稿拰鍚屾锛屾湁鏅備篃闇€瑕佸皪鏌愪簺琛ㄧ殑鏁�(sh霉)鎿�(j霉)閫茶闆嗕腑绠＄悊銆傞€欐ǎ鎴戝€戝氨鍙互鍏呭垎鍒╃敤鏁�(sh霉)鎿�(j霉)搴殑涓€浜涘姛鑳�銆傚鏋滈渶瑕佹湇鍕欏櫒闁撳悓姝ユ暩(sh霉)鎿�(j霉)鏅�锛屽彲浠ュ埄鐢ㄦ暩(sh霉)鎿�(j霉)搴殑楂樼礆寰╁埗鍔熻兘銆傚鏋滈渶瑕佸皣鏌愪簺琛ㄩ€茶闆嗕腑绠＄悊锛屽墖鍙互浣跨敤鏁�(sh霉)鎿�(j霉)搴€ｆ帴鍜屽悓缇╄锛屽皣琛ㄥ瓨鍎插埌鏌愪竴鏁�(sh霉)鎿�(j霉)搴�锛屽叾浣欐暩(sh霉)鎿�(j霉)搴埄鐢ㄥ悓缇╄閬犵▼瑷晱鍒楄〃銆� 銆€?銆�?锛夊畾鏈熷垎鏋愭暩(sh霉)鎿�(j霉)搴矤鑽�锛屽劒(y艒u)鍖栨秷鑰楃郴绲�(t菕ng)璩囨簮澶х殑SQL瑾炲彞銆傞毃钁楁繁鍦冲湴閻靛娴侀噺鐨勪笉鏂峰澶�锛屾暩(sh霉)鎿�(j霉)搴暩(sh霉)鎿�(j霉)閲忎篃鍚屾瘮澧炲ぇ锛屾瘡澶╂暩(sh霉)鎿�(j霉)搴柊澧炶繎46钀瓎鏁�(sh霉)鎿�(j霉)锛屾暩(sh霉)鎿�(j霉)搴殑璨犺嵎澧炲姞锛屾暩(sh霉)鎿�(j霉)搴郴绲�(t菕ng)鐨勬€ц兘鍟忛灏辫秺渚嗚秺绐佸嚭銆傜偤姝わ紝鎴戝€戝垎鏋愪簡鏁�(sh霉)鎿�(j霉)搴殑璨犺嵎鎯呮硜锛岀櫦(f膩)鐝�(xi脿n)鐡堕牳鍑虹従(xi脿n)鍦ㄧ郴绲�(t菕ng)I/O涓�锛岃€屽皪绯荤当(t菕ng)I/O鈥滆并鐛烩€欐渶澶х殑鐣跺爆SQL瑾炲彞銆傛垜鍊戝皪涓€浜涙€ц兘鐩稿皪浣庝笅銆佹秷鑰楃郴绲�(t菕ng)璩囨簮澶х殑SQL瑾炲彞浣滃劒(y艒u)鍖栬(di脿o)鏁�锛屾瑠(qu谩n)琛￠熆鎳夋檪闁撳拰鍚炲悙閲忎箣闁撶殑闂�(gu膩n)绯�锛岀洝鍙兘娓涘皯纾佺洡鐛插彇鎵€闇€瑕佹暩(sh霉)鎿�(j霉)鐨勬檪闁�锛岄仈鍒颁簡闄嶄綆绯荤当(t菕ng)I/O鐨勭洰鐨勩€� 銆€?銆�?锛夊皪浜庡畨瑁漅AC鐨勬暩(sh霉)鎿�(j霉)搴郴绲�(t菕ng)锛屾噳鍏呭垎鍒╃敤璨犺級鍧囪　鍔熻兘銆傛繁鍦冲湴閻典竴鏈熺殑18鍊嬭粖绔欒▓绠楁绯荤当(t菕ng)閮藉畨瑁濇湁Oracle鏈嶅嫏鍣ㄧ銆傚湪閫欎簺鏈嶅嫏鍣ㄤ笂锛屽鏋滀笉閰嶇疆RAC浣跨敤璨犺級鍧囪　锛屽氨鏈夊彲鑳戒娇鏌愯嚭鏈嶅嫏鍣ㄨ檿浜庣箒蹇欑媭鎱�(t脿i)锛岃€屽彟涓€鑷哄墖涓€鐩村湪绌洪枒涓�銆傞€欐ǎ涓嶄絾褰遍熆绯荤当(t菕ng)鎬ц兘锛岃€屼笖涔熸槸绯荤当(t菕ng)瀹夊叏鐨勪竴鍊嬮毐鎮�銆傛垜鍊戦€氶亷RAC閰嶇疆鏈嶅嫏鍣ㄨ嚜鍕曚娇鐢ㄨ矤杓夊潎琛★紝渚嗚В姹烘湇鍕欏櫒闁撳繖鑸囦笉蹇欑殑鍟忛銆傚彟澶�锛屽皪浜庢煇浜涘€嬪垾鐨勯€ｆ帴涔熷彲浠ユ墜宸ユ寚瀹氫娇鐢ㄧ殑鏈嶅嫏鍣�銆� 5 绲�(ji茅)鏉熻獮 銆€銆€寰炴繁鍦冲湴閻甸枊閫氬墠AFC绯荤当(t菕ng)鏁�(sh霉)鎿�(j霉)搴姇浜轰娇鐢紝鍒扮従(xi脿n)鍦ㄨ€愬勾澶氱殑鏅傞枔閲�锛孉FC绯荤当(t菕ng)淇℃伅绠＄悊閮ㄩ杸娣卞叆鍒嗘瀽AFC绯荤当(t菕ng)鐨勫闅涢亱琛屾儏娉佸拰鐗归粸锛屽缓绔嬪拰鍋ュ叏瑕�(gu墨)绔犲埗搴﹀拰寮峰寲鍩�(zh铆)琛屽姏搴�锛岀附绲�(ji茅)鍑轰竴濂楄涔嬫湁鏁堢殑鏁�(sh霉)鎿�(j霉)搴噳鐢ㄥ拰鍎�(y艒u)鍖栫殑杈︽硶锛孉FC绯荤当(t菕ng)鏁�(sh霉)鎿�(j霉)搴郴绲�(t菕ng)涓€鐩寸┅(w臎n)瀹氶亱琛�锛屼繚鎸佲€滈浂鈥濆畷姗熺殑瑷橀寗銆� 鍙冭€冩枃鐛� 銆€銆€1.绨＄厜.娣卞窛鍦伴惖鏅鸿兘鏀惰不鎵跨当(t菕ng)鍦嬬敘(ch菐n)鍖栧壍(chu脿ng)鏂�锛岀従(xi脿n)浠ｅ煄甯傝粺閬撲氦閫氾紝2005 锛�5锛� 銆€銆€2.钖╁斧鐓�.鏁�(sh霉)鎿�(j霉)搴郴绲�(t菕ng)妫嶈珫.鍖椾含:楂樼瓑鏁欒偛鍑虹増绀�锛�2000 銆€銆€3.Hector Carcia-Molina, Jeffrey D.,Ullman Jennifer Widom.鏁�(sh霉)鎿�(j霉)搴郴绲�(t菕ng)瀵︾従(xi脿n)锛屽寳浜�:姗熸宸ユキ(y猫)鍑虹増绀�锛�2002 銆€銆€4.鐜嬪€枃锛岄悩瀛愮櫦(f膩)锛屽嫉鐐�.ORACLE鏁�(sh霉)鎿�(j霉)搴ō瑷堝劒(y艒u)鍖栬垏瀵﹁笎.闆昏▕鎶€琛�(sh霉)锛�2001锛�1锛� 銆€銆€5.妤婂痉浠�锛岄Μ鏇夌嚂.澶у瀷鏁�(sh霉)鎿�(j霉)搴劒(y艒u)鍖栬ō瑷堟柟妗�.瑷堢畻姗熺郴绲�(t菕ng)鎳夌敤锛�2001 锛�5锛�