Oracle B12255-01 - Manual (Page 117)

mod_plsql
Oracle HTTP Server Modules 7-47
PlsqlSesssionStateManagement Specifies 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 modified 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 configuration 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