Corporation Server User Manual

mod_plsql

Oracle HTTP Server Modules 7-47

PlsqlSesssionStateManagement Speciﬁes how package and session state should

be cleaned up at the end of each mod_plsql request.

■ Setting this parameter to StatelessWithResetPackageState causes mod_

plsql to call dbms_session.reset_package_state at the end of each

mod_plsql request.

■ Setting this parameter to StatelessWithPreservePackageState causes

mod_plsql to call htp.init at the end of each mod_plsql request. This

cleans up the state of session variables in the OWA Web ToolKit. The PL/SQL

application is responsible for cleaning up its own session state. Failure to do so

causes erratic behavior, in which a request starts recognizing or manipulating

state modiﬁed in previous requests.

■ Setting this parameter to StatelessWithFastResetPackageState causes

mod_plsql to call dbms_session.modify_package_state(dbms_

session.reinitialize) at the end of each mod_plsql request. This API is

a lot faster than the mode of StatelessWithResetPackageState, and

avoids some latch contention issues, but exists only in database versions 8.1.7.2

and higher. This mode uses up slightly more memory than the default mode.

Notes:

■ In older versions of the product, this conﬁguration parameter was called

stateful.

■ An older value of stateful=no or stateful=STATELESS_RESET

corresponds to PlsqlSessionStateManagement

StatelessWithResetPackageState.

■ An older value of stateful=STATELESS_FAST_RESET corresponds to

PlsqlSessionStateManagement

StatelessWithFastResetPackageState.

Category Value

Syntax PlsqlSessionStateManagement

StatelessWithResetPackageState/StatelessWithFas

tResetPackageState/StatelessWithPreservePackage

State

Default

StatelessWithResetPackageState

Example PlsqlSessionStateManagement

StatelessWithResetPackageState