oracle 12.1 cpu 100%
查看整体负载
cpu使用居高不下;基本上整体CPU是百分80%以上了; 此时:物理读600MB/s,REDO也不算太高; 全为latch free,一般为bug高发区 检查相关SQL 基本为系统SQL:4b4wp0a8dvkf0,11bzv8fm87zvr,3uqkkfu1crw8y,frjd8zfy2jfdq,8mdz49zkajhw3 相关BUG: 1 Frequent Execution of Recursive Sql Metrics Collector SQL_ID "frjd8zfy2jfdq" in 12.1.0.2 (Doc ID 2059121.1) alter sysetm set _OPTIMIZER_DYNAMIC_SAMPLING=0 2 Very Long Parse Time for Queries in InMemory Database (Doc ID 2102106.1) High “Latch Free” Waits with Contention on ‘Result Cache: RC Latch’ when RESULT_CACHE_MODE = MANUAL on Oracle 12c (Doc ID 2002089.1) alter system set "_optimizer_ads_use_result_cache" = FALSE 3 Bug 18511269 : ORA-600 [KKSGAGETNOALLOC_INT0] RUNNING WORKLOAD & ONLINE REDEF CONCURRENTLY (Doc ID 2175884.1) Following error is reported on the alert log and trace file may contain the following information: Dump continued from file: /u01/app/oracle/diag/rdbms/flowr/FLOWR2/trace/FLOWR2_ora_31705.trc client details: 这个BUG只能打补丁; 4 8mdz49zkajhw3,ORA-4031 During Automatic Report Flush Query Execution After Upgrade To 12.1.0.2 (Doc ID 2330230.1) 1/ Increase the SGA size by running the SGA_TARGET_ADVISOR and set a minimum size for shared_pool_size based on the recommendation of the shared pool advisor.
2/ Use the workaround: Turn off the "Automatic Report Flush" feature by setting: SQL> alter system set "_report_capture_cycle_time"=0; /* Default is 60 seconds */ 参考:Troubleshooting ‘cursor: pin S wait on X‘ waits. (Doc ID 1349387.1)High Waits On Real-time Descriptor Latch From 12.1.0.1 (Doc ID 2382299.1)Database Hang on 12c with ‘Cursor: Pin S wait on X‘,‘Row Cache Lock‘ and ‘Library Cache Load Lock‘ (Doc ID 2127483.1)12c: ‘acknowledge over PGA limit‘ Wait Event (Doc ID 2138882.1)High Wait Time for ‘cursor: pin S wait on X‘ Event After Upgrade (Doc ID 1949691.1) (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |