DB memory parameter question
From: Jeff Chirco <backseatdba_at_gmail.com>
Date: Tue, 12 Feb 2019 11:05:13 -0800
Message-ID: <CAKsxbLr9ANnzR=hzHT5dwYVsQnuoVGtFhPNoT2OEMc3yXmp-Sg_at_mail.gmail.com>
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?
Date: Tue, 12 Feb 2019 11:05:13 -0800
Message-ID: <CAKsxbLr9ANnzR=hzHT5dwYVsQnuoVGtFhPNoT2OEMc3yXmp-Sg_at_mail.gmail.com>
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-lReceived on Tue Feb 12 2019 - 20:05:13 CET