Re: DB memory parameter question

Hi Jeff,

In order to use huge pages you should use ASMM, so you should define sga_target, sga_max_target, pga_aggregate_target and don't forget about setting the parameter use_large_pages to true.

Regards

On Tue, Feb 12, 2019 at 7:07 PM Jeff Chirco <backseatdba_at_gmail.com> wrote:

> Ok from what I have read in various documents and experienced it is not a
> good idea to use memory_target anymore, or at least on databases with large
> memory. Plus if you want to use huge pages you can’t. What about
> sga_target, sga_max_target, and pga_aggregate_target? Do I set those or
> still no and just set each individual SGA memory area?
>
>
>
> I recently migrated over from Windows to Oracle Linux, running 12.2.0.1 EE.
>
>
>
> Thanks
>
> Jeff
>

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