PlsqlSessionStateManagement
Specifies how package and session state should be cleaned up at the end of each mod_plsql request.
Setting this to StatelessWithResetPackageState causes mod_plsql to call dbms_session.reset_package_state at the end of each mod_plsql request.
Setting this 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 PL/SQL Web ToolKit. The PL/SQL application is responsible for cleaning up its own session state. Failure to do so will
cause erratic behavior where one request will start seeing/manipulating state modified in previous requests.
Setting this 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 oracle® database version 8.1.7.2 and above. This mode uses up slightly more memory than the default mode. Please check the status of bug#2096244 before using this mode.
- Syntax:
- PlsqlSessionStateManagement StatelessWithResetPackageState
- PlsqlSessionStateManagement StatelessWithFastResetPackageState
- PlsqlSessionStateManagement StatelessWithPreservePackageState
- Default:
- StatelessWithResetPackageState
- Example:
- PlsqlSessionStateManagement StatelessWithResetPackageState
Tips for PlsqlSessionStateManagement
In older versions, 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
- An older value of
stateful=STATELESS_PRESERVE- corresponds to
- PlsqlSessionStateManagement StatelessWithPreservePackageState
Oracle® mod_plsql does not support stateful mode of operation. PL/SQL applications which wish to simulate stateful behavior can do so by saving state in cookies and/or in the database.