| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Resource consumer group 8.1.7.3.2
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 0100
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: shreepadx.m.vaidya_at_intel.com
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: ListGuru_at_fatcity.com (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). Received on Tue Dec 30 2003 - 11:19:32 CST
 |
 |