1、 性能測試組oracle一體機性能測試簡報報告日期：2012-02-02一、測試目的驗證報表系統(tǒng)在oracle一體機上的性能二、測試總結(jié)Oracle一體機環(huán)境配置系統(tǒng)名稱IP機器型號CPU內(nèi)存頁交換空間磁盤報表平臺系統(tǒng)103.160.2.1Exadatax2-21/43.07MHz2cpu*6,雙核96*2臺24G300GB*4配置參數(shù)修改前17個并發(fā)統(tǒng)計信息系統(tǒng)名稱VU數(shù)Sql名稱最小響應(yīng)時間(s)平均響應(yīng)時間(s)最大響應(yīng)時間(s)90%響應(yīng)時間(s)交易成功率-PP+VF7/、W17archsql011.368.54734.88325.636100%sql016.03815.12538.

2、75223.747100%sql035.75114.79941.126.694100%sql0414.96226.566111.31735.469100%sql067.63720.328106.1525.317100%sql075.29414.31536.41322.574100%sql084.23414.12642.64123.939100%sql097.37915.98534.76926.951100%報表平臺糸統(tǒng)Sql106.23117.19347.64230.336100%Sql1119.95432.0350.99749.607100%Sql126.68213.50133.7220.2

3、38100%Sql135.73115.15628.65223.999100%Sql145.25514.65838.71927.634100%Sql1545.15453.63183.94976.537100%Sql160.217832.10417.94100%Sql175.94114.24633.71422.773100%Sql186.98312.74924.97320.848100%系統(tǒng)資源使用率系統(tǒng)資源數(shù)值CPU總體使用率90.05%用戶使用率88.83%系統(tǒng)使用率1.22%最大使用率磁盤讀65.17KB/S磁盤寫1153.29KB/SI/O153.114次/s虛擬內(nèi)存使用率0.00%物理內(nèi)

4、存總體占用率45.69%50個并發(fā)統(tǒng)計信息系統(tǒng)名稱VU數(shù)Sql名稱最小響應(yīng)時間(s)平均響應(yīng)時間(s)最大響應(yīng)時間(s)90%響應(yīng)時間(s)交易成功率4T7T7/、乍50archsql0126.90457.336137.32991.72100%sql0130.1957.196122.5487.393100%sql0325.98256.765123.21692.709100%sql0443.34171.388132.49499.178100%sql0632.94663.586133.84798.768100%sql0725.90656.696121.60793.289100%sql0830.12

5、556.331120.32483.941100%sql0929.6160.478122.11489.529100%報表平臺糸統(tǒng)Sql1035.32862.166161.53199.378100%Sql1151.90681.51140.849117.797100%Sql1229.3456.927120.6894.033100%Sql1330.69762.552175.91897.011100%Sql1430.32757.074122.95391.232100%Sql1592.711233.182,371.71142.2100%Sql160.0960.60690.10.313100%Sql1728

6、.28257.518121.75293.298100%Sql1829.03756.148122.23290.003100%系統(tǒng)資源使用率系統(tǒng)資源數(shù)值CPU總體使用率83.4%用戶使用率81.36%系統(tǒng)使用率2.04%最大使用率100%磁盤讀6.66KB/S磁盤寫1161.79KB/SI/O152.57次/s虛擬內(nèi)存使用率0.00%物理內(nèi)存總體占用率53.27%176個并發(fā)統(tǒng)計信息系統(tǒng)名稱VU數(shù)Sql名稱最小響應(yīng)時間(s)平均響應(yīng)時間(s)最大響應(yīng)時間(s)90%響應(yīng)時間(s)交易成功率豐b厶專176archsql019.781412.849808.703528.234100%sql0136.4

7、22460.065899.141528.641100%sql037.531377.505712.906517.344100%sql04336.625498.807810.188544.367100%sql0619.641456.31872.438536.563100%sql079.828463.183828519.222100%sql0822.047458.424886.219524.234100%sql0942.547448.453697.844536.625100%報表十臺糸統(tǒng)Sql10158.594478.432893.438532.047100%Sql1177.891529.94191

8、6.859567.094100%Sql1210.641360.405719.234518.703100%Sql13316.469468.245554.276522.535100%Sql1413.109459.95806.141523.561100%Sql15373.484570.712708.047605.104100%Sql165.016293.16706.703514.359100%Sql170.797337.529745.578517.002100%Sql189.781412.849808.703528.234100%系統(tǒng)資源使用率系統(tǒng)資源數(shù)值CPU總體使用率97.3%用戶使用率96.0

9、%系統(tǒng)使用率1.3%最大使用率100%磁盤讀15.1KB/S磁盤寫1185.76KB/SI/O156.79次/s虛擬內(nèi)存使用率0.00%物理內(nèi)存總體占用率52.03%配置參數(shù)修改后13個并發(fā)統(tǒng)計信息系統(tǒng)名稱VU數(shù)Sql名稱最小響應(yīng)時間(s)平均響應(yīng)時間(s)最大響應(yīng)時間(s)90%響應(yīng)時間(s)交易成功率報表平臺系統(tǒng)13archsql014.88810.314.89912.362100%sql015.01210.18714.36112.414100%sql035.1969.99716.38812.114100%sql0412.64418.54924.52420.974100%sql0612.7

10、7716.80821.83719.783100%sqL075.42610.0415.79612.35100%sql084.4449.57214.90911.539100%sql094.81711.40416.67613.618100%SqllO7.22912.27817.56714.457100%Sqlll19.1122.33525.97624.184100%Sqll25.81410.10814.22112.187100%Sqll39.63713.22819.55316.259100%Sqll44.53810.05315.73112.238100%系統(tǒng)資源使用率系統(tǒng)資源數(shù)值CPU總體使用率39

11、.79%用戶使用率37.02%系統(tǒng)使用率2.77%最大使用率55.4%磁盤讀4.66KB/s磁盤寫1090.93KB/sI/O142.41次/s虛擬內(nèi)存使用率0.00%物理內(nèi)存總體占用率46.7%50個并發(fā)統(tǒng)計信息系統(tǒng)名稱VU數(shù)Sql名稱最小響應(yīng)時間(s)平均響應(yīng)時間(s)最大響應(yīng)時間(s)90%響應(yīng)時間(s)交易成功率archsql0146.663117.244164.083158.745100%sqlOl56.356116.493163.983159.521100%sql0353.387116.159163.733158.779100%sql0474.952132.422172.25516

12、8.754100%sql0650.538130.12171.665165.846100%sql0752.048116.817165.257157.835100%sql0851.505116.606163.023159.318100%土R豐厶玄sql0948.498119.161162.748159.525100%報表平臺系50統(tǒng)SqllO71.135120.499166.716160.817100%Sqlll88.548137.6175.19168.358100%Sql1252.69117.543161.768157.475100%Sql1356.372120.706167.197161.78

13、4100%Sql1456.96117.037117.037159.029100%Sql15129.949172.505216.802186.992100%Sql1759.319116.874163.41159.321100%Sql1847.358116.15161.586158.309100%系統(tǒng)資源使用率系統(tǒng)資源數(shù)值CPU總體使用率83.3%用戶使用率81.9%系統(tǒng)使用率1.4%最大使用率100.00%磁盤讀4.81KB/S磁盤寫1145.90KB/SI/O152.40次/s虛擬內(nèi)存使用率0.00%物理內(nèi)存總體占用率47.40%200個并發(fā)統(tǒng)計信息系統(tǒng)名稱VU數(shù)Sql名稱最小響應(yīng)時間(s)平

14、均響應(yīng)時間(s)最大響應(yīng)時間(s)90%響應(yīng)時間(s)交易成功率archsql01415.467563.895612.233601.901100%sql01425.974564.231611.535604.875100%sql03415.598562.831611.888606.761100%sql04433.112579.651620.016612.344100%sql06494.554577.032617.676611.068100%sql07467.751562.583610.851602.878100%sql08466.722562.666610.431603.406100%土R豐厶玄

15、sql09415.188563.63613.331605.69100%報表平臺系50統(tǒng)Sql10415.648415.648613.625609.804100%Sql11454.98584.728622.183616.654100%Sql12431.179563.411610.724601.96100%Sql13464.465569.393614.482611.314100%Sql14416.33563.022611.586605.233100%Sql15528.993613.631674.541633.461100%Sql17416.114562.225612.61604.524100%Sq

16、l18433.408563.155611.032605.899100%系統(tǒng)資源使用率系統(tǒng)資源數(shù)值CPU總體使用率84.7%用戶使用率83.4%系統(tǒng)使用率1.3%最大使用率100.00%磁盤讀11.28KB/S磁盤寫1169.75KB/SI/O153.90次/s虛擬內(nèi)存使用率0.00%物理內(nèi)存總體占用率48.39%Update13個并發(fā)統(tǒng)計信息系統(tǒng)名稱VU數(shù)Sql名稱最小響應(yīng)時間(s)平均響應(yīng)時間(s)最大響應(yīng)時間(s)90%響應(yīng)時間(s)交易成功率-PR豐B/、占13archsql016.33210.33814.07912.268100%sql015.81610.38813.62112.476

17、100%sql036.04910.28214.12312.868100%sql0414.66518.07721.68420.16100%sql0613.20517.03721.98819.75100%sql076.39610.29313.91512.279100%報表平臺糸統(tǒng)sql084.3289.76313.96211.627100%sql095.42211.64916.24813.93100%Sql109.30912.73416.56514.689100%Sql1119.04622.2924.99724.376100%Sql126.53410.24714.23912.773100%Sql1

18、38.20513.58318.38716.383100%update205.96511.71316.74114.164100%系統(tǒng)資源使用率系統(tǒng)資源數(shù)值CPU總體使用率40.6%用戶使用率38.2%系統(tǒng)使用率2.5%最大使用率52.7%磁盤讀2.64KB/S磁盤寫1064.44KB/SI/O138.07次/s虛擬內(nèi)存使用率0.00%物理內(nèi)存總體占用率47.93%Update50個并發(fā)統(tǒng)計信息系統(tǒng)名稱VU數(shù)Sql名稱最小響應(yīng)時間(s)平均響應(yīng)時間(s)最大響應(yīng)時間(s)90%響應(yīng)時間(s)交易成功率4T7T7/、乍50archsql0149.739122.007163.224159.245100

19、%sql0150.697124.336164.007160.33100%sql0346.074123.72163.657158.719100%sql0461.55137.79169.713166.426100%sql0664.349134.622170.499164.623100%sql0751.348123.141162.991160.441100%報表平臺糸統(tǒng)sql0848.225123.039161.399159.468100%sql0942.99842.998164.269161.749100%Sql1054.33154.331166.86162.59100%Sql1187.80814

20、7.636174.423171.755100%Sql12171.755123.943163.154159.722100%Sql1355.446127.232164.108161.201100%Sql1446.564123.085162.245160.027100%Sqll546.564172.407172.407189.592100%Sqll758.194124.814162.806158.138100%Sql1851.717162.174162.174160.828100%update2066.225126.205160.6160.333100%系統(tǒng)資源使用率系統(tǒng)資源數(shù)值CPU總體使用率78

21、.6%用戶使用率77.4%系統(tǒng)使用率1.2%最大使用率100.00%磁盤讀3.03KB/S磁盤寫1154.44KB/SI/O154.91次/s虛擬內(nèi)存使用率0.00%物理內(nèi)存總體占用率48.85%Update200個并發(fā)統(tǒng)計信息系統(tǒng)名稱VU數(shù)Sql名稱最小響應(yīng)時間(s)平均響應(yīng)時間(s)最大響應(yīng)時間(s)90%響應(yīng)時間(s)交易成功率200archsql01416.955571.311626.772617.635100%sql01378.243378.243628.131615.411100%sql03408.245569.711630.741612.546100%sql04441.81658

22、1.486632.123623.339100%sql06623.339578.673634.892625.165100%sql07433.744566.454627.777616.059100%sql08436.696569.681629.652615.716100%sql09383.477568.274568.274617.094100%報表十臺系統(tǒng)Sql10390.316575.763627.957619.187100%Sql11379.328594.092642.954631.499100%Sql12399.605570.479570.479615.386100%Sql13406.643574.709635.333619.101100%Sql14417.797569.94629.165614.248100%Sql15403.078625.375682.91658.646100%S