【BUG】Oracle12c tablespace io statistics missing from awr report
該問題為bug,可參考: Bug 25416731 - tablespace io statistics missing from awr report (Doc ID 25416731.8)
1.針對 Oracle 12.2.0.1 到18.x 版本, 可以下載bug 25416731 來修復
2.針對 Oracle 19.x, 可以透過 BUG 27871293 修復,如果無法修復,參考下面命令
也可執行以下命令 修復
set line 200 col table_name format a40 select * from dba_hist_table_settings where table_name in ('WRH$_FILESTATXS','WRH$_DATAFILE','Tempfile Group','WRH$_TEMPSTATXS'); exec dbms_workload_repository.modify_table_settings(table_name => 'WRH$_FILESTATXS', flush_level => 'TYPICAL'); exec dbms_workload_repository.modify_table_settings(table_name => 'WRH$_DATAFILE', flush_level => 'TYPICAL'); exec dbms_workload_repository.modify_table_settings(table_name => 'Tempfile Group', flush_level => 'TYPICAL'); exec dbms_workload_repository.modify_table_settings(table_name => 'WRH$_TEMPSTATXS', flush_level => 'TYPICAL');
設定後,awr報告會統計tablespace io相關資訊
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29487349/viewspace-2780162/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Script to generate AWR report from remote sql clientREMSQLclient
- AWR中的SQL StatisticsSQL
- OGG-01028 Recovery record is missing from log 的BUG處理
- 透過AWR REPORT 或 ADDM REPORT進行SQLTUNESQL
- 系統bug report
- statspack report分析(AWR也可參考)
- Oracle 10g AWR Report 分析(轉)Oracle 10g
- android bug report toolsAndroid
- Awr Report Memory Advisory分析介紹
- AWR Report 自動生成指令碼 [final]指令碼
- Retrieve SQL and Execution Plan from AWR SnapshotsSQL
- How to move Oracle Spatial objects from SYSAUX tablespace to a user defined tablespace [ID 1119758.1OracleObjectUX
- 【AWR】Suggestions if Your SYSAUX Tablespace Grows Rapidly or Too LargeUXAPI
- [Shell] 自動生成oracle awr report並mail出來OracleAI
- 如何使用awr_set_report_thresholds控制AWR報告裡的sql語句數量SQL
- 使用_smu_debug_mode瞭解undo tablespace
- Oracle 12C RMAN transport tablespace from PDB of RAC CDB to remote PDBOracleREM
- [shell] execute remote Script自動生成oracle awr report並mail出來REMOracleAI
- 由Oracle Bug引起的AWR Snapshot收集故障Oracle
- 記錄:Bug 8575528 Missing entries in V$MUTEX_SLEEP.locationMutex
- oracle小知識點5--通過dbms_workload_repository.awr_report_html產生awr報告OracleHTML
- Subject: Bug 3827736 - LPX-225 during datapump import with statisticsImport
- oracle 11g AWR CPU 顯示Bug 一則Oracle
- ASM例項使用CREATE PFILE FROM MEMORY的bugASM
- 通過blktrace, debugfs分析磁碟IO
- 10.2.0.1的crs的bug—Failed to restrieve procctx from htAIREST
- nagios監控linux磁碟io的bugiOSLinux
- 手工生成HTML格式AWR遇到Bug 13527323一例HTML
- Recovery from missing or corrupted datafile(多個資料檔案丟失或者損壞的恢復)
- LeetCode:Missing Number And First Missing PositiveLeetCode
- gdb除錯時的問題Missing separate debuginfos, use: debuginfo-install glibc-XXX除錯
- Database StatisticsDatabase
- DELETE STATISTICSdelete
- 【Mysql】Slave_IO_Running: No---Got fatal error 1236 from masterMySqlGoErrorAST
- tablespace 大檔案,undo,temp tablespace
- MySQL案例09:Last_IO_Error: Got fatal error 1236 from master when reading data from binary logMySqlASTErrorGo
- Error waiting for a debug connection: ProcessException: adb did not report forwarded portErrorAIExceptionForward
- Statistics related viewView