OAF Performance Tuning

OA Framework Performance Tuning

• BC4J and JDBC Guidelines
• SQL Tracing
• Monitor Connection Pool
• OA Framework Performance Standards

Tuning the individual queries is the right place to start. The VO_MAX_FETCH_SIZE is meant to make sure the performance is within the limits. You can use that profile to ensure that your VO doesnot return more than the limit specified. The higher the value of this profile the lesser the performance going to be, it should be carefully analysed and agreed upon.

UI rendering aspects should not have any issues with tables and advancedTables as they have paging enabled. You should be careful when rendering HGrids as the use of expand all with a lot of nodes will have performance impact which can also be reduced by using paging feature.

http://andrieshanekom.blogspot.com/2007/07/af-key-dos-and-donts-part-2-performance.html

http://bexhuff.com/2012/09/jdeveloper-memory-and-performance

https://imdjkoch.wordpress.com/2012/06/11/how-to-clear-cache-from-oracle-application-without-bouncing-listener/

http://www.oracle.com/technetwork/testcontent/o36frame-086601.html

http://oracledbascriptsfromajith.blogspot.com/2015/06/oracle-application-framework-oaf.html