4 Replies Latest reply on Jan 19, 2016 3:54 PM by Pravin Takpire

    What is the Recommended and Optimal SGA and PGA size R12?

    Karthik Appsys

      Dear Legends,


      We have the below environment for 1 of our client.

      OS: Oracle Linux 6.5 64 Bit

      EBS: R12.1.3 DB:

      RAM 80GB with 3TB HDD and 24Cores CPU


      As of now we upgraded the Database from 10g to 12c, till now the SGA and PGA has not been tuned after the upgrade. Please suggest on the SGA and PGA recommendation for the above environment.


      Current SGA & PGA as follows


      SQL> show parameter sga


      NAME                                 TYPE        VALUE

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

      lock_sga                             boolean     FALSE

      pre_page_sga                         boolean     TRUE

      sga_max_size                         big integer 2G

      sga_target                           big integer 2G

      unified_audit_sga_queue_size         integer     1048576


      SQL> show parameter pga


      NAME                                 TYPE        VALUE

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

      pga_aggregate_limit                  big integer 8G

      pga_aggregate_target                 big integer 4G



      I would like to go with the Best optimal performance, so that none of the Users will face any RESOURCE BUSY or DEADLOCKS or ANY Memory issues.