Oracle database help

Posted on 2014-07-23
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 76

    Assisted Solution

    by:slightwv (䄆 Netminder)
    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 116

    Accepted Solution

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    VMware Update Manager(VUM) “error code: 15” during ESXi 6.0 Remediate update in VUM operation
    This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
    In this video tutorial I show you the main steps to install and configure  a VMware ESXi6.0 server. The video has my comments as text on the screen and you can pause anytime when needed. Hope this will be helpful. Verify that your hardware and BIO…

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now