About Best Practices to Improve Performance

Improve performance by using bind variables and monitor performance by using dashboards in Workspace Administration or querying APEX dictionary views.

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.

• Monitor application performance including page rendering time using reports in Workspace Administration, Monitor Activity. You can also query the APEX_WORKSPACE_ACTIVITY_LOG dictionary view. Application performance data is available when application activity logging is enabled.

See Also:

• Referencing Session State Using Bind Variable Syntax

• Using Substitution Strings

• Using the Attribute Dictionary

• Monitoring Activity Within a Workspace and Viewing Workspace Dashboards in Oracle APEX Administration Guide