oracle 10g ADDM
oracle 10g addm在10g中,大家應該都知道addm是做什麼的吧?如果不熟悉請去看看"Oracle Database 10 g : 為 DBA 提供的最佳前 20 位的特性",在$ORACLE_HOME/rdbms/admin目錄中,addm產生報表的指令碼有addmrpt.sql及addmrpti.sql,addmrpt.sql用於單例項,addmrpti.sql用於多例項.
測試請看如下所示:
SQL> @?/rdbms/admin/addmrpt
Current Instance
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
1861383692 TEST 1 test
Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB Id Inst Num DB Name Instance Host
------------ -------- ------------ ------------ ------------
* 1861383692 1 TEST test test
* 1861383692 1 TEST test 10gR2T1
Using 1861383692 for database Id
Using 1 for instance number
Specify the number of days of snapshots to choose from
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Entering the number of days (n) will result in the most recent
(n) days of snapshots being listed. Pressing without
specifying a number lists all completed snapshots.
Listing the last 3 days of Completed Snapshots
Snap
Instance DB Name Snap Id Snap Started Level
------------ ------------ --------- ------------------ -----
test TEST 157 25 Jul 2005 00:00 1
158 25 Jul 2005 01:00 1
210 27 Jul 2005 05:00 2
211 27 Jul 2005 06:00 2
212 27 Jul 2005 07:00 2
Snap
Instance DB Name Snap Id Snap Started Level
------------ ------------ --------- ------------------ -----
test TEST 213 27 Jul 2005 08:00 2
214 27 Jul 2005 09:00 2
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 211
Begin Snapshot Id specified: 211
Enter value for end_snap: 212
End Snapshot Id specified: 212
Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is addmrpt_1_211_212.txt. To use this name,
press to continue, otherwise enter an alternative.
Enter value for report_name:
Using the report name addmrpt_1_211_212.txt
Running the ADDM analysis on the specified pair of snapshots ...
Generating the ADDM report for this analysis ...
DETAILED ADDM REPORT FOR TASK 'TASK_706' WITH ID 706
----------------------------------------------------
Analysis Period: 27-JUL-2005 from 06:00:48 to 07:00:53
Database ID/Instance: 1861383692/1
Database/Instance Names: TEST/test
Host Name: 10gR2T1
Database Version: 10.2.0.1.0
Snapshot Range: from 211 to 212
Database Time: 5089 seconds
Average Database Load: 1.4 active sessions
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
FINDING 1: 30% impact (1504 seconds)
------------------------------------
Wait event "Streams capture: waiting for archive log" in wait class "Other"
was consuming significant database time.
RECOMMENDATION 1: Application Analysis, 30% benefit (1504 seconds)
ACTION: Investigate the cause for high "Streams capture: waiting for
archive log" waits. Refer to Oracle's "Database Reference" for the
description of this wait event.
RECOMMENDATION 2: Application Analysis, 30% benefit (1504 seconds)
ACTION: Investigate the cause for high "Streams capture: waiting for
archive log" waits in Service "SYS$USERS".
SYMPTOMS THAT LED TO THE FINDING:
SYMPTOM: Wait class "Other" was consuming significant database time.
(30% impact [1506 seconds])
FINDING 2: 15% impact (765 seconds)
-----------------------------------
Time spent on the CPU by the instance was responsible for a substantial part
of database time.
RECOMMENDATION 1: DB Configuration, 15% benefit (765 seconds)
ACTION: Investigate the cause for the "Logminer" processes consuming 20%
of the host CPU.
ADDITIONAL INFORMATION:
The instance spent significant time on CPU. However, there were no
predominant SQL statements responsible for the CPU load.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
ADDITIONAL INFORMATION
----------------------
Wait class "Application" was not consuming significant database time.
Wait class "Commit" was not consuming significant database time.
Wait class "Concurrency" was not consuming significant database time.
Wait class "Configuration" was not consuming significant database time.
Wait class "Network" was not consuming significant database time.
Wait class "User I/O" was not consuming significant database time.
Session connect and disconnect calls were not consuming significant database
time.
Hard parsing of SQL statements was not consuming significant database time.
The analysis of I/O performance is based on the default assumption that the
average read time for one database block is 10000 micro-seconds.
An explanation of the terminology used in this report is available when you
run the report with the 'ALL' level of detail.
End of Report
Report written to addmrpt_1_211_212.txt
測試請看如下所示:
SQL> @?/rdbms/admin/addmrpt
Current Instance
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
1861383692 TEST 1 test
Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB Id Inst Num DB Name Instance Host
------------ -------- ------------ ------------ ------------
* 1861383692 1 TEST test test
* 1861383692 1 TEST test 10gR2T1
Using 1861383692 for database Id
Using 1 for instance number
Specify the number of days of snapshots to choose from
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Entering the number of days (n) will result in the most recent
(n) days of snapshots being listed. Pressing
specifying a number lists all completed snapshots.
Listing the last 3 days of Completed Snapshots
Snap
Instance DB Name Snap Id Snap Started Level
------------ ------------ --------- ------------------ -----
test TEST 157 25 Jul 2005 00:00 1
158 25 Jul 2005 01:00 1
210 27 Jul 2005 05:00 2
211 27 Jul 2005 06:00 2
212 27 Jul 2005 07:00 2
Snap
Instance DB Name Snap Id Snap Started Level
------------ ------------ --------- ------------------ -----
test TEST 213 27 Jul 2005 08:00 2
214 27 Jul 2005 09:00 2
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 211
Begin Snapshot Id specified: 211
Enter value for end_snap: 212
End Snapshot Id specified: 212
Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is addmrpt_1_211_212.txt. To use this name,
press
Enter value for report_name:
Using the report name addmrpt_1_211_212.txt
Running the ADDM analysis on the specified pair of snapshots ...
Generating the ADDM report for this analysis ...
DETAILED ADDM REPORT FOR TASK 'TASK_706' WITH ID 706
----------------------------------------------------
Analysis Period: 27-JUL-2005 from 06:00:48 to 07:00:53
Database ID/Instance: 1861383692/1
Database/Instance Names: TEST/test
Host Name: 10gR2T1
Database Version: 10.2.0.1.0
Snapshot Range: from 211 to 212
Database Time: 5089 seconds
Average Database Load: 1.4 active sessions
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
FINDING 1: 30% impact (1504 seconds)
------------------------------------
Wait event "Streams capture: waiting for archive log" in wait class "Other"
was consuming significant database time.
RECOMMENDATION 1: Application Analysis, 30% benefit (1504 seconds)
ACTION: Investigate the cause for high "Streams capture: waiting for
archive log" waits. Refer to Oracle's "Database Reference" for the
description of this wait event.
RECOMMENDATION 2: Application Analysis, 30% benefit (1504 seconds)
ACTION: Investigate the cause for high "Streams capture: waiting for
archive log" waits in Service "SYS$USERS".
SYMPTOMS THAT LED TO THE FINDING:
SYMPTOM: Wait class "Other" was consuming significant database time.
(30% impact [1506 seconds])
FINDING 2: 15% impact (765 seconds)
-----------------------------------
Time spent on the CPU by the instance was responsible for a substantial part
of database time.
RECOMMENDATION 1: DB Configuration, 15% benefit (765 seconds)
ACTION: Investigate the cause for the "Logminer" processes consuming 20%
of the host CPU.
ADDITIONAL INFORMATION:
The instance spent significant time on CPU. However, there were no
predominant SQL statements responsible for the CPU load.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
ADDITIONAL INFORMATION
----------------------
Wait class "Application" was not consuming significant database time.
Wait class "Commit" was not consuming significant database time.
Wait class "Concurrency" was not consuming significant database time.
Wait class "Configuration" was not consuming significant database time.
Wait class "Network" was not consuming significant database time.
Wait class "User I/O" was not consuming significant database time.
Session connect and disconnect calls were not consuming significant database
time.
Hard parsing of SQL statements was not consuming significant database time.
The analysis of I/O performance is based on the default assumption that the
average read time for one database block is 10000 micro-seconds.
An explanation of the terminology used in this report is available when you
run the report with the 'ALL' level of detail.
End of Report
Report written to addmrpt_1_211_212.txt
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-627292/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle 10g,AWR,AWR,ADDM最佳實踐Oracle 10g
- 轉載Friend Life for Oracle的Oracle 10g,AWR,AWR,ADDM最佳實踐Oracle 10g
- Oracle ADDM --dbms_addm執行oracle資料庫診斷Oracle資料庫
- oracle addm segment tuningOracle
- 10G新特性系列: ADDM 的報告(一)
- oracle效能調憂工具AWR,ASH,ADDMOracle
- 10G新特性系列:禁止在AWR後自動執行ADDM
- 9. Oracle常用分析診斷工具——9.3.ADDMOracle
- dbms_addm執行oracle資料庫診斷Oracle資料庫
- Oracle ADDM 自動診斷監視工具 介紹Oracle
- oracle10g使用sql獲得ADDM報告以及利用ADDM監控表的dml情況 ztOracleSQL
- Oracle效能調整的三把利劍--ASH,AWR,ADDMOracle
- ADDM報告分析
- 初探ADDM的使用
- ORACLE 10g下載|ORACLE 10g下載地址|ORACLE 10g官網下載地址Oracle 10g
- Oracle OCP 1Z0 053 Q71(ADDM AWR Interval)Oracle
- Oracle ADDM 自動診斷監視工具介紹及使用Oracle
- oracle 10g patchOracle 10g
- ORACLE 10G AUTOTRACEOracle 10g
- oracle asm 10gOracleASM
- recyclebin for oracle 10gOracle 10g
- Oracle 10g flashbackOracle 10g
- Glossary Oracle 10gOracle 10g
- oracle 10g flashback databaseOracle 10gDatabase
- Oracle 10g RAC NFSOracle 10gNFS
- oracle 10g em建立Oracle 10g
- ORACLE 10G 升級Oracle 10g
- Oracle 10g RAC TAFOracle 10g
- oracle 10g RMAN管理Oracle 10g
- ORACLE 10G AWR 速查!Oracle 10g
- Oracle AS 10g 10.1.2.0.2Oracle
- Oracle 10G 跟蹤Oracle 10g
- oracle 10g的程式Oracle 10g
- oracle 10g em patchOracle 10g
- Oracle 10g Scheduler 特性Oracle 10g
- Oracle 10g AS基本管理Oracle 10g
- oracle 10g logmnrOracle 10g
- oracle 10g downloadOracle 10g