• 15. Re: ORA-04030   EBS R12.1.3
      Beauty_and_dBest

      Hi Michael and ALL,

       

      Im am confused

       

      I thought, we already have enough settings of SGA parameters.

       

      Just to clarify:

       

      Set in your init.ora:

       

      sga_target = 50G

      db_cache_size = 20G

      pga_aggregate_target = 20G

      _use_realfree_heap=TRUE

      _realfree_heap_pagesize_hint = 262144

       

       

      We only have Free -m of 70G, but the issue maybe is....we have two databases on this server   PROD and DEV database.

      Each having each own SGA setting.

       

      What do I set value now  if we have these two databases co-existing?

       

      Please help...

       

       

      Kind reagards,

      1 2 上一个 下一个