The Latest Oracle E-Business Suite Technology News direct from
Oracle E-Business Suite Development & Product Management

Recommended Database Parameters Updated for EBS 12

Guest Author

Close on the heels of our recent updates to the recommended EBS 11i Database parameters, our database and applications performance architects have published updates for EBS Release 12. The updated note is now available here:

Our architects have refreshed a large number of recommended settings based upon customer feedback and their ongoing performance and scalability tests.


New updates

  • Removal of Application Upgrade Considerations section.
  • Addition of Advanced Queuing (AQ) note to common parameters.
  • Addition of note to the job_queue_processes
  • Addition of diagnostic_dest to 11gR1-specific parameters.
  • Addition of background_dump_dest, user_dump_dest, core_dump_dest to 11gR1 removal list.
  • Addition of plsql_native_library_dir, plsql_native_library_subdir_count, plsql_optimize_level to 11gR1 removal list.
  • Addition of #MP to _optimizer_autostats_job=false.
  • Updates to undo_retention section.
  • Addition of Timed_Statistics.
  • Addition of nls_language, nls_length_semantics, _sqlexec_progression_cost.
  • Removal of nls_length_semantics.
  • Removal of SGA_TARGET from Sections 2, 3, and 4, as this is in the common parameters.
  • Removal of db_block_buffers row from sizing table.
  • Updates to "Specific Notes on Table."
  • Updates to common parameters introduction.

As we've noted before, these changes are extremely important and can have profound impact on the performance of your Apps database.  All Apps DBAs should spend some quality time comparing your current database settings with the latest recommendations in this document.

Related Articles

Join the discussion

Comments ( 13 )
  • Joshua Hernandez Thursday, September 17, 2009

    Thank you for the update Prasad.

    I have one question and one comment on these parameters.

    First the question, is the use of AMM (memory_target) supported or recommended for use when running R12 on 11g? We recently went live on using AMM but reverted back to ASMM (sga_target) due to performance issues in our custom programs. We have recently upgraded to but have not tested going back to AMM.

    The comment, for those upgrading from to remember to set all of the hidden parameters back to the recommended values. Interoperability Notes Oracle E-Business Suite Release 12 with Oracle Database 11g Release 1 (Doc 735276.1) does not mention it but you will find that the upgrade will reset these parameters and if you run your production without these parameters you will experience very poor system performance.

  • Prasad Akkiraju Thursday, September 17, 2009


    Thanks for the comment. MEMORY_TARGET is not certified with EBS yet. Our architects would like to hold off on it until large workloads are run. Looks like it will be of less benefit for EBS customers unless they use it in virtualized environments.

    Regarding the resetting of parameters, I will have it checked and updated in the interop note.


  • Dominic West Wednesday, November 18, 2009

    Hi, slightly off-topic but ...

    The O/S requirements have changed from 11i -> 12 with regards to the ulimits.

    the ulimit -s for 11i seems to be the same as for 10gR2 DB i.e ulimit -s => 32768

    For Apps 12 the documentation has changed to ulimit -s unlimited.

    This is causing me some problems on a Solaris 9/10 box as the stack is reserving 2G of space and in a JVM this leaves only about 1.7G for heap space. This size JVM is too small for some BI Publisher reports.

    Is there a neccesity for ulimit -s to be unlimited ? If not can you recommend a value? . An SR has already been raised with Support (and Sun) but there didn't seem to be a definitive answer.



  • Carl Busch Monday, February 21, 2011

    Has the MEMORY_TARGET been certified with EBS yet?

  • Prasad Akkiraju Monday, February 21, 2011

    Not yet. Our performance team's general guideline is that it will not be of benefit for medium to large systems, might be useful in small or development deployments. There is a plan to add details in the init.ora note, but it is not of high priority.

  • guest Wednesday, March 7, 2012

    Any update on Memory_target certification?

  • Steven Chan Friday, March 9, 2012

    Hi, Guest,

    Note 396009.1 was revised last December with this addition:

    Footnote 1


    The parameter sga_target should be used for Oracle 10g or 11g based environments such as Release 12. This replaces the parameter db_cache_size, which was used in Oracle 9i based environments. Also, it is not necessary to set the parameter undo_retention for 10g or 11g-based systems, since undo retention is set automatically as part of automatic undo tuning.

    Enabling the 11g Automatic Memory Management (AMM) feature is supported in EBS, and has been found to be useful in scenarios where memory is limited, as it will dynamically adjust the SGA and PGA pool sizes. AMM is enabled by using the memory_target and memory_max_target initialization parameters. MEMORY_TARGET specifies the system-wide sharable memory for Oracle to use when dynamically controlling the SGA and PGA as workloads change. The memory_max_target parameter specifies the maximum size that memory_target may take. AMM has proven useful for small to mid-range systems as it simplifies both the configuration and management. However, many customers with large production systems have experienced better performance with manually sized pools (or large minimum values for the pools). On Linux, Hugepages has resulted in improved performance; however, this configuration is not compatible with AMM. For large mission-critical applications systems, it is advisable to set sga_target with a minimum fixed value for shared_pool_size and pga_aggregate_target.



  • guest Wednesday, October 31, 2012

    Hi Steven,

    We are in the middle of the 11.5.10 to 12.1.3 upgrade. Oracle database is If we use AMM by setting the memory_target, we are debating whether there is any issue/need in setting the SGA_TARGET?





  • Prasad Akkiraju Tuesday, November 6, 2012


    The response from the performance team is that memory_target is not recommended for large production systems. sga_target is a subset of memory_target. If you have specific values set for shared pool size and db cache, those values together would limit to sga_target if you set, despite having a higher memory_target. So better not set sga_target in case you want to use memory_target.



  • Dave Tuesday, August 2, 2016

    12c of the database allows varchar2 to be 32767 instead of 4000 if you set the init.ora parameter max_string_size to be EXTENDED (instead of STANDARD).

    There is no mention of this parameter in note 396009.1.

    Is it supported to set max_string_size to EXTENDED if running 12.2.5 against 12c?

  • Steven Chan Wednesday, August 3, 2016

    Hello, Dave,

    I don't think that you need to alter this setting for standard EBS operations. What is your business case for changing this?



  • Dave Wednesday, August 3, 2016

    It would be for a custom / 3rd party application residing in custom schema on EBS instance that wants to define 4000 < varchar2 column < 32767 as opposed to defining the column explicitly as a LOB.

  • Steven Chan Tuesday, August 30, 2016

    Hello, Dave,

    It took a while for our architects to review this, but it came through eventually.

    As a general rule of thumb, if it isn't included in Note 396009.1, EBS customers should not use it due to the lack of testing. That is true for the EXTENDED setting for varchar2.

    We cannot support this for EBS databases due to errors such as "FRM-40831:Truncation Occurred:Value too long for field". Data would also be truncated in associated reports and the excluded section may well contain business critical or salient information.

    Your safest approach would be to create an external database for your customizations/third-party application and link it to the E-Business Suite. Our standard support policy for customizations would apply. For more information about that policy, see:

    Support Implications for Your EBS Customizations




Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.