A
A
andrei20182018-05-26 18:05:59
Oracle
andrei2018, 2018-05-26 18:05:59

Why is memory taken as much as possible when creating a database?

This is an Oracle Database Assistant and Hyper-V question.
For the first time I put Oracle 12c on Windows2016 Hyper-V, guest Windows 2008 server R2.
Previously (without Hyper-V), the database in the "assistant" was created without problems, but now for some reason I can not create it - it says that there is not enough memory. Physical I have 8 GB. One virtual machine. Orakl was established in half an hour, did not swear.
But here at start of "assistant" problems began. I have already assigned 5.5 GB out of 8 to the virtual machine (since it did not start at 6), but it still says that there is not enough memory to create the database, and finally I just decided to Create a database:
- the processor on the virtual machine is 100% busy (Oracle RDBMS Kernel Executable).
- the memory is taken almost to the maximum (I assign 5.5 GB to the virtual machine, and in the Performance of the guest it shows that 4.8 out of 5.4 is occupied, 534 MB is available).
- At the same time, on a physical machine, Hyper-V Manager shows for this virtual machine that only 1500-1800 MB from 8GB and CPU-8-13% (3GHz 2x core) are occupied.
The base has been created. Now the processor is not busy, but the memory is still occupied by 87% (4.7 from 5.4GB) for some reason - the largest process is Oracle 574MB, then Java 100MB, the rest are 50MB in total.
What am I doing wrong - why is the virtual processor so busy and why is the memory being consumed to the maximum? Or does Hyper-V+ DBA just need more powerful hardware?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
andrei2018, 2018-05-26
@andrei2018

I overloaded. The processor is free. Processes occupy no more than 50-60MB of memory, but the memory is occupied by 91% (4.9\5.4GB).
Removed dynamic memory. Everything became normal. Thanks!!!

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question