We just started playing with it. We're confused as to why OTHER_GROUPS continues to to increase, when we know every userid has been allocated to a consumer group. We had a call into Oracle Support and they don't know either. The number of requests has remained static at 7 for a while, but it continues to show an increase in the CPU_USED column. This is on 9.2.0.4 on AIX 4.3.3. CONSUMER GROUP CPU USED ACTIVE REQUESTS WAITERS YIELDS CPU_WAITS CPU_WAIT_TIME --------------- ---------- ------ -------- ------- ------- ---------- ------------- ADMIN_CG 1927304 1 2453 0 0 0 0 ESCO_EU_CG 339130 0 312 0 0 0 0 OTHER_GROUPS 275912 0 7 0 0 0 0 ES_CG 17297 0 82 0 0 0 0 BI_CG 0 0 0 0 0 0 0 DIS_EU_CG 0 0 0 0 0 0 0 LOW_GROUP 0 0 0 0 0 0 0 PAR_EU_CG 0 0 0 0 0 0 0 PMO_CG 0 0 0 0 0 0 0 SYS_GROUP 0 0 0 0 0 0 0 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mladen Gogala Sent: Wednesday, March 10, 2004 11:38 AM To: oracle-l@xxxxxxxxxxxxx Subject: Re: database resource manager I configured and activated it on 8.1.7 database on HP-UX to controll the level of parallelism. The goal was to prevent the OLTP users from running queries in parallel, accross several instances (it was a 4-way cluster, with 3 nodes used for OLTP processing, 4th node used for batch processing). Worked like a charm, without any problems. On 03/10/2004 11:16:25 AM, "Fedock, John (KAM.RHQ)" wrote: > Anyone have any experience with using oracle's database resource > manager? I understand it can limit resources such as CPU, etc. I am starting to research now and am looking for any PROs or CONs. > > I am running 8i on HP-UX 11.00 > > Thanks all. > > John Fedock > "K" Line America, Inc. > www.kline.com > * john.fedock@xxxxxxxxxxxx > > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------