|
|
Hi erman,
Again,need your support.
Apps version R12.2.5
DB version 12.1.0.2
We have submitted a custom report and it is running since 2 days.Status is acive and no plan is captured is sqlmonitor..might be the plan is very big crossing 300 lines.
When i check the event,most of the time it is showing as resmgr:cpu quantum
set linesize 250 pagesize 0 trims on tab off long 1000000
column report format a220
select
DBMS_SQL_MONITOR.REPORT_SQL_MONITOR
(sql_id=>'fzufpy282f6f3',report_level=>'ALL') report
from dual;
SQL Monitoring Report
SQL>
SQL> select status,event,last_call_et/60,state,seconds_in_Wait from v$session where sid=1461 and serial#=12872;
ACTIVE resmgr:cpu quantum ,2622.11667 WAITED SHORT TIME 32
We have 4 core processor on this machine and no other apps is running on this server.
Load average is normal on this server -2.90, 2.56, 2.50
SQL> !top
top - 14:39:37 up 682 days, 1:31, 5 users, load average: 2.90, 2.56, 2.50
Tasks: 923 total, 3 running, 920 sleeping, 0 stopped, 0 zombie
%Cpu(s): 20.6 us, 0.7 sy, 0.0 ni, 78.2 id, 0.3 wa, 0.0 hi, 0.1 si, 0.0 st
KiB Mem : 26384160+total, 17029192 free, 30381892 used, 21643051+buff/cache
KiB Swap: 26843545+total, 26843534+free, 100 used. 19553361+avail Mem
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
5330 root 20 0 184564 16728 4864 R 93.8 0.0 801197:02 amsHelper
12063 oraprod 20 0 25.386g 3.963g 3.916g R 93.8 1.6 2608:07 oracle_12063_pr-->this is the process
19616 oraprod 20 0 25.347g 5.011g 5.003g S 12.5 2.0 4:16.61 oracle_19616_pr
3930 oraprod 20 0 25.381g 0.020t 0.020t S 6.2 8.0 166:34.74 ora_lms1_proddb
7258 oraprod 20 0 158516 2956 1512 R 6.2 0.0 0:00.01 top
17678 oraprod 20 0 25.366g 732836 712148 S 6.2 0.3 0:07.09 oracle_17678_pr
We have verified resource plan:
SQL> sho parameter resource
resource_limit boolean TRUE
resource_manager_cpu_allocation integer 8
resource_manager_plan string SCHEDULER[0x72F79]:DEFAULT_MAI
NTENANCE_PLAN
Not sure,if we need to disable this or what happening exactly
Thank you
|
Locked
