RE: Prevent ASM from using any hugepages
Date: Fri, 17 May 2013 19:48:52 +0000
Message-ID: <7cf085102e734fe197c425427f0b47c9_at_BLUPR08MB119.namprd08.prod.outlook.com>
Sorry, forgot that MEMORY_TARGET is not available in 10g
I don't have any 10gRAC anymore, and very few 10g databases at all, so, I'm also not sure if 10g has "use_large_pages" parameter? If so, set it to FALSE. (Possible values are FALSE, TRUE, and ONLY.) But, if I recall correctly, that parameter is not in 10g....
Guess it's not possible, in 10g, to use hugepages, but *not* for ASM?
-Mark
-----Original Message-----
From: Christopher.Taylor2_at_parallon.net [mailto:Christopher.Taylor2_at_parallon.net]
Sent: Friday, May 17, 2013 3:42 PM
To: Bobak, Mark
Cc: oracle-l_at_freelists.org; ora_kclosson_at_yahoo.com
Subject: RE: Prevent ASM from using any hugepages
You can't set sga_target in 10g ASM and I knew ASM used AMM in form or fashion - so it was confusing me that it was reserving any hugepage entries.
-----Original Message-----
From: Bobak, Mark [mailto:Mark.Bobak_at_proquest.com]
Sent: Friday, May 17, 2013 2:39 PM
To: Taylor Christopher - Nashville; odenysenko_at_gmail.com
Cc: oracle-l_at_freelists.org; ora_kclosson_at_yahoo.com
Subject: RE: Prevent ASM from using any hugepages
Chris,
Just use AMM (MEMORY_TARGET) for ASM, and it *can't* use hugepages. That's the default set up, anyhow. So, just install ASM and forget it, and it won't touch any hugepages.
That's how I have all my boxes set up.
I have to add:
Just got back from GLOC, had some discussions about hugepages with a few folks. Still surprises me how many people don't bother with hugepages!
My three rules about hugepages are as follows:
1.) If you're not using hugepages, you're doing it wrong. Period. (Yes, ok, for very tiny databases and low loads, it may not be worth the time. But, what if that database gets busier over time? Just get used to doing it on all your databases.) 2.) #1 doesn't apply to ASM instances. 3.) 'alter system set use_large_pages = ONLY;' is your friend.
-Mark
-----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: Friday, May 17, 2013 3:13 PM
To: odenysenko_at_gmail.com
Cc: oracle-l_at_freelists.org; ora_kclosson_at_yahoo.com
Subject: RE: Prevent ASM from using any hugepages
I'd have to defer to other experts on whether it makes much difference to have ASM in hugepages. From what I've read, there's really not much reason to have asm using any hugepages. Chris
From: Oleksandr Denysenko [mailto:odenysenko_at_gmail.com]
Sent: Friday, May 17, 2013 2:09 PM
To: Taylor Christopher - Nashville
Cc: oracle-l_at_freelists.org; ora_kclosson_at_yahoo.com
Subject: RE: Prevent ASM from using any hugepages
Taylor,
ASM uses memory anyway so why not give hugepages to it ? I see at least one benefit - if there will be paging on the system your ASM's SGA will not be paged out.
Oleksandr Denysenko
17.05.2013 21:56 пользователь <Christopher.Taylor2_at_parallon.net<mailto:Christopher.Taylor2_at_parallon.net>> написал:
The reason for this question was nitpicky - ASM is using about 14 hugepages when it starts up which isn't much. Just kind of annoyed me - probably due to lack of sleep lol
Chris
-----Original Message-----
From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> [mailto:oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>] On Behalf Of Christopher.Taylor2_at_parallon.net<mailto:Christopher.Taylor2_at_parallon.net>
Sent: Friday, May 17, 2013 11:29 AM
To: oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>
Subject: Prevent ASM from using any hugepages
Guys/Gals,
I'm in the process of configuring hugepages in 10.2.0.4 RAC.
Since ASM starts up first, how I do prevent it from using any of the hugepages?
Regards!
Chris Taylor
Oracle DBA
Parallon IT&S
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 17 2013 - 21:48:52 CEST