22.1 About Best Practices to Improve Performance

Improve performance by using bind variables and including a #TIMING# substitution string in the region footer.

For applications having a large number of concurrent users, maintaining optimal performance is critical. Best practices to consider include:

  • Use bind variables within your application whenever possible. You can reference session state values using bind variable syntax in SQL queries and application logic such as PL/SQL executed from processes and validations. Accessing session state using bind variables is the most efficient way to reference session state.
  • Include a #TIMING# substitution string in the region footer so that you can view the timing of each region.