RE: Hugepages usage

From: Weiss, Andy <"Weiss,>
Date: Wed, 12 Feb 2020 17:18:31 +0000
Message-ID: <DF4PR8401MB109987BD60106683530A425DEA1B0_at_DF4PR8401MB1099.NAMPRD84.PROD.OUTLOOK.COM>



Hey Chris,

Do you happen to have link to more information or an MOS number handy? The web folks have been complaining about JDBC connection issues. While I am not too fond of it, there may be crow for dinner.

Andy

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Chris Taylor Sent: Tuesday, February 11, 2020 18:25
To: gogala.mladen_at_gmail.com
Cc: ORACLE-L <oracle-l_at_freelists.org> Subject: Re: Hugepages usage

I don't know if Oracle fixed this her or not, but pre_page_sga wreaks havoc on JDBC connections. It possible that JDBC "feature" has been fixed but if you run into it's a real PITA.

Chris

On Mon, Feb 10, 2020, 7:34 PM Mladen Gogala <gogala.mladen_at_gmail.com<mailto:gogala.mladen_at_gmail.com>> wrote: Pre-paging SGA will slow down your DB considerably. 32 GB is a small SGA,but it will still slow down the startup of your database.

On 2/10/20 6:43 PM, Ram K wrote:

> pre_page_sga boolean TRUE

--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217

--
http://www.freelists.org/webpage/oracle-l<http://www.freelists.org/webpage/oracle-l>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Feb 12 2020 - 18:18:31 CET

Original text of this message