session variable house keeping

Question

Hi Team What is the recommended way of removing old session variables. Yes a "logout" is the logical place, but the reality hardly any user will use that and just close their browser tab/window. Do I write a job to daily or weekly go through the t_bdf_websession and delete applicable records from t_bdf_session,t_bdf_sessionitem and t_bdf_websessionlog?

Accepted Answer

Hi Raymond,

Formspider already handles this maintenance. When it's installed, Formspider automatically creates 2 daily jobs, you can find these jobs with the following query:

select * from dba_jobs where schema_user='yourFormspiderUser'

The job which calls the BDF_DELETE_OLDSESSIONS; procedure deletes all sessions data (session variables and other session specific data held in db tables) which are not accessed since 24 hours or which are timed out (if a Session Timeout value is defined for the application).

The job which calls the BDF_DELETE_DIRTYOBJECTS; procedure has an internal maintenance role, it deletes all db objects created once by Formspider (DS_ packages, DSI_ tables..etc) but not needed anymore.

Hope this helps,
Ibrahim

session variable house keeping

Follow this question

Related questions