| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle Database Resource Manager
Response out of line. :)
IIRC, you and I spent a lot of time discussing this with the development gu= ys, didn't we? Did it end up being logged as a bug? =
Pete
=
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
=
"Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] =
On Behalf Of Jonathan Lewis
Sent: Tuesday, 4 May 2004 6:49 AM
To: oracle-l_at_freelists.org
Subject: Re: Oracle Database Resource Manager
Notes in-line.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Optimising Oracle Seminar
http://www.jlcomp.demon.co.uk/seminar.html
June 2004 UK Manchester
July 2004 Iceland
July 2004 USA California
Aug 2004 USA North Carolina
Sept 2004 UK Manchester
Sept 2004 USA NYC
Oct 2004 USA Boston
From: "Pete Sharman" <peter.sharman_at_oracle.com>
To: <oracle-l_at_freelists.org>
Cc: "Peter Ross Sharman" <PETER.SHARMAN_at_oracle.com>
Sent: Monday, May 03, 2004 8:27 PM
Subject: RE: Oracle Database Resource Manager
I don't know who the instructor was, but he or she is talking crap (pardon =
=3D
my French). Really, what would be the point of implementing a resource man=
=3D
ager that itself takes too many resources?
[jl] Good question - I asked myself the same thing when
[jl] I first ran the 9.0.1 resource manager on my HP-UX
[jl] box. Under some conditions the overhead was about
[jl] 100%. Things improved when the sampling rate was
[jl] dropped somewhat.
One thing that people get confused about with the Resource Manager, BTW, is=
=3D
when it actually takes effect. It's when the resource being managed is ex=
=3D
hausted i.e. if you're allocating different amounts of the CPU utilization =
=3D
to different groups, you WON'T see Resource Manager kick in until CPU utili=
=3D
zation hits 100%. After all, it's not a problem till then, right?
[jl] I've found that it tends to kick in only after the demand
[jl] exceeds about 200% of available resources; and then
[jl] the allocation fractions aren't obeyed particularly well.
[jl] One of the positive things about it though is that you
[jl] can set it up to error out any SQL whose calculated
[jl] cost exceeds a given limit - which means less of the
[jl] 'query from hell' stuff wrecking performance for
[jl] everyone else on the system.
-- 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 Mon May 03 2004 - 16:29:30 CDT
 |
 |