hugepages question
From: Jeff Chirco <backseatdba_at_gmail.com>
Date: Wed, 13 Feb 2019 16:10:29 -0800
Message-ID: <CAKsxbLruOX9YobaBY8D2wdd6BTeRQREn8zrfn8c_apOr43-k6Q_at_mail.gmail.com>
Ok I just recently enabled hugepages on Production and Development. Everything is going good but I noticed that on my development environment which consists of a bunch of thin clones, when I remove and recreate the same clone the database fails to create, I am getting:
Date: Wed, 13 Feb 2019 16:10:29 -0800
Message-ID: <CAKsxbLruOX9YobaBY8D2wdd6BTeRQREn8zrfn8c_apOr43-k6Q_at_mail.gmail.com>
Ok I just recently enabled hugepages on Production and Development. Everything is going good but I noticed that on my development environment which consists of a bunch of thin clones, when I remove and recreate the same clone the database fails to create, I am getting:
ORA-27137: unable to allocate large pages to create a shared memory segment
I have the parameter *use_large_pages=ONLY* So it makes sense I would get this error when there is not enough pages. However I just removed this same database and am recreating it. I would think that would free it up but apparently not. Does pages not get released immediately when a database is removed? Is there something I should run to free it? Or just not have use_large_pages=ONLY and leave it at TRUE on Dev? I had to set it to TRUE to get this database up.
Thanks,
Jeff
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 14 2019 - 01:10:29 CET