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

jeremy wrote:
> 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

Look at creating CONSUMER GROUPS and using the built in RESOURCE MANAGEMENT capabilities. Docs at http://tahiti.oracle.com ... look up DBMS_RESOURCE_MANAGER built-in package.

You can to go http://www.psoug.org/library.html and look up both DBMS_RESOURCE_MANAGER and CONSUMER GROUPS for demos you can run and modify.

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