SYSADMIN login taking long time to log in
Introduction
Solution for sysadmin taking long time to login
Posted by Arun
Sometimes, SYSADMIN login in particular instance will take long time to log in as it will have open workflow notifications waiting to be closed.
We cannot close those open workflow notifications using front end if the open notification are huge.
UPDATE wf_notifications set status=’CLOSED’ , mail_status=’SENT’, end_date=sysdate where recipeint_role=’SYSADMIN’;
commit;
This will allow you to close the open notifications, and will resolve the slow login using SYSADMIN user.