Re: Sessions wait on "resmgr:cpu quantum" with little CPU load
From: Yong Huang <yong321_at_yahoo.com>
Date: Tue, 15 Jul 2008 09:51:23 -0700 (PDT)
Message-ID: <196922.22326.qm@web80607.mail.mud.yahoo.com>
> resource_limit boolean FALSE
> resource_manager_plan string
RISCP_DAY
> SQL> select * from V$RSRC_PLAN;
>
> ID NAME IS_TO
> ---------- -------------------------------- -----
> 51409 RISCP_DAY TRUE
We *are* using CPU management:
Date: Tue, 15 Jul 2008 09:51:23 -0700 (PDT)
Message-ID: <196922.22326.qm@web80607.mail.mud.yahoo.com>
> SQL> sho parameter resource
>
> NAME TYPE VALUE
> ------------------------------------ --------------------------------
> resource_limit boolean FALSE
> resource_manager_plan string
RISCP_DAY
> SQL> select * from V$RSRC_PLAN;
>
> ID NAME IS_TO
> ---------- -------------------------------- -----
> 51409 RISCP_DAY TRUE
We *are* using CPU management:
SQL> select GROUP_OR_SUBPLAN, CPU_P1 from DBA_RSRC_PLAN_DIRECTIVES where PLAN = 'RISCP_DAY' order by CPU_P1;
GROUP_OR_SUBPLAN CPU_P1 ------------------------------ ---------- PLASTIC_REPORT 5 BATCH 10 OTHER_GROUPS 10 SYS_GROUP 15 OLTP_USERS 60
Yong Huang
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jul 15 2008 - 11:51:23 CDT