Oracle database help

Posted on 2014-07-23
Medium Priority
Last Modified: 2014-07-24
We currently have Oracle 11G with a single database running on a virtual machine in an ESXi 5 server.  We want to create another database for reporting.  There is potential that the reporting database is going to be very processor intensive and we are afraid it would affect the performance of the existing database.  With that said, would it be a good idea to create a new virtual machine with its own instance of Oracle installed instead of creating a new database on the existing instance?  Is it possible to isolate resources so that one database cannot use all of them?
Question by:NytroZ
LVL 78

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 1000 total points
ID: 40215555
You can probably do this at the database level but probably better controlled through VMWare.  I'll let the VMWare Experts comment on that.

In Oracle you can tell an instance how much CPU it can have.  This is called "Instance Caging":

Amount of memory is controlled through the spfile paramaters.

Instead of worrying about data migration between the online and reporting database also check the link above and look into consumer groups.

You can tell the 'reporting' sessions they are a lower priority and maybe use the single database for everything.
LVL 124

Accepted Solution

Andrew Hancock (VMware vExpert / EE MVE^2) earned 1000 total points
ID: 40215637
I would create a new VM for this Reporting Database.

You can set resources on CPU and Memory, so the CPU and Memory are GUARANTEED, e.g. ringfenced so resources CPU and Memory are taken away from the VM.

So on the original Oracle DB VM, set Reservations for CPU and Memory.

It's called setting CPU and Memory Reservsations.

Featured Post

Put Machine Learning to Work--Protect Your Clients

Machine learning means Smarter Cybersecurity™ Solutions.
As technology continues to advance, managing and analyzing massive data sets just can’t be accomplished by humans alone. It requires huge amounts of memory and storage, as well as the high-speed power of the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I will show you HOW TO: Suppress Configuration Issues and Warnings Alert displayed in Summary status for ESXi 6.5 after enabling SSH or ESXi Shell.
Ransomware is a malware that is again in the list of security  concerns. Not only for companies, but also for Government security and  even at personal use. IT departments should be aware and have the right  knowledge to how to fight it.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question