12cR2_AWR相關(guān)參數(shù)設(shè)置-創(chuàng)新互聯(lián)

Oracle 12cR2

我們提供的服務(wù)有：成都網(wǎng)站設(shè)計(jì)、網(wǎng)站建設(shè)、微信公眾號(hào)開發(fā)、網(wǎng)站優(yōu)化、網(wǎng)站認(rèn)證、葫蘆島ssl等。為近1000家企事業(yè)單位解決了網(wǎng)站和推廣的問題。提供周到的售前咨詢和貼心的售后服務(wù)，是有科學(xué)管理、有技術(shù)的葫蘆島網(wǎng)站制作公司

性能優(yōu)化文檔。

https://docs.oracle.com/database/122/TDPPT/oracle-database-performance-method.htm#TDPPT007

Gathering Database Statistics Using the Automatic Workload Repository

Database statistics provide information about the type of load on the database and the internal and external resources used by the database. To accurately diagnose performance problems with the database using ADDM, statistics must be available.

A cumulative statistic is a count such as the number of block reads. Oracle Database generates many types of cumulative statistics for the system, sessions, and individual SQL statements. Oracle Database also tracks cumulative statistics about segments and services. Automatic Workload Repository (AWR) automates database statistics gathering by collecting, processing, and maintaining performance statistics for database problem detection and self-tuning purposes.

By default, the database gathers statistics every hour and creates an AWR snapshot, which is a set of data for a specific time that is used for performance comparisons. The delta values captured by the snapshot represent the changes for each statistic over the time period. Statistics gathered by AWR are queried from memory. The gathered data can be displayed in both reports and views.

--每小時(shí)收集一次AWR快照

The following initialization parameters are relevant for AWR:

--下面是兩個(gè)和AWR相關(guān)的參數(shù)。

  • STATISTICS_LEVEL

    Set this parameter to TYPICAL (default) or ALL to enable statistics gathering by AWR. Setting STATISTICS_LEVEL to BASIC disables many database features, including AWR, and is not recommended.

     --設(shè)置以上參數(shù)為basic會(huì)禁用掉很多數(shù)據(jù)庫特性，包括AWR，不建議設(shè)置basic

  • CONTROL_MANAGEMENT_PACK_ACCESS

    Set to DIAGNOSTIC+TUNING (default) or DIAGNOSTIC to enable automatic database diagnostic monitoring. Setting CONTROL_MANAGEMENT_PACK_ACCESS to NONE disables many database features, including ADDM, and is strongly discouraged.

      --關(guān)閉此參數(shù)會(huì)禁用掉很多數(shù)據(jù)庫的特性，包括ADDM,不建議關(guān)閉。

SQL> show parameter statistics_level       --默認(rèn)值不需要修改

NAME                                TYPE       VALUE
------------------------ ----------- ------------------------------
statistics_level                    string     TYPICAL

SQL> show parameter control_management  --默認(rèn)值不需要修改

NAME                                          TYPE       VALUE
-------------------------------------- ----------- ------------------------------
control_management_pack_access     string     DIAGNOSTIC+TUNING
SQL>

以上大家知道我們收集到AWR信息是和那些參數(shù)有關(guān)，默認(rèn)設(shè)置即可，不需要修改。

建議大家看英文官方文檔，學(xué)英語學(xué)技術(shù)，哦也！

另外有需要云服務(wù)器可以了解下創(chuàng)新互聯(lián)cdcxhl.cn，海內(nèi)外云服務(wù)器15元起步，三天無理由+7*72小時(shí)售后在線，公司持有idc許可證，提供“云服務(wù)器、裸金屬服務(wù)器、高防服務(wù)器、香港服務(wù)器、美國(guó)服務(wù)器、虛擬主機(jī)、免備案服務(wù)器”等云主機(jī)租用服務(wù)以及企業(yè)上云的綜合解決方案，具有“安全穩(wěn)定、簡(jiǎn)單易用、服務(wù)可用性高、性價(jià)比高”等特點(diǎn)與優(yōu)勢(shì)，專為企業(yè)上云打造定制，能夠滿足用戶豐富、多元化的應(yīng)用場(chǎng)景需求。

當(dāng)前名稱：12cR2_AWR相關(guān)參數(shù)設(shè)置-創(chuàng)新互聯(lián)
轉(zhuǎn)載注明：http://muchs.cn/article36/diecpg.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供面包屑導(dǎo)航、網(wǎng)站策劃、云服務(wù)器、網(wǎng)站營(yíng)銷、網(wǎng)站維護(hù)、定制開發(fā)

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來源： 創(chuàng)新互聯(lián)

成都網(wǎng)站建設(shè)公司