Clean the ADF session store table PS_TXN

Please follow below url to find out more details. Presentation

http://docs.oracle.com/cd/E12839_01/web.1111/b31974/bcstatemgmt.htm#ADFFD1313

40.5.4 Cleaning Up Temporary Storage Tables

JDeveloper provides the adfbc_purge_statesnapshots.sql script to help with periodically cleaning up the application module state management table. You can find this file in the oracle_common subdirectory of your Oracle Middleware installation directory (for example,ORACLE_HOME\oracle_common\common\sql).

Persistent snapshot records can accumulate over time if the server has been shutdown in an abnormal way, such as might occur during development or due to a server failure. Running the script in SQL*Plus will create the BC4J_CLEANUP PL/SQL package. The two relevant procedures in this package are:

• PROCEDURE Session_State(olderThan DATE)
  This procedure cleans-up application module session state storage for sessions older than a given date.
• PROCEDURE Session_State(olderThan_minutes INTEGER)
  This procedures cleans-up application module session state storage for sessions older than a given number of minutes.

You can schedule periodic cleanup of your ADF temporary persistence storage by submitting an invocation of the appropriate procedure in this package as a database job.

You can use an anonymous PL/SQL block like the one shown in Example 40-5 to schedule the execution ofbc4j_cleanup.session_state() to run starting tomorrow at 2:00am and each day thereafter to cleanup sessions whose state is over 1 day (1440 minutes) old.

Extracted from : http://docs.oracle.com/cd/E12839_01/web.1111/b31974/bcstatemgmt.htm#ADFFD1313