RE: Hugepages question with multiple instances on 1 host
Date: Mon, 29 Apr 2013 11:50:24 -0400
Message-ID: <6AFC12B9BFCDEA45B7274C534738067F018DC7613C_at_AAPQMAILBX02V.proque.st>
Also, consider, if you're going through the trouble of configuring hugepages, you might as well do it for all instances.
While it's true that you'd probably want hugepages configured for a system w/ a 32GB SGA, and it's probably not necessary to do so for the 4GB SGA, there's really no harm in configuring hugepages for both. There's really no downside.
My rule of thumb, when it comes to hugepages is that if you're not using them, you're doing it wrong, with the one exception being ASM instances.
-Mark
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of CRISLER, JON A
Sent: Monday, April 29, 2013 11:39 AM
To: Christopher.Taylor2_at_parallon.net; afatkulin_at_gmail.com
Cc: oracle-l_at_freelists.org
Subject: RE: Hugepages question with multiple instances on 1 host
If your on 10g, then the simplest way is just to allocate hugepages for all instances. This can get a bit tricky and irritating if your just trying to get one instance into hugepages
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Christopher.Taylor2_at_parallon.net
Sent: Monday, April 29, 2013 10:39 AM
To: afatkulin_at_gmail.com
Cc: oracle-l_at_freelists.org
Subject: RE: Hugepages question with multiple instances on 1 host
Yep right now we're on 10.2. Good to know about the 11g parameter. It was the OS limits that had me thinking it would be all instances and I had considered (briefly) to have different accounts to start the oracle instances and discarded that idea due to the lack of simplicity.
Thanks again Alex.
Chris
From: Alex Fatkulin [mailto:afatkulin_at_gmail.com]
Sent: Monday, April 29, 2013 9:29 AM
To: Taylor Christopher - Nashville
Cc: ORACLE-L
Subject: Re: Hugepages question with multiple instances on 1 host
You sure can,
if you're on 11.2 then you can specify use_large_pages=only for DB1 and use_large_pagesúlse on DB2.
On previous version it'll be a little bit trickier -- probably the easiest way is to start DB1 _before_ you start DB2 so DB1 can claim all the huge pages leaving DB2 with only regular pages to allocate. That is unless you want to setup two different users and do it via OS limits.
On Mon, Apr 29, 2013 at 10:19 AM, <Christopher.Taylor2_at_parallon.net<mailto:Christopher.Taylor2_at_parallon.net>> wrote:
I think this is a quick question.
As I'm going through the hugepages information, I'm trying to figure out if you can, or cannot, have multiple instances on 1 host running different configurations?
Such as
DB_1 running hugepages (32GB SGA)
DB_2 running regular pages (4GB SGA)
It seems that all instances will need to be in hugepages?
Thanks
Chris Taylor
Oracle DBA
Parallon IT&S
--
http://www.freelists.org/webpage/oracle-l
--
Alex Fatkulin,
http://afatkulin.blogspot.com
Enkitec,
http://www.enkitec.com
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Apr 29 2013 - 17:50:24 CEST