Re: Multiple 10g instances (standard edition) one machine / resource allocation

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 05 Sep 2007 15:49:24 -0700
Message-ID: <1189032558.544002@bubbleator.drizzle.com>

Shakespeare wrote:

> "DA Morgan" <damorgan_at_psoug.org> schreef in bericht 
> news:1189004915.590055_at_bubbleator.drizzle.com...
>> Shakespeare wrote:
>>> "jeremy" <jeremy0505_at_gmail.com> schreef in bericht 
>>> news:1188918123.470027.6110_at_57g2000hsv.googlegroups.com...

>>>> It has been suggested that we could set-up a new production
>>>> environment on 10gR2 (2 instances) using VMWARE. This would enable us,
>>>> as I understand it, to allocate the resources of the server in the
>>>> ratio we choose between the different databases as each would
>>>> effectively be running on its own machine.
>>>>
>>>> I can see that Oracle does not support installation of its products on
>>>> VMWARE
>>>> (see
>>>> https://metalink.oracle.com/metalink/plsql/f?p=130:14:8993822913808118385::::p14_database_id,p14_docid,p14_show_header,p14_show_help,p14_black_frame,p14_font:NOT,249212.1,1,1,0,helvetica
>>>> )
>>>>
>>>> So to me it would seem foolhardy to progress with that idea.
>>>>
>>>> Is there any technology in 10gR2 (Standard Edition) that enables the
>>>> allocation of a finite set of resources that may not be exceeded?
>>>>
>>>> Thanks
>>>> --
>>>> jeremy
>>>>

>>> Apart from all the licensing issues etc, I know by experience that some 
>>> Oracle products run on VMWare very well, but other DO have problems (at 
>>> least on VMWare Workstation, not sure about ESX) Oracle 10g Application 
>>> Server Infrastructure for example causes masses of Page Faults, and keeps 
>>> using 5 to 10% CPU while doing nothing (except page faults). It's a known 
>>> issue, but right: unsupported, so.....
>>>
>>> But under ESX we have seen different behaviour as well. Configs running 
>>> perfectly under 'real iron' started to show faulty behaviour when ported 
>>> to VM. (In this case, Win2003 server).
>>>
>>> So you may be replacing one problem with an other.....
>>>
>>> Shakespeare
>> Lets take as one example Oracle RAC. Oracle uses a VMWare environment to
>> teach their RAC classes. I find that horrifying as I don't think people
>> learn real-world skills in unreal environments. But obviously RAC is
>> stable running on VMWare. That does not mean it will scale and that does
>> not mean it is easy to support when configured creatively which is the
>> point of most VM environments.
>> -- 
>> Daniel A. Morgan
>> University of Washington
>> damorgan_at_x.washington.edu (replace x with u to respond)
>> Puget Sound Oracle Users Group
>> www.psoug.org
> 
> Teaching on VM is ok, you can't expect all students to buy multiple servers. 
> This does not mean one should use it as a production environment....
> 
> I'm glad you don't teach Life Saving ..... which is usally taught in unreal 
> environments (we can't kill em all, can we?)
> 
> Shakespeare
> (And I'm still glad you don't sell cars too  ;-))) 

I worked as a lifeguard for several years and taught lifesaving. We taught how to drag a person to shore by jumping into the water and dragging back a real person. Sometimes that person would pretend to be unconscious ... sometimes they would fight as if in a panic.

If this was taught using the same skill set used to teach software I imagine they'd just make you watch PowerPoint slides while someone threw buckets of water at you. <g>

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Wed Sep 05 2007 - 17:49:24 CDT