建站
咨詢
售后
建站咨詢
新聞中心
查看整體負(fù)載
cpu使用居高不下;基本上整體CPU是百分80%以上了;
創(chuàng)新互聯(lián)建站服務(wù)項目包括新河網(wǎng)站建設(shè)、新河網(wǎng)站制作、新河網(wǎng)頁制作以及新河網(wǎng)絡(luò)營銷策劃等。多年來，我們專注于互聯(lián)網(wǎng)行業(yè)，利用自身積累的技術(shù)優(yōu)勢、行業(yè)經(jīng)驗、深度合作伙伴關(guān)系等，向廣大中小型企業(yè)、政府機(jī)構(gòu)等提供互聯(lián)網(wǎng)行業(yè)的解決方案，新河網(wǎng)站推廣取得了明顯的社會效益與經(jīng)濟(jì)效益。目前，我們服務(wù)的客戶以成都為中心已經(jīng)輻射到新河省份的部分城市，未來相信會繼續(xù)擴(kuò)大服務(wù)區(qū)域并繼續(xù)獲得客戶的支持與信任！
此時:物理讀600MB/s,REDO也不算太高;
全為latch free,一般為bug高發(fā)區(qū)
檢查相關(guān)SQL
基本為系統(tǒng)SQL:4b4wp0a8dvkf0,11bzv8fm87zvr,3uqkkfu1crw8y,frjd8zfy2jfdq,8mdz49zkajhw3
相關(guān)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)
SYMPTOMS
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
[TOC00001]
ORA-00600: internal error code, arguments: [kksgaGetNoAlloc_Int0], [11], [11], [], [], [], [], [], [], [], [], []
----- Current SQL Statement for this session (sql_id=4b4wp0a8dvkf0) -----
SELECT executions, end_of_fetch_count, elapsed_time/px_servers elapsed_time, cpu_time/px_servers cpu_time, buffer_gets/executions buffer_gets FROM (SELECT sum(executions_delta) as EXECUTIONS, sum(case when px_servers_execs_delta > 0 then px_servers_execs_delta else executions_delta end) as px_servers, sum(end_of_fetch_count_delta) as end_of_fetch_count, sum(elapsed_time_delta) as ELAPSED_TIME, sum(cpu_time_delta) as CPU_TIME, sum(buffer_gets_delta) as BUFFER_GETS FROM DBA_HIST_SQLSTAT s, V$DATABASE d, DBA_HIST_SNAPSHOT sn WHERE s.dbid = d.dbid AND bitand(nvl(s.flag, 0), 1) = 0 AND sn.end_interval_time > (select systimestamp at TIME ZONE dbtimezone from dual) - 7 AND s.sql_id = :1 AND s.snap_id = sn.snap_id AND s.instance_number = sn.instance_number AND s.dbid = sn.dbid AND parsing_schema_name = :2)
[TOC00004-END]
client details:
O/S info: user: , term: , ospid: 31700
machine: 3012 program: perl@***** (TNS V1-V3)
application name: Oracle Enterprise Manager.Metric Engine, hash value=2371535196
這個BUG只能打補丁;
4 8mdz49zkajhw3,ORA-4031 During Automatic Report Flush Query Execution After Upgrade To 12.1.0.2 (Doc ID 2330230.1)
To avoid the error use any of below alternatives:
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.
- OR-
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)
新聞標(biāo)題：oracle12.1cpu100%
標(biāo)題網(wǎng)址：http://fisionsoft.com.cn/article/pdisih.html
