OAM 11g R2 PS2 how to manually purge session table if it is not truncated automatically

PS2 have a bug where it will not truncate users session table automatically once user is logged off  and once any users tries to access the application, system will go thru whole table in order to find any active session. that can consume a lot of resources. here is how to truncate this table manually for once and than it needs to be monitor to see if this table is updated automatically or  not.


Shutdown all OAM servers
Back up the table OAM tables EIDM_OAM. OAM_SESSION_ATTRIBUTES, EIDM_OAM. OAM_SESSION  using data pump.

alter table EIDM_OAM.OAM_SESSION_SP_LIST disable constraint OAM_SESSION_SP_LIST_FK1;

alter table EIDM_OAM.OAM_SESSION_ATTRIBUTES disable  constraint OAM_SESSION_ATTRIBUTES_FK1;

TRUNCATE TABLE EIDM_OAM.OAM_SESSION_ATTRIBUTES;
TRUNCATE TABLE EIDM_OAM.OAM_SESSION;

alter table EIDM_OAM.OAM_SESSION_SP_LIST enable constraint OAM_SESSION_SP_LIST_FK1;

alter table EIDM_OAM.OAM_SESSION_ATTRIBUTES enable  constraint OAM_SESSION_ATTRIBUTES_FK1;

Start OAM servers