locked
Dynamic Memory assignment: Oracle DB RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi There,

    I have a client who is running Hyper-V on Server 2008 R2.  Last night I did some updates, and part of that was changing the VMs to use "Dynamic" memory allocation.  I set the minimum/startup to 1GB and maximum to whatever the VM's static allocation was.

    Today, one of their applications would not work.  It turns out it relies on an Oracle DB.  The Oracle DB was not able to start because it was running out of memory.  The VM in question (that has the Oracle DB) was set with a maximum of 16GB, however, it was only getting about 1.72GB assigned.

    Is there any reason this VM was not getting RAM that it needed assigned to it as it needed it?

    Thanks!

    -Alan

    Thursday, August 20, 2015 12:01 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    Well if you were using MS SQL I would say to look at this link as it has some good information on using Dynamic memory for SQL, mind you only certain editions support this. However from this document it looks like Oracle does not support Dynamic memory on their products.

    Britt

    • Proposed as answer by Alex Lv Wednesday, August 26, 2015 8:11 AM
    • Marked as answer by Alex Lv Monday, September 7, 2015 6:14 AM
    Thursday, August 20, 2015 4:25 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Well if you were using MS SQL I would say to look at this link as it has some good information on using Dynamic memory for SQL, mind you only certain editions support this. However from this document it looks like Oracle does not support Dynamic memory on their products.

    Britt

    • Proposed as answer by Alex Lv Wednesday, August 26, 2015 8:11 AM
    • Marked as answer by Alex Lv Monday, September 7, 2015 6:14 AM
    Thursday, August 20, 2015 4:25 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    My gut feeling is that the application OracleDB is not dynamic memory compatible.

    I would guess that your startup RAM is set at 2048MB  and that is all that the application can 'see'.

    Brian Ehlert
    http://ITProctology.blogspot.com
    Learn. Apply. Repeat.

    • Proposed as answer by Alex Lv Wednesday, August 26, 2015 8:11 AM
    Thursday, August 20, 2015 3:10 PM