Hi, Any help on this would be appreciated.
RDBMS Version: 8.1.7.3.2 Operating System and Version: Windows 2000 Cpu_wait_time shows 0 in v$rsrc_consumer_group We have implemented Oracle Resource manager in one database environment. The CPU resource allocation is done in 4 levels. SQL> Select plan, group_or_subplan, cpu_p1, cpu_p2, cpu_p3, cpu_p4 From dba_rsrc_plan_directives Ord er by 1, 2, 3, 4, 5; PLAN GROUP_OR_SUBPLAN CPU_P1 CPU_P2 CPU_P3 CPU_P4 ------------------------------ ------------------------------ ---------- ---------- ---------- ----- MARS_APPLICATION_PLAN MARS_HIGH_PRIORITY_GROUP 0 0 60 0 MARS_APPLICATION_PLAN MARS_LOW_PRIORITY_GROUP 0 0 10 0 MARS_APPLICATION_PLAN MARS_MEDIUM_PRIORITY_GROUP 0 0 30 0 MARS_RESOURCE_PLAN MARS_APPLICATION_PLAN 0 20 0 0 MARS_RESOURCE_PLAN MARS_LOADER_GROUP 0 80 0 0 MARS_RESOURCE_PLAN MARS_SYS_GROUP 100 0 0 0 MARS_RESOURCE_PLAN OTHER_GROUPS 0 0 0 100 SYSTEM_PLAN LOW_GROUP 0 0 100 0 SYSTEM_PLAN OTHER_GROUPS 0 100 0 0 SYSTEM_PLAN SYS_GROUP 100 0 0 0 10 rows selected. When we execute a query after 4 weeks 1 select name,consumed_cpu_time,cpu_wait_time,cpu_waits,requests 2* from v$rsrc_consumer_group SQL> / NAME CONSUMED_CPU_TIME CPU_WAIT_TIME CPU_WAITS REQUESTS -------------------------------- ----------------- ------------- ---------- ---------- MARS_SYS_GROUP 173796512 0 1701 2199298 MARS_LOADER_GROUP 194284328 0 64 54614617 MARS_LOW_PRIORITY_GROUP 38894745 0 49 2315210 MARS_MEDIUM_PRIORITY_GROUP 1173218366 0 33846 1321363 MARS_HIGH_PRIORITY_GROUP 385109141 0 2079 619166 OTHER_GROUPS 2942 0 0 342 6 rows selected. Why CPU_WAIT_TIME shows 0 when cumulative CPU_WAITS are many? Oracle bug? Is CPU_WAITS > 100 is of big concern? shreepad -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vaidya, ShreepadX M INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
