5 Replies Latest reply on Jul 12, 2016 1:16 PM by 2907350

    test instance slow

    2907350

      EBSR12.2.4

      Oracle Database 11.2.0.3

      Oracle Linux 6.5

       

      Hi,

       

      users are complaining on slowness on the system - forms are taking time to process data...

      There is 32 bg memory on the system. Below is the configurations for the database:

       

      processes                            integer     3000

      processor_group_name                 string

       

      sessions integer 6000

       

      open_cursors                         integer     6000

       

      memory_max_target                    big integer 19G

      memory_target                        big integer 19G

       

      sga_max_size                         big integer 19G

      sga_target                           big integer 0

       

       

      Weblogic:

      forms_server1:

      -XX:PermSize=1024m -XX:MaxPermSize=1024m -Xms1024m -Xmx1024m -Djava.security.policy=/u01/oracle/PROD/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.policy -

       

      Is the above configuration correct?

       

      Regards,

      Joe