RE: database resource manager

From: Thomas Jeff <jeff.thomas_at_thomson.net>
Date: Fri, 12 Mar 2004 15:41:00 -0500
Message-ID: <358728A276824E419580403633AABFD0021F60EB@INDYSMAIL03.am.thmulti.com>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mladen Gogala Sent: Wednesday, March 10, 2004 11:38 AM To: oracle-l_at_freelists.org
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_at_us.kline.com
>
>

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://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_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Mar 12 2004 - 14:37:39 CST