Re: undersized SGA

Posted by Roshan on Nov 04, 2019; 7:14am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/undersized-SGA-tp7823p7824.html

In case RAM needs not to be increased, by how much can I increase SGA?

NAME                 TYPE        VALUE

-------------------- ----------- -----

pga_aggregate_limit  big integer 9000M

pga_aggregate_target big integer 3726M

 

NAME                         TYPE        VALUE  

---------------------------- ----------- -------

allow_group_access_to_sga    boolean     FALSE  

lock_sga                     boolean     FALSE  

pre_page_sga                 boolean     TRUE  

sga_max_size                 big integer 11200M

sga_target                   big integer 11200M

unified_audit_sga_queue_size integer     1048576