For applications having a large number of concurrent users, maintaining optimal performance is critical. To optimize your application's performance, remember to use the following features:
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. See "Referencing Session State Using Bind Variable Syntax."
Include a #TIMING# substitution string in the region footer so that you can view the timing of each region. See "Understanding Substitution Strings."