Re: How to map a client program to a Resource Manager consumer group

  • From: fairlie rego <fairlie_r@xxxxxxxxx>
  • To: tony.vanlingen@xxxxxxxxxxxxxx
  • Date: Thu, 1 Nov 2007 17:11:31 +1100 (EST)

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@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx]
> Sent: Wed 10/31/2007 10:30 AM
> To: oracle-l@xxxxxxxxxxxxx
> 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.

___________________________

--
//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.

Other related posts: