Re: Sessions wait on "resmgr:cpu quantum" with little CPU load
- From: Yong Huang <yong321@xxxxxxxxx>
- To: K Gopalakrishnan <kaygopal@xxxxxxxxx>
- Date: Tue, 15 Jul 2008 09:51:23 -0700 (PDT)
> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts: