銆銆DM8蹇瑕佸彂甯冧簡锛屾渶杩戞嬁鍒颁簡DM8鐨勬柊鐗规х櫧鐨涔﹀拰鏈鏂版祴璇曠増锛屼笅闈㈠紑濮嬫垜浠鐨凞M8涔嬫梾鍚с
銆銆1. 鍏变韩瀛樺偍闆嗙兢DSC澧炲己
銆銆鏈澶氬彲浠ユ敮鎸8涓鑺傜偣鐨勫叡浜瀛樺偍闆嗙兢锛屾敮鎸佸叡浜瀛樺偍闆嗙兢+鏁版嵁瀹堟姢锛岃繘涓姝ユ彁楂樼郴缁熷彲鐢ㄦэ紝鎻愪緵鍙鏇夸唬Oracle鐨勪袱鍦颁笁涓蹇冭В鍐虫柟妗堛
銆銆2. 鎻愪緵鍒嗗竷寮忔枃浠剁郴缁烡DFS
銆銆DDFS(DM Distributed File System)鏄鍙渚汥M鏁版嵁搴撴湇鍔″櫒浣跨敤鐨勫簳灞傚垎甯冨紡鏂囦欢绯荤粺锛孌DFS鏀鎸佸氬壇鏈鏁版嵁鍐椾綑瀹圭伨锛岄噰鐢ㄤ腑蹇冨寲鍓鏈鎺у埗鍗忚(primary-secondary鍗忚)鍜孮uorum鏈哄埗瀵瑰壇鏈杩涜岀＄悊锛屽彲蹇閫熻繘琛屼富鍓鏈闂寸殑鍒囨崲锛岃兘澶熸湁鏁堝湴澶勭悊绯荤粺涓鐨勫悇绉嶆晠闅滃拰寮傚父鎯呭喌銆
銆銆3. 鏀鎸佸垎甯冨紡寮规ц＄畻闆嗙兢
銆銆褰撳崟涓杈炬ⅵ鏁版嵁搴撶郴缁熷湪SQL鎵ц岃繃绋嬩腑鍙戠幇褰撳墠鎿嶄綔闇瑕佸ぇ閲忕殑鍐呭瓨鍜孋PU璧勬簮锛屼笖褰撳墠灞鍩熺綉涓婃湁鍙鍒╃敤鐨勭┖闂睤M鏁版嵁搴撹＄畻璧勬簮鏃讹紝灏卞彲浠ユ妸褰撳墠鐨凷QL鎿嶄綔鎷嗗垎鎴愬氫釜浠诲姟鍜岀浉搴旂殑鏁版嵁鍒嗗彂鍒拌繖浜涘彲浠ュ埄鐢ㄧ殑杈炬ⅵ鏁版嵁搴擄紝骞跺洖鏀惰＄畻缁撴灉鍔犱互鏁村悎锛屼粠鑰屽疄鐜板嶆潅SQL鐨勫脊鎬ц＄畻銆
銆銆4. 鏌ヨ浼樺寲鍣ㄥ炲己
銆銆鏀鎸佸氱淮缁熻′俊鎭锛屽綋鏌ヨ涓娑夊強鐨勫氫釜鍒椾簰鐩稿苟涓嶇嫭绔嬫椂锛屽厑璁哥敤鎴锋寚瀹氶拡瀵瑰氫釜鍒楁敹闆嗗拰璁＄畻缁熻′俊鎭锛屽彲鎻愬崌澶氬垪杩囨护銆佸氬垪杩炴帴鍦烘櫙涓嬬殑浠ｄ环璁＄畻绮惧噯搴︼紝鐢熸垚鏇翠紭鐨勬墽琛岃″垝;鐩稿叧瀛愭煡璇銆佸栬繛鎺ョ瓑鏌ヨ浼樺寲鍙傛暟鏍规嵁搴旂敤鍦烘櫙鑷鍔ㄨ皟鏁达紝鍑忓皯浜哄伐骞查;澶嶆潅琛ㄨ揪寮忕殑浼樺寲;璇鍙ュ潡涓鐨凷QL鐙绔婬INT鏀鎸佺瓑銆
銆銆5. AWR鎶ヨ〃宸ュ叿澧炲己
銆銆DM8瀵笰WR鎶ヨ〃宸ュ叿鐨勫唴閮ㄦ瀯閫犵瓥鐣ヨ繘琛屼簡鏀归狅紝澶у箙鎻愬崌浜咥WR鎶ヨ〃鐨勭敓鎴愭晥鐜囥傚悓鏃剁浉瀵逛簬DM7鐨凙WR鎶ヨ〃宸ュ叿澧炲姞浜嗗氫釜缁熻¤〃鍗曪紝瀹炵幇浜嗗圭郴缁熻繍琛屾儏鍐垫洿鍔犵粏鑷寸殑灞曠幇銆
銆銆6. 瀹夊叏鍔熻兘澧炲己
銆銆杩涗竴姝ュ炲己寮哄埗璁块棶鎺у埗銆佸瓨鍌ㄥ姞瀵嗐佽祫婧愰檺鍒躲佸疄鏃跺¤＄瓑瀹夊叏鍔熻兘銆
銆銆7. JDBC鎺ュ彛澧炲己
銆銆瀵笿DBC鎺ュ彛杩涜屼簡閲嶆柊璁捐″疄鐜帮紝璧勬簮寮閿鏇村皬锛屾ц兘鏇撮珮銆
銆銆8. 楂樼骇鍔熻兘鎵╁睍
銆銆鎵╁睍浜嗗瑰氱骇鍒嗗尯琛ㄧ殑鍔熻兘鏀鎸侊紝鏂板炲瑰垎鍖轰氦鎹銆佸垎鍖洪噸鍛藉悕銆佷慨鏀筁IST鍒嗗尯鑼冨洿鍊笺佸炲姞绾︽潫鍔熻兘鐨勬敮鎸;鐗╁寲瑙嗗浘鏀鎸丱N COMMIT蹇閫熷埛鏂版柟寮忥紝鏀鎸佸祵濂楃墿鍖栬嗗浘锛屾彁鍗囦簡澶嶆潅鐗╁寲瑙嗗浘鐨勫埛鏂版ц兘;鏀鎸侀掑綊CTE琛ㄨ揪寮忋
銆銆9. 绠＄悊宸ュ叿鏀硅繘
銆銆绠＄悊宸ュ叿鎻愪緵浜嗗叏鏂扮殑SQL鍔╂墜鎻愪緵SQL璇娉曟鏌ュ拰SQL杈撳叆鍔╂墜鍔熻兘;SQL璇娉曟鏌ュ姛鑳藉圭敤鎴疯緭鍏ョ殑SQL璇鍙ヨ繘琛屽疄鏃剁殑璇娉曟鏌ワ紝瀹氫綅閿欒鐨凷QL璇娉曘係QL杈撳叆鍔╂墜鑳藉熷圭敤鎴疯緭鍏SQL杩涜屽疄鏃剁殑鏅鸿兘鎻愮ず銆
銆銆10. 杈炬ⅵ鏁版嵁搴撶＄悊鏈嶅姟骞冲彴
銆銆鎻愪緵浜嗗叏鏂扮殑鍩轰簬Web寮鍙戠殑鏁版嵁搴撶＄悊鏈嶅姟骞冲彴(DEM)锛 DEM涓嶄粎鍖呭惈浜嗘岄潰宸ュ叿绯荤粺绠＄悊宸ュ叿(Manager)锛屾暟鎹杩佺Щ宸ュ叿(DTS)锛屾ц兘鐩戣嗗伐鍏(Monitor)鐨勫姛鑳斤紝杩樻彁渚涗簡闆嗙兢閮ㄧ讲(Deploy)鍔熻兘銆佺洃鎺у姛鑳藉拰鍛婅﹀姛鑳姐傜敤鎴烽氳繃闆嗙兢閮ㄧ讲鍔熻兘鍙蹇閫熷拰绠鍗曞湴鍦ㄥ氬彴涓绘満涓婇儴缃睲PP闆嗙兢銆丏MDSC闆嗙兢鍜屾暟鎹瀹堟姢闆嗙兢銆
銆銆DM8鍒濇ヤ綋楠岋細
銆銆DM8鐨勫畨瑁呮ラや笌DM7淇濇寔浜嗙浉鍚岀殑鎿嶄綔浣撻獙锛岃屽叏鏂拌捐＄殑鍥炬爣缁欐垜甯︽潵浜嗕竴浜涙儕鍠滐紝缁欎汉鐒曠劧涓鏂扮殑鎰熻夛紝鏈夊浘鏈夌湡鐩革細
銆銆鍏变韩瀛樺偍闆嗙兢銆佸垎甯冨紡鏂囦欢绯荤粺銆佸脊鎬ц＄畻绛夐珮绾х壒鎬х幆澧冩湁闄愶紝杩欐″氨涓嶇粰澶у跺垎浜浜嗭紝涓嬮潰缁欏ぇ瀹跺垎浜涓浜涙垜鍦ㄥ垵娆″畨瑁呬娇鐢ㄤ腑鍙戠幇鐨勭粏鑺傛ф敼杩涘惂锛
#p#分页标题#e#銆銆DM7鐨勭＄悊宸ュ叿璇娉曟鏌ヤ緷璧栦簬鏈嶅姟鍣锛孌M8杩欏潡鍋氫簡閲嶅ぇ鏀硅繘锛屼笉渚濊禆浜庢湇鍔″櫒鍗冲彲杩涜岃娉曟鏌ャ係QL杈撳叆鍔╂墜鏂归潰DM7涔熶笉鏄寰堢簿纭锛屾湁鏃朵細鏈変竴浜涘崱椤跨殑鎯呭喌鍑虹幇锛岄潪甯告湡寰匘M8鐨勮〃鐜般
銆銆--鎵撳紑DM8绠＄悊宸ュ叿锛屾瀯閫犱袱鏉℃湁璇娉曢敊璇鐨凷QL璇鍙ワ紝鐪嬬湅鏁堟灉銆
銆銆--鏂寮杩炴帴锛屾柊寤轰竴涓绐楀彛锛屾瀯閫犱袱鏉℃湁璇娉曢敊璇鐨凷QL璇鍙ワ紝鑴辨満鐨勬儏鍐典笅鐪嬬湅鏁堟灉銆
銆銆--娴嬭瘯涓涓婼QL鍔╂墜杈呭姪杈撳叆鐨勬儏鍐
銆銆DM8鐨凷QL鍔╂墜2.0鏋滅劧寰堝己澶э紝鍙浠ユ彁渚涜劚鏈虹殑璇娉曟鏌ワ紝SQL杈撳叆杈呭姪鍔熻兘鑷鐒舵祦鐣咃紝鍑犲彲涓巗qldeveloper宸ュ叿濯茬編銆
銆銆DM8杩樻湁涓涓鎴戦潪甯告湡寰呯殑鍔熻兘锛屾垜浠鍦ㄤ紭鍖栧瓨鍌ㄨ繃绋嬫ц兘鐨勬椂鍊欎細纰板埌涓涓闈炲父澶寸柤鐨勯棶棰橈細鏃犳硶鏈夋晥鐨勭‘瀹氬瓨鍌ㄨ繃绋嬩腑鏌愭潯SQL鐨勬墽琛岃″垝銆侱M8鍦ㄥ瓨鍌ㄨ繃绋嬭皟璇曞姛鑳戒腑澧炲姞浜嗘煡鐪婼QL鎵ц岃″垝鐨勫姛鑳斤紝杩欐槸涓澶у垱鏂帮紝涓嬮潰鎴戜滑鏉ヤ綋楠屼竴涓嬪惂銆
銆銆--鍒涘缓涓涓瀛樺偍杩囩▼锛岀湅鐪婦M8鏀鎸佸氬皯鍔ㄦ佽嗗浘
銆銆create or REPLACE PROCEDURE p_explain()
銆銆as
銆銆cnt INT;
銆銆begin
銆銆cnt=0;
銆銆select COUNT(*) INTO cnt from SYSOBJECTS where SYSOBJECTS.NAME LIKE 'V$%';
銆銆print cnt;
銆銆end;
銆銆--璋冭瘯瀛樺偍杩囩▼锛屾煡鐪媠elect璇鍙ョ殑鎵ц岃″垝
銆銆--褰撳綋褰撳綋锛屾湡寰呭凡涔呯殑鍔熻兘缁堜簬瀹炵幇浜!
銆銆涓嬮潰鎴戜滑鍐嶆潵鐪嬬湅閫掑綊WITH鍚э紝ITPUB涓妌ewkid绛夊ぇ绁炴渶鍠滄㈢敤閫掑綊WITH鏉ヨВ澶嶆潅鐨凷QL棰樼洰浜嗭紝浠ュ悗涔熷彲浠ュ湪DM8涓婅繍琛屼簡銆
銆銆--鍏堟潵涓绠鍗曠殑
銆銆with T(code,name,parentCode,level) as
銆銆(
銆銆select '01' as Code,'姝︽眽甯' Name,'0' parentCode,1 level from dual union all
銆銆select '02' as Code,'鍖椾含甯' Name,'0' parentCode,1 level from dual union all
銆銆select '0101' ,'娲灞卞尯','01',2 from dual union all
銆銆select '010101' ,'琛楅亾鍙','0101',3 from dual union all
銆銆select '010102' ,'鍏冲北','0101',3 from dual union all
銆銆select '0102' ,'姝︽槍鍖','01',2 from dual union all
銆銆select '0103' ,'姹熷忓尯','01',2 from dual union all
銆銆select '0201' ,'娴锋穩鍖','02',2 from dual union all
銆銆select '020101' ,'榄忓叕鏉','0201',3 from dual union all
銆銆select '020102' ,'涓鍏虫潙','0201',3 from dual union all
銆銆select '0202' ,'涓滃煄鍖','02',2 from dual
銆銆)
銆銆,A(code,name,parentCode,level) as(
銆銆select Code,Name,parentCode,level from T where Code='01'
銆銆union all
銆銆select T.Code,T.Name,T.parentCode,t.level from T
銆銆inner join A on T.parentCode=A.Code
銆銆)
銆銆--閫掑綊鏌ヨ㈡︽眽鏁版嵁
銆銆select * from A ;
銆銆--鍐嶆潵涓涓猲ewkid澶х炲啓鐨勮川鍥犲瓙鍒嗚В鐨凷QL
銆銆WITH t(c,n,m,r) AS (
銆銆SELECT 1,2,720,1 FROM DUAL
銆銆UNION ALL
銆銆SELECT c+1
銆銆,CASE WHEN MOD(m,n)>0 THEN n+1 ELSE n END
銆銆,CASE WHEN MOD(m,n)>0 THEN m ELSE m/n END
銆銆,MOD(m,n)
銆銆FROM t
銆銆WHERE c<720 AND m>1
銆銆)
銆銆SELECT n FROM t WHERE r=0;
銆銆绡囧箙鏈夐檺锛屼粖澶╁氨鍒嗕韩杩欎箞澶氫簡锛屼笅娆℃湁绌哄啀缁х画娣卞叆!
