oracle-數(shù)據(jù)庫健康檢查2000

1、XORACLE 服務(wù)移動數(shù)據(jù)庫檢查OracleBOSS 系統(tǒng)數(shù)據(jù)庫<營業(yè)庫>X 工程師： 報告生成日期:現(xiàn)場支持起始日期：X2009 年 03 月 12 日2009 年 03 月 12 日Advanced Product Services文檔控制此文檔移動與科訊支持服務(wù)部審閱。不得向與此無關(guān)的個人或機構(gòu)傳閱或。修改分發(fā)者審閱ii職位日期作者版本修改Advanced Product Services目錄文檔控制II修改ii分發(fā)者ii審閱ii1.檢查總結(jié)51.1概要5介紹62.目標6檢查方法6檢查范圍62.12.22.33.系統(tǒng)背景73.13.23.3系統(tǒng)環(huán)境7數(shù)據(jù)庫配置7基于Orac

2、le 數(shù)據(jù)庫的應(yīng)用84.硬件配置84.1 節(jié)點1（ bosscrm1_i1）84.2 節(jié)點2（ bosscrm1_i2）9操作系統(tǒng)性能95.1 主機bosscrm1_i1, bosscrm1_i2性能105.2 結(jié)論/建議13數(shù)據(jù)庫配置135.6.6.36.46.56.66.76.86.9數(shù)據(jù)庫參數(shù)14SGA組成26SGA使用情況27控制文件29Redo Logs29臨時表空間30系統(tǒng)表空間316.10 表空間管理316.11 數(shù)據(jù)段386.12 索 引396.136.146.156.16行/行遷移39無效對象40備份與恢復(fù)41ALERT 日志426.17 結(jié)論/建議437.數(shù)據(jù)庫性能437.

3、1 關(guān)于性能統(tǒng)計報告437.2 數(shù)據(jù)庫負載447.3 數(shù)據(jù)庫實例性能. 447.4 PGA. 457.5等待（Top Wait Events）467.6 全表掃描477.7 失效索引477.8 Top SQL487.9 其它可能的瓶頸497.10 結(jié)論/建議50附錄518.iiiAdvanced Product Services8.1 附錄A：數(shù)據(jù)庫 STATSPACK報告518.2 附錄B：數(shù)據(jù)庫 RDA報告51iv1. 檢查總結(jié)1.1概要本文所描述的數(shù)據(jù)庫性能檢查針對BOSS 系統(tǒng)數(shù)據(jù)庫< bosscrm1>，所需的資料來源主要是 RDA 報告、數(shù)據(jù)庫STATSPACK 報告和

4、操作系統(tǒng)命令。此次我們主要檢查了該數(shù)據(jù)庫的性能，在下面的報告中，做出分析，然后提出相關(guān)的改進建議。如果科訊工程師在檢查中發(fā)現(xiàn) ORACLE的問題，對檢查范圍內(nèi)的情況進行，并通知客戶改正。對于比較復(fù)雜的問題，在報告中指出，并建議客戶進一步進行相關(guān)的詳細檢查，或建議客戶通過 MetaLink 將問題提交到 ORACLE 技術(shù)支持，以便問題得到解決。Commercial in Confidence2. 介紹2.1目標數(shù)據(jù)庫健康檢查是用來：評價數(shù)據(jù)庫當前的性能情況分析數(shù)據(jù)庫應(yīng)用瓶頸和競爭情況指出存在的問題，提出解決建議2.2檢查方法本次數(shù)據(jù)庫健康檢查的工具是：ORACLE 系統(tǒng)診斷工具RDA（Remo

5、te Diagnostic Agent） ，進行系統(tǒng)配置信息收集。操作系統(tǒng)工具和命令，用以檢查操作系統(tǒng)，收集性能指標。IBM 性能分析工具glance。SQL 命令，在Oracle 工具SQL*Plus 中運行，用來檢查數(shù)據(jù)庫配置。ORACLE 工具STATSPACK，用來收集數(shù)據(jù)庫的負載、性能指標。上述工具的輸出結(jié)果為建議提供依據(jù)。上述輸出結(jié)果為建議提供依據(jù)。2.3檢查范圍的檢查對象為< bosscrm1>數(shù)據(jù)庫，所提供的檢查和建議主要針對以下方面：主機配置操作系統(tǒng)性能網(wǎng)絡(luò)性能數(shù)據(jù)庫配置數(shù)據(jù)庫性能提供的檢查和建議不涉及：具體的性能調(diào)整應(yīng)用程序的具體細節(jié)Commercial in

6、Confidence3. 系統(tǒng)背景3.1系統(tǒng)環(huán)境3.2數(shù)據(jù)庫配置Commercial in Confidence數(shù)據(jù)庫名稱全局數(shù)據(jù)庫名稱實例名稱bosscrm1bosscrm1bosscrm1_i1/ bosscrm1_i2用途（oltp,dss，batch）RDBMS 版本SQL*Net 版本數(shù)據(jù)庫文件是否設(shè)備所有數(shù)據(jù)文件所占磁盤空間OLTPOracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit ProductionVersion 9.2.0.8.0 - ProductionY6475755.77M使用到的磁盤數(shù)DB_BLOCK Size表

7、空間個數(shù) 數(shù)據(jù)文件個數(shù)控制文件個數(shù)8K15728873日志文件大小日志組數(shù)目每組日志文件成員數(shù)量日志文件產(chǎn)生頻率歸檔方式1022M122數(shù)據(jù)庫方式（ C/S,3 layer）可用性需求 (e.g. M-F 8-5, 7x24, etc.)最大停機時間7x24平均數(shù)據(jù)庫冷備份時間平均數(shù)據(jù)庫恢復(fù)時間系統(tǒng)名稱用途（Prod, Test, Development）BOSSDBPROD硬件供貨商所在城市，物理位置（機房，遠程）ORACLE 實例數(shù)量可用性需求(e.g. M-F 8-5, 7x24, etc.)移房27*243.3基于Oracle 數(shù)據(jù)庫的應(yīng)用4. 硬件配置本次性能檢查針對RAC 系統(tǒng)的所

8、有節(jié)點：bosscrm1_i1 bosscrm1_i24.1節(jié)點1（ bosscrm1_i1）4.1.1主機配置下表列出主機 bosscrm1_i1 的主要配置。Commercial in Confidence名用途（Prod, Test, Development）CRMDB1Prod所在城市，物理位置（機房，） 硬件供貨商型號操作系統(tǒng)操作系統(tǒng)版本移房64-bit HP-UXB.11.23操作系統(tǒng)Block SizeCPU 個數(shù)64內(nèi)存212992 MB最大并發(fā)Oracle 會話數(shù)3,565SGA sizeTotal System Global Area 9.8735E+10 bytes Fi

9、xed Size765920 bytes Variable Size9529458688 bytesDatabase Buffers 8.9121E+10 bytes Redo Buffers83894272 bytes可用性需求（e.g. M-F 8-5, 7x24, etc.）7*24應(yīng)用名稱應(yīng)用類型（OLTP，DSS，batch） 開發(fā)工具數(shù)據(jù)庫方式（C/S,3 layer）N/AN/AN/AN/A4.2節(jié)點2（ bosscrm1_i2）4.2.1主機配置下表列出主機 bosscrm1_i2 的主要配置5. 操作系統(tǒng)性能以下部分是對操作系統(tǒng)性能的基本分析，可以從中確定一些性能方面的問題。

10、這個分析使用的是操作系統(tǒng)工具，主要從以下方面來檢查操作系統(tǒng)的性能。CPU 使用率內(nèi)存使用率說明：這部分的檢查并不是針對操作系統(tǒng)或硬件的全面深入的檢查，上述要求請與操作系統(tǒng)廠商Commercial in Confidence名用途（Prod, Test, Development）CRMDB2所在城市，物理位置（機房，） 硬件供貨商型號操作系統(tǒng)操作系統(tǒng)版本移房64-bit HP-UXB.11.23操作系統(tǒng)Block SizeCPU 個數(shù)64內(nèi)存212992 MB最大并發(fā)Oracle 會話數(shù)1,607SGA sizeTotal System Global Area 9.8735E+10 bytes

11、Fixed Size765920 bytes Variable Size9529458688 bytesDatabase Buffers 8.9121E+10 bytes Redo Buffers83894272 bytes可用性需求（e.g. M-F 8-5, 7x24, etc.）7*245.1主機bosscrm1_i1, bosscrm1_i2性能5.1.1CPU 使用率下圖是主機 CRMDB1 的CPU 的使用情況時間段：Commercial in ConfidenceSystem: CRMDB1Fri Mar 12 17:48:27 2009Load averages: 0.62,

12、0.60, 0.583938 processes: 3855 sleeping, 83 running Cpu states:CPULOADUSERNICESYSIDLE BLOCK SWAITINTRSSYS 00.62 35.2%0.0% 10.8% 54.0%0.0%0.0%0.0%0.0%10.63 49.6%0.0% 10.6% 39.8%0.0%0.0%0.0%0.0%20.60 34.8%0.0% 12.7% 52.5%0.0%0.0%0.0%0.0%30.65 27.3%0.0% 20.8% 51.9%0.0%0.0%0.0%0.0%40.66 40.0%0.0% 11.0%

13、49.1%0.0%0.0%0.0%0.0%50.65 37.1%0.0% 11.6% 51.3%0.0%0.0%0.0%0.0%60.63 38.8%0.0% 13.8% 47.3%0.0%0.0%0.0%0.0%70.68 42.4%0.0% 11.4% 46.2%0.0%0.0%0.0%0.0%80.64 81.6%0.0%1.5% 16.9%0.0%0.0%0.0%0.0%90.64 53.7%0.0% 10.2% 36.1%0.0%0.0%0.0%0.0%100.63 60.2%0.0%3.4% 36.4%0.0%0.0%0.0%0.0%110.62 55.1%0.0%8.7% 36.

14、2%0.0%0.0%0.0%0.0%120.66 73.7%0.0%4.4% 22.0%0.0%0.0%0.0%0.0%130.75 72.2%0.0%4.4% 23.5%0.0%0.0%0.0%0.0%140.70 70.5%0.0%9.1% 20.5%0.0%0.0%0.0%0.0%150.69 58.1%0.0% 10.8% 31.1%0.0%0.0%0.0%0.0%160.59 37.1%0.0%8.3% 54.5%0.0%0.0%0.0%0.0%170.65 43.4%0.0%8.5% 48.1%0.0%0.0%0.0%0.0%180.58 35.2%0.0%9.7% 55.1%0.

15、0%0.0%0.0%0.0%190.58 41.5%0.0%8.3% 50.2%0.0%0.0%0.0%0.0%200.60 38.6%0.0%6.8% 54.5%0.0%0.0%0.0%0.0%210.62 40.2%0.0%7.8% 52.1%0.0%0.0%0.0%0.0%220.62 43.0%0.0% 10.4% 46.6%0.0%0.0%0.0%0.0%230.65 38.3%0.0%9.8% 51.9%0.0%0.0%0.0%0.0%240.58 37.5%0.0% 10.0% 52.5%0.0%0.0%0.0%0.0%250.58 37.5%0.0%6.4% 56.1%0.0%

16、0.0%0.0%0.0%260.60 49.2%0.0%4.7% 46.0%0.0%0.0%0.0%0.0%270.61 55.9%0.0%6.2% 37.9%0.0%0.0%0.0%0.0%280.60 44.3%0.0%4.5% 51.1%0.0%0.0%0.0%0.0%290.63 38.6%0.0%8.5% 52.8%0.0%0.0%0.0%0.0%300.65 46.6%0.0%4.7% 48.7%0.0%0.0%0.0%0.0%310.64 37.3%0.0% 10.0% 52.7%0.0%0.0%0.0%0.0%320.58 44.7%0.0%6.1% 49.2%0.0%0.0%

17、0.0%0.0%330.60 36.9%0.0%7.4% 55.7%0.0%0.0%0.0%0.0%340.62 46.0%0.0%6.4% 47.5%0.0%0.0%0.0%0.0%350.60 53.9%0.0%6.5% 39.7%0.0%0.0%0.0%0.0%360.62 42.8%0.0%5.3% 51.9%0.0%0.0%0.0%0.0%對于主機 CRMDB1，系統(tǒng)較為繁忙，idle空閑率較低，iowait約有 0%。說明當前系統(tǒng)負載較高。下圖是主機 CRMDB2 的CPU 的使用情況時間段：Commercial in ConfidenceSystem: CRMDB2Fri Mar

18、 12 17:48:47 2009Load averages: 0.37, 0.39, 0.392013 processes: 1953 sleeping, 55 running, 5 zombies Cpu states:CPULOADUSERNICESYSIDLE BLOCK SWAITINTRSSYS 00.52 13.7%0.0%3.7% 82.6%0.0%0.0%0.0%0.0%10.40 42.6%0.0%2.7% 54.7%0.0%0.0%0.0%0.0%20.39 20.1%0.0%6.2% 73.7%0.0%0.0%0.0%0.0%30.41 33.5%0.0%2.7% 63

19、.8%0.0%0.0%0.0%0.0%40.43 19.5%0.0% 10.8% 69.6%0.0%0.0%0.0%0.0%50.43 56.1%0.0%1.2% 42.7%0.0%0.0%0.0%0.0%60.39 19.9%0.0%2.5% 77.6%0.0%0.0%0.0%0.0%70.43 34.6%0.0%4.3% 61.1%0.0%0.0%0.0%0.0%80.32 11.2%0.0%5.4% 83.4%0.0%0.0%0.0%0.0%90.33 24.2%0.0%3.9% 72.0%0.0%0.0%0.0%0.0%100.31 14.9%1.0%4.3% 79.9%0.0%0.0

20、%0.0%0.0%110.38 14.7%0.0%7.4% 77.9%0.0%0.0%0.0%0.0%120.45 16.2%0.0%6.2% 77.6%0.0%0.0%0.0%0.0%130.40 66.2%0.0%3.1% 30.8%0.0%0.0%0.0%0.0%140.29 14.9%0.0%7.2% 77.9%0.0%0.0%0.0%0.0%150.32 18.2%1.0%3.5% 77.4%0.0%0.0%0.0%0.0%160.42 11.0%0.0% 16.4% 72.5%0.0%0.0%0.0%0.0%170.49 40.6%0.0%3.9% 55.5%0.0%0.0%0.0

21、%0.0%180.37 11.2%0.0%5.2% 83.6%0.0%0.0%0.0%0.0%190.39 31.4%0.0%3.7% 64.9%0.0%0.0%0.0%0.0%200.36 25.8%0.0%3.1% 71.1%0.0%0.0%0.0%0.0%210.41 43.0%0.0%3.1% 53.9%0.0%0.0%0.0%0.0%220.43 18.8%0.0%6.2% 75.0%0.0%0.0%0.0%0.0%230.41 22.9%0.0%2.7% 74.4%0.0%0.0%0.0%0.0%240.37 15.7%0.6%4.3% 79.5%0.0%0.0%0.0%0.0%2

22、50.329.9%0.0%7.7% 82.4%0.0%0.0%0.0%0.0%260.34 14.1%0.0%6.0% 79.9%0.0%0.0%0.0%0.0%270.35 11.6%0.0%6.4% 82.0%0.0%0.0%0.0%0.0%280.369.3%0.0%7.2% 83.6%0.0%0.0%0.0%0.0%290.359.3%0.0% 12.0% 78.7%0.0%0.0%0.0%0.0%300.36 10.1%0.0%7.7% 82.2%0.0%0.0%0.0%0.0%370.67 56.2%0.0%5.5% 38.3%0.0%0.0%0.0%0.0%380.61 39.0

23、%0.0%8.1% 52.8%0.0%0.0%0.0%0.0%390.66 34.1%0.0%7.6% 58.3%0.0%0.0%0.0%0.0%對于主機 CRMDB2，系統(tǒng)較為空閑，idle 空閑率較高，iowait 約有 0%。說明當前系統(tǒng)可用充裕。相比而言，實例二所在的主機負載比實例一所在的主機負載較輕一些，但是總體負載還是較低。5.1.2內(nèi)存使用率下面說明主機 CRMDB1 的內(nèi)存使用情況。從以上統(tǒng)計可以看出，在繁忙期間系統(tǒng)剩余的物理內(nèi)存可用數(shù)較高，內(nèi)存的使用狀況良好，沒實際的pi,po 產(chǎn)生。下面說明主機 CRMDB2 的內(nèi)存使用情況Commercial in ConfidenceC

24、RMDB2/oraclelog/admin/bosscrm1_i2$ vmstat 2 10procsmemorypagefaultscpurbwavmfreereatpipofrdesrinsycs us sy id 2340 7878339500000 65600 920674 33159 16 4 802340 787833900000 89499 943793 50399 24 6 702340 787833900000 86698 889812 46834 23 6 712420 799543300000 85056 882994 45313 19 5 752420 79954330

25、00000 83409 851134 43439 21 5 742420 7995433900000 82015 819552 42085 30 7 632420 799543300000 81408 806361 41338 27 7 66CRMDB1/oraclelog/admin/bosscrm1_i1/bdump$ vmstat 2 10procsmemorypagefaultscpurbwavmfreereatpipofrdesrinsycs us sy id 3350 8126153 15102653 3559600000 69369 625536 33699 34 5 61335

26、0 8126153 15100861 4485020000 89781 839927 44100 42 6 523350 8126153 15100826 4509000000 85781 795852 41662 41 6 533350 8126153 15100610 4281400000 85521 805112 41366 38 7 553350 8126153 15101575 3236200000 86271 807271 42234 43 7 493170 8020832 15106686 3528000000 87263 812001 42538 42 7 513170 802

27、0832 15102987 3790000000 88193 827461 42963 44 8 483170 8020832 15102325 4295000000 87261 809121 42506 45 7 483170 8020832 15100862 4569000000 86710 795841 42220 43 7 503170 8020832 15100899 4129400000 87315 807003 42919 42 7 51310.36 14.1%0.0%3.9% 82.0%0.0%0.0%0.0%0.0%320.35 14.1%0.0%4.8% 81.0%0.0%

28、0.0%0.0%0.0%330.287.7%0.2% 10.6% 81.4%0.0%0.0%0.0%0.0%340.309.9%0.0%7.4% 82.8%0.0%0.0%0.0%0.0%350.309.7%0.0%9.5% 80.9%0.0%0.0%0.0%0.0%360.266.8%0.0%4.1% 89.2%0.0%0.0%0.0%0.0%370.29 11.4%1.0%4.3% 83.4%0.0%0.0%0.0%0.0%380.32 12.0%0.0%6.0% 82.0%0.0%0.0%0.0%0.0%390.308.7%0.0% 12.2% 79.1%0.0%0.0%0.0%0.0%

29、從以上統(tǒng)計可以看出，在繁忙期間系統(tǒng)剩余的物理內(nèi)存可用數(shù)較高，內(nèi)存的使用狀況良好，沒實際的pi,po 產(chǎn)生。5.2結(jié)論/建議從系統(tǒng)整體來看，CRMDB1 、CRMDB2 主機性能在繁忙期間負載。系統(tǒng)目前的性能瓶頸在。6. 數(shù)據(jù)庫配置這個部分詳細闡述了數(shù)據(jù)庫< bosscrm1>的主數(shù)據(jù)庫版本。數(shù)據(jù)庫的當前版本是Oracle 9.2.0.8.0，在數(shù)據(jù)庫版本 9.2.0 之上的最新補丁版本是 9.2.0.8。長期以來數(shù)據(jù)庫版本選用 9.2.0.8.0 是由于與應(yīng)用程序的配合。應(yīng)用程序與 Oracle 9.2.0.8.0的配合已經(jīng)確認。數(shù)據(jù)庫選項根據(jù)經(jīng)驗，許多系統(tǒng)安裝的數(shù)據(jù)庫選項從未被使

30、用。以下列出的安裝選項未在原計劃之內(nèi)。選項可供未來的應(yīng)用開發(fā)參考，或者可以被確認有哪些6.2.1安裝的選項以下是數(shù)據(jù)庫安裝的選項：Commercial in ConfidencePARAMETERVALUEPartitioningTRUEObjectsTRUEReal Application ClustersTRUEAdvanced replicationTRUEBit-mapped indexesTRUEConnection multiplexingTRUEConnection poolingTRUEDatabase queuingTRUEIncremental backup and rec

31、overyTRUEInstead-of triggersTRUEParallel backup and recoveryTRUE2420 799543300000 80555 797721 40972 27 6 672120 803388600000 79442 776485 40639 27 5 682120 803388600000 76261 747605 38888 22 4 746.3數(shù)據(jù)庫參數(shù)數(shù)據(jù)庫的參數(shù)可以看出是經(jīng)過精心設(shè)置的，下表列出非缺省的數(shù)據(jù)庫參數(shù)： 實例：bosscrm1_i1Commercial in ConfidenceNAMETYPEVALUEO7_DICTIONA

32、RY_ACCESSIBILITYbooleanFALSE_db_block_check_for_debugbooleanTRUE_kghdsidx_countinteger1_ksmg_granule_sizeinteger67108864_object_statisticsbooleanFALSE_trace_files_publicbooleanTRUEactive_instance_countinteger2Parallel executionTRUEParallel loadTRUEPoint-in-time tablespace recoveryTRUEFine-grained ac

33、cess controlTRUEProxy authentication/authorizationTRUEChange Data CaptureTRUEPlan StabilityTRUEOnline Index BuildTRUECoalesce IndexTRUEManaged StandbyTRUEMaterialized view rewriteTRUEMaterialized view warehouse refreshTRUEDatabase resource managerTRUESpatialTRUEVisual Information RetrievalTRUEExport

34、 transportable tablespacesTRUETransparent Application FailoverTRUEFast-Start Fault RecoveryTRUESample ScanTRUEDuplexed backupsTRUEJavaTRUEOLAP Window FunctionsTRUEBlock Media RecoveryTRUEFine-grained AuditingTRUEApplication RoleTRUEEnterprise User SecurityTRUEOracle Data GuardTRUEHeap segment compre

35、ssionTRUEJoin indexTRUETrial RecoveryTRUEOnline RedefinitionTRUEStreamsTRUEFile MappingTRUEinitial_extent, aq_tm_processes archive_lag_target audit_file_dest audit_sys_operations audit_trail background_core_dumpbackground_dump_destinteger integer string boolean string stringstring00?/rdbms/audit FAL

36、SEFALSEfull/oraclelog/admin/bosscrm1_i1/b dumpTRUE 1048576FALSEbackup_tape_io_slaves bitmap_merge_area_size blank_trimming buffer_pool_keep buffer_pool_recycle circuits cluster_databasecluster_database_instances cluster_interconnects commit_point_strength compatible control_file_record_keep_timecont

37、rol_filesboolean integer boolean string string integer boolean integer string integer string integerstring0TRUE 2192.168.100.22:192.168.101.1219.2.0.0.07/dev/crm1vg1/rcrm1vg1_05_ctl1,/dev/crm1vg3/rcrm1vg3_05_ctl2, /dev/crm1vg4/rcrm1vg4_05_ctl 3/oraclelog/admin/bosscrm1_i1/c dump648388608EXACT TRUE 0

38、00000FALSE TRUE 8192 OFF85899345920core_dump_deststringcpu_count create_bitmap_area_size cursor_sharing cursor_space_for_time db_16k_cache_size db_2k_cache_size db_32k_cache_size db_4k_cache_size db_8k_cache_size db_block_buffers db_block_checking db_block_checksum db_block_size db_cache_advice db_c

39、ache_size db_create_file_dest db_create_online_log_dest_1 db_create_online_log_dest_2 db_create_online_log_dest_3 db_create_online_log_dest_4db_create_online_log_dest_5integer integer stringbooleanbig big big bigbiginteger integer integer integerintegerinteger string boolean integer stringbig intege

40、r string string string string stringstringCommercial in Confidencedb_domain db_file_multiblock_read_count db_file_name_convertdb_files db_keep_cache_size db_name db_recycle_cache_size db_writer_processes dblink_encrypt_login dbwr_io_slaves dg_broker_config_file1 dg_broker_config_file2 dg_broker_star

41、t disk_asynch_io dispatchers distributed_lock_timeout dml_locksdrs_startenqueue_resources eventstring integer string integerbig integer stringbig integer integer boolean integer string string boolean boolean string integer integer boolean integerstring1640963221225472bosscrm1 020FALSE 0?/dbs/dr1.dat

42、?/dbs/dr2.dat FALSETRUE70019844FALSE 239602051 trace nameerrorstack level 10, 10511 trace name context forever, level 2, 10262 trac e name context forever, level 102400, 4031 trace name heapdump level 2, 4031 trace namebrary_cache level 10, 10841litrace namecontextforeverfal_client fal_server fast_s

43、tart_io_targetfast_start_mttr_target fast_start_parallel_rollback file_mapping filesystemio_options fixed_dategc_files_to_locks global_context_pool_size global_names hash_area_size hash_join_enabled hi_shared_memory_address hpux_sched_noage hs_autoregisterifile instance_groups instance_name instance

44、_numberjava_max_sessionspace_sizestring string integer integer string boolean string string string string boolean integer boolean integer integer boolean file string string integerinteger0300LOW FALSEasynchFALSE 10485760 TRUE00TRUEbosscrm1_i1 10Commercial in Confidencejava_pool_size java_soft_sessio

45、nspace_limit job_queue_processes large_pool_sizer.rssize, license_max_sessions license_max_users license_sessions_warning local_listener lock_name_spacelock_sga log_archive_dest log_archive_dest_1 log_archive_dest_10 log_archive_dest_2 log_archive_dest_3 log_archive_dest_4 log_archive_dest_5 log_arc

46、hive_dest_6 log_archive_dest_7 log_archive_dest_8 log_archive_dest_9 log_archive_dest_state_1log_archive_dest_state_10 log_archive_dest_state_2 log_archive_dest_state_3 log_archive_dest_state_4 log_archive_dest_state_5 log_archive_dest_state_6 log_archive_dest_state_7 log_archive_dest_state_8 log_ar

47、chive_dest_state_9 log_archive_duplex_dest log_archive_format log_archive_max_processes log_archive_min_succeed_dest log_archive_start log_archive_tracelog_buffer log_checkpoint_interval log_checkpoint_timeout log_checkpoints_to_alert log_file_name_convert log_parallelism logmnr_max_persistent_sessi

48、onsmit_propagation_delaymax_dispatchers max_dump_file_sizebig integer integer integerbig integer671088640402147483648integer integer integer string string boolean string string string string string string string string string string string string string string string string string string string stri

49、ng string string string integer integer boolean integer integer integer integer boolean string integer integer integer integerstring000listener_bosscrm1_i1TRUEenable enable enable enable enable enable enable enable enableenablebosscrm1%S_%T.arc 51FALSE 01677721601800FALSE51155MCommercial in Confiden

50、cemax_enabled_roles max_rollback_segments max_shared_servers mts_circuits mts_dispatchers mts_listener_address mts_max_dispatchers mts_max_servers mts_multiple_listeners mts_servers mts_service mts_sessions nls_calendarp nls_currency nls_date_format nls_date_language nls_dual_currency nls_iso_curren

51、cy nls_language nls_length_semantics nls_nchar_conv_excpnls_numeric_characters nls_sortnls_territory nls_time_format nls_time_tz_format nls_timestamp_format nls_timestamp_tz_formatobject_cache_max_size_percent object_cache_optimal_size olap_page_pool_size open_cursorsopen_links open_links_per_instan

52、ce optimizer_dynamic_sampling optimizer_features_enable optimizer_index_caching optimizer_index_cost_adj optimizer_max_permutations optimizer_mode oracle_trace_collection_name oracle_trace_collection_path oracle_trace_collection_size oracle_trace_enable oracle_trace_facility_name oracle_trace_facility_pathr.extentsinteger intege