Previous Next JavaScript must be enabled to correctly display this content

## 23.1 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

Parent topic: Managing Application Performance