docker-images icon indicating copy to clipboard operation
docker-images copied to clipboard

Edit General_Purpose percentageMemTOSGA Parameter on build

Open vbaidak opened this issue 3 years ago • 0 comments

Hi!

I'm getting the following error when creating new PDBs:

[WARNING] ORA-04031: unable to allocate 1048848 bytes of shared memory (“shared pool”,”unknown object”,”PDB Dynamic He”,”alls-ktimcem”)

According to this article I need to change percentageMemTOSGA parameter in General_Purpose.dbc file, which is by default set to 40

How this can be done during the build?

I'm using 12.2.0.1 enterprise version

vbaidak avatar Jan 10 '22 16:01 vbaidak

@vbaidak We do not have percentageMemTOSGA parameter exposed currently, but you can set SGA and PGA manually using INIT_SGA_SIZE and INIT_PGA_SIZE options to docker run command. Using these parameters you can give absolute values instead of giving them in percentage form. This should resolve the issue. More info on these init-parameters is present in the Readme.

Closing this issue for now. Please reopen if the issue persists.

abhisbyk avatar Sep 05 '22 08:09 abhisbyk