oracle數(shù)據(jù)庫健康檢查與評估(已改無錯字)
2024-10-06 01 本頁面
【正文】 NER才需要被設(shè)置。所獲得的跟蹤文件需交由Oracle Support進(jìn)行分析。SQLNET跟蹤只需在一段時間內(nèi)開啟，因為這將占用一些網(wǎng)絡(luò)資源。 SQL*Net*Net配置的設(shè)置信息。當(dāng)前的SQLNET參數(shù)如下：Parameter Value AUTORCLATIC_IPCN/ATRACE_LEVEL_CLIENTN/ATRACE_FILE_CLIENTN/ATRACE_DIRECTORY_CLIENTN/AN/A TNSNAMES。連接描述符包括監(jiān)聽程序的地址以及connect_data。：由于TNSNAMES中相關(guān)的網(wǎng)絡(luò)服務(wù)名比較多。7. 數(shù)據(jù)庫性能數(shù)據(jù)庫的性能情況通過AWR的報告來體現(xiàn)。由于本次檢查并不是完整的性能檢查，所以本報告只列舉最主要的性能問題。XXXXSnap IdSnap TimeSessionsCursors/SessionBegin Snap:End Snap:Elapsed:DB Time:YYYYSnap IdSnap TimeSessionsCursors/SessionBegin Snap:End Snap:Elapsed:DB Time:我們可以參考用戶系統(tǒng)忙時的AWR信息進(jìn)行分析，不一定局限于檢查時段，這樣可以更加深入的發(fā)現(xiàn)問題。 數(shù)據(jù)庫各項基于時間模型的統(tǒng)計信息對數(shù)據(jù)庫業(yè)務(wù)負(fù)荷壓力最大情況下每一個實例的一個AWR報告的列出主要的性能結(jié)果，如數(shù)據(jù)庫各項基于時間模型的統(tǒng)計信息等：XXXXStatistic NameTime (s)% of DB Timesql execute elapsed timeDB CPUparse time elapsedhard parse elapsed timehard parse (sharing criteria) elapsed timePL/SQL execution elapsed timePL/SQL pilation elapsed timeconnection management call elapsed timesequence load elapsed timerepeated bind elapsed timehard parse (bind mismatch) elapsed timeDB timebackground elapsed timebackground cpu timeYYYYStatistic NameTime (s)% of DB TimeDB CPUsql execute elapsed timeparse time elapsedhard parse elapsed timehard parse (sharing criteria) elapsed timehard parse (bind mismatch) elapsed timePL/SQL execution elapsed timesequence load elapsed timePL/SQL pilation elapsed timeconnection management call elapsed timeinbound PL/SQL rpc elapsed timerepeated bind elapsed timeDB timebackground elapsed timebackground cpu time 數(shù)據(jù)庫負(fù)荷壓力分析XXXXLoad Profile Per SecondPer TransactionRedo size:Logical reads:Block changes:Physical reads:Physical writes:User calls:Parses:Hard parses:Sorts:Logons:Executes:Transactions:% Blocks changed per Read:Recursive Call %:Rollback per transaction %:Rows per Sort:YYYYLoad Profile Per SecondPer TransactionRedo size:Logical reads:Block changes:Physical reads:Physical writes:User calls:Parses:Hard parses:Sorts:Logons:Executes:Transactions:% Blocks changed per Read:Recursive Call %:Rollback per transaction %:Rows per Sort: 各項命中率XXXXInstance Efficiency Percentages (Target 100%) Buffer Nowait %:Redo NoWait %:Buffer Hit %:Inmemory Sort %:Library Hit %:Soft Parse %:Execute to Parse %:Latch Hit %:Parse CPU to Parse Elapsd %:% NonParse CPU:YYYYInstance Efficiency Percentages (Target 100%) Buffer Nowait %:Redo NoWait %:Buffer Hit %:Inmemory Sort %:Library Hit %:
法律信息相關(guān)推薦
鄂ICP備17016276號-1