search

gvenzl / oci-oracle-xe

Build scripts for Oracle Database XE container/docker images
Apache License 2.0
270 stars 76 forks source link

how to set DISK_ASYNCH_IO=FALSE before startup? #211

Closed mysteryboy2000 closed 1 year ago

mysteryboy2000 commented 1 year ago

I found a significant speed up on my docker container if I do below change. ALTER SYSTEM SET DISK_ASYNCH_IO=FALSE SCOPE=SPFILE SID='*';

I make this change in the init.sql in /container-entrypoint-initdb.d/ but it looks like it will not take effect after the first container startup. it required a restart.

how to simply make the changes in the init.sql soon take effect ? thanks.

gvenzl commented 1 year ago

Hey @mysteryboy2000,

That's an interesting observation, could you share a bit more about the details of your environment and where you are running these containers?

As to setting this parameter to false, yes, the database requires a restart as per the Oracle Database documentation.

If you want an image that has a database already set with that parameter to false you would have to extend the image, set the parameter to false, and save that as a new image.

kaiei-chou commented 1 year ago

I am using M1 macbook pro with colima qemu comination. the image I am using is 11.2.0.2-slim-faststart which is created by respected Mr. gvenzl 😄