 | | | Subject: Re: How to map a client program to a Resource Manager consumer group | Subject: Re: How to map a client program to a Resource Manager consumer group 2007-11-01 - By Dan Norris
Back
I'm not an RM expert, but I did learn a lot from the live webcast session that
the RAC SIG had last week titled "Using Resource Manager for Managing Mixed
Workloads". I'm working on getting the recorded version of that posted on the
RAC SIG website (www.oracleracsig.org). Once you sign up with the SIG, you can
playback any of the recorded sessions on demand at any time. I hope to have
this session's recording posted before the end of next week along with the
presentation slides from the session too.
Fairlie, I suspect that the session was conducted by some of the people you
spoke with in SF - Sue Lee and I don't remember the name of the other technical
person that did the 2nd half of the session, but he seemed to know his stuff
pretty well.
Watch the site for the playback link to be posted in the next week if you're
interested.
Dan
-- -- Original Message ----
From: fairlie rego <fairlie_r@(protected)>
To: tony.vanlingen@(protected)
Cc: oracle-l@(protected)
Sent: Thursday, November 1, 2007 1:11:31 AM
Subject: Re: How to map a client program to a Resource Manager consumer group
Hi Tony,
I have attached a sample script in a separate email. The script creates a
plan and consumer groups.
One of the sites I am working on has had limited success with RM.
There have been a couple of times it has bailed us out but on more
than one occassion we have had sessions stuck in resmgr: cpu quantum
even when the CPU on the box is at 50% idle.
I spent a day with the RM development team in San Fran last month
identifying issues in the product. Unfortunately most of these I believe are
unpublished.
The feature in RM to throttle sessions works fine.
There are times when RM does not kick in even when load is nearing 100%
Also RM also does not function properly on machines with more than 8 cpus.
Thanks
Fairlie
Tony van Lingen <tony.vanlingen@(protected)> wrote:
Fairlie,
That's not encouraging. I did do some digging on Metalink and Google,
but the only bugs I was able to find related to problems with mapping
priorities. Can you give me an idea of the bugs that you found? Are they
so bad that you would not use RM in a production environment at all?
What do other people think about this?
Cheers,
Tony
fairlie rego wrote:
> I second Peter's comment and I can give you umpteen number of bugs
> which I have logged and know of in the RM subject area and I seriously
> doubt whether 11g has fixed many of them
>
> Thanks
> Fairlie
>
> */Peter McLarty /* wrote:
>
> Hi Tony
> From a conversation I had with a guy from Oracle a few months
> back, you are probably seeing a few bugs with resource manager.
>
> He
suggested anyone who really wanted to get stuff working to use 11g
>
> Apparently there are a few gremlins there
>
> Cheers
>
> Peter
>
> -- --Original Message-- --
> From: Tony van Lingen [mailto:tony.vanlingen@(protected)]
> Sent: Wed 10/31/2007 10:30 AM
> To: oracle-l@(protected)
> Subject: Re: How to map a client program to a Resource Manager
> consumer group
>
> Morning List.
>
> Hmm, not a single answer... does that mean that nobody actually
> uses the
> resource manager? What is good practice here.. If you use the
> resource
> manager at all, how do you map user sessions to consumer groups?
> Is it
> even advisable to use CLIENT_PROGRAM?
>
> All suggestions welcome.
>
> Cheers.
> Tony
>
>
> *Fairlie Rego
> *Senior Oracle Consultant
>
http://el-caro.blogspot.com/
> M: +61 402 792 405
>
>
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ----
__ ____ ____ ____ ____ ____
Disclaimer
WARNING: This e-mail (including any attachments) has originated from a
Queensland Government department and may contain information that is
confidential, private, or covered by legal professional privilege, and may be
protected by copyright.
You may use this e-mail only if you are the person(s) it was intended to be
sent to and if you use it in an authorised way. No one is allowed to use,
review, alter, transmit, disclose, distribute, print or copy this e-mail
without appropriate authority. If you have received this e-mail in error,
please inform the sender immediately by phone or e-mail and delete this e-mail,
including any copies, from your computer system network and destroy any
hardcopies.
Unless otherwise stated, this e-mail represents the
views of the sender and not the views of the Environmental Protection Agency.
Although this e-mail has been checked for the presence of computer viruses, the
Environmental Protection Agency provides no warranty that all viruses have been
detected and cleaned. Any use of this e-mail could harm your computer system.
It is your responsibility to ensure that this e-mail does not contain and is
not affected by computer viruses, defects or interference by third parties or
replication problems (including incompatibility with your computer system).
E-mails sent to and from the Environmental Protection Agency will be
electronically stored, managed and may be audited, in accordance with the law
and Queensland Government Information Standards (IS31, IS38, IS40, IS41 and
IS42) to the extent they are consistent with the law.
__ ____ ____ ____ ____ ____
--
http://www.freelists.org/webpage/oracle-l
Fairlie Rego
Senior Oracle Consultant
http://el-caro.blogspot.com/
M: +61 402 792 405
National Bingo Night. Play along for the chance to win $10,000 every week.
Download your gamecard now at Yahoo!7 TV.
<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head>
<body><div style="font-family:times new roman, new york, times, serif;font-size
:12pt"><div style="font-family: times new roman,new york,times,serif; font-size:
12pt;"><span>I'm not an RM expert, but I did learn a lot from the live webcast
session that the RAC SIG had last week titled "Using Resource Manager for
Managing Mixed Workloads". I'm working on getting the recorded version of that
posted on the RAC SIG website (<a target="_blank" href="http://www.oracleracsig
.org">www.oracleracsig.org</a>). Once you sign up with the SIG, you can playback
any of the recorded sessions on demand at any time. I hope to have this session
's recording posted before the end of next week along with the presentation
slides from the session too.</span><br><br>Fairlie, I suspect that the session
was conducted by some of the people you spoke with in SF - Sue Lee and I don't
remember the name of the
other technical person that did the 2nd half of the session, but he seemed to
know his stuff pretty well. <br><br>Watch the site for the playback link to be
posted in the next week if you're interested. <br><br>Dan<br><br><div style=
"font-family: times new roman,new york,times,serif; font-size: 12pt;">-- --
Original Message ----<br>From: fairlie rego <fairlie_r@(protected)><br>To:
tony.vanlingen@(protected)<br>Cc: oracle-l@(protected)<br>Sent: Thursday,
November 1, 2007 1:11:31 AM<br>Subject: Re: How to map a client program to a
Resource Manager consumer group<br><br>
<div>Hi Tony,</div> <div> </div> <div>I have attached a sample script in
a separate email. The script creates a plan and consumer groups.</div> <div>
<br>One of the sites I am working on has had limited success with RM.<br>There
have been a couple of times it has bailed us out but on more<br>than one
occassion we have had sessions stuck in resmgr: cpu quantum<br>even when the
CPU on the box is at 50% idle.<br></div> <div>I spent a day with the RM
development team in San Fran last month<br>identifying issues in the product.
Unfortunately most of these I believe are unpublished.</div> <div> </div>
<div>The feature in RM to throttle sessions works fine.<br>There are times
when RM does not kick in even when load is nearing 100%<br>Also RM also does
not function properly on machines with more than 8 cpus.</div> <div> <
/div> <div>Thanks<br>Fairlie<br><br><b><i>Tony van Lingen <tony.vanlingen
@(protected)></i></b> wrote:</div>
<blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255);
padding-left: 5px; margin-left: 5px;">Fairlie,<br><br>That's not encouraging. I
did do some digging on Metalink and Google, <br>but the only bugs I was able to
find related to problems with mapping <br>priorities. Can you give me an idea
of the bugs that you found? Are they <br>so bad that you would not use RM in a
production environment at all? <br>What do other people think about this?<br>
<br>Cheers,<br>Tony<br><br>fairlie rego wrote:<br>> I second Peter's comment
and I can give you umpteen number of bugs <br>> which I have logged and know
of in the RM subject area and I seriously <br>> doubt whether 11g has fixed
many of them<br>> <br>> Thanks<br>> Fairlie<br>><br>> */Peter
McLarty /* wrote:<br>><br>> Hi Tony<br>> From a conversation I had
with a guy from Oracle a few months<br>> back, you are probably seeing a few
bugs with resource
manager.<br>><br>> He
suggested anyone who really wanted to get stuff working to use 11g<br>><br>
> Apparently there are a few gremlins there<br>><br>> Cheers<br>><br
>> Peter<br>><br>> -- --Original Message-- --<br>> From: Tony van
Lingen [mailto:tony.vanlingen@(protected)]<br>> Sent: Wed 10/31/2007 10
:30 AM<br>> To: oracle-l@(protected)<br>> Subject: Re: How to map a
client program to a Resource Manager<br>> consumer group<br>><br>>
Morning List.<br>><br>> Hmm, not a single answer... does that mean that
nobody actually<br>> uses the<br>> resource manager? What is good
practice here.. If you use the<br>> resource<br>> manager at all, how do
you map user sessions to consumer groups?<br>> Is it<br>> even advisable
to use CLIENT_PROGRAM?<br>><br>> All suggestions welcome.<br>><br>>
Cheers.<br>> Tony<br>><br>><br>> *Fairlie Rego<br>> *Senior
Oracle Consultant<br>>
<a target="_blank" href="http://el-caro.blogspot.com/">http://el-caro.blogspot
.com/</a><br>> M: +61 402 792 405<br>> <br>><br>> -- ---- ---- -----
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------<br><br><br>__ ____ ______
__ ____ _____<br>Disclaimer<br><br>WARNING: This e-mail (including any
attachments) has originated from a Queensland Government department and may
contain information that is confidential, private, or covered by legal
professional privilege, and may be protected by copyright. <br><br>You may use
this e-mail only if you are the person(s) it was intended to be sent to and if
you use it in an authorised way. No one is allowed to use, review, alter,
transmit, disclose, distribute, print or copy this e-mail without appropriate
authority. If you have received this e-mail in error, please inform the sender
immediately by phone or e-mail and delete this e-mail, including any copies,
from your computer system network and destroy
any hardcopies.<br><br>Unless otherwise stated, this e-mail represents the
views of the sender and not the views of the Environmental Protection Agency.
<br><br>Although this e-mail has been checked for the presence of computer
viruses, the Environmental Protection Agency provides no warranty that all
viruses have been detected and cleaned. Any use of this e-mail could harm your
computer system. It is your responsibility to ensure that this e-mail does not
contain and is not affected by computer viruses, defects or interference by
third parties or replication problems (including incompatibility with your
computer system).<br><br>E-mails sent to and from the Environmental Protection
Agency will be electronically stored, managed and may be audited, in accordance
with the law and Queensland Government Information Standards (IS31, IS38, IS40,
IS41 and IS42) to the extent they are consistent with the law.<br><br>__ ______
__ ____ ____ _____<br><br>--<br><a target="_blank"
href="http://www.freelists.org/webpage/oracle-l">http://www.freelists.org
/webpage/oracle-l</a><br><br><br></blockquote><br><br><br><div> <div> <div>
<div> <div> <div><strong>Fairlie Rego<br></strong>Senior Oracle Consultant<
/div> <div><font face="comic sans ms"><a rel="nofollow" target="_blank" href=
"http://el-caro.blogspot.com/">http://el-caro.blogspot.com/</a></font></div>
<div><font face="Comic Sans MS">M: +61 402 792 405</font></div> <div> <
/div></div></div></div></div></div><p>
</p><hr size="1">
National Bingo Night. Play along for the chance to win $10,000 every week. <a
rel="nofollow" target="_blank" href="http://au.rd.yahoo.com/mail/taglines
/default_all/bingo/*http://au.blogs.yahoo.com/national-bingo-night/">Download
your gamecard now at Yahoo!7 TV</a>.
</div><br></div></div></body></html>
|
|
|