Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

APEX 20.2 : Make session idle time greater than 12 hours

Alexis BNov 8 2021

Hi All,
I am using APEX 20.2
My customer would like to have an illimited maximum idle timeout session on (3 days timeout should be OK) for an application
I tried to set the "Maximum Session Idle Time in Seconds" application parameter to 86400 (24 hours) and then connect to the application.
I checked into apex_workspace_sessions table and session_max_idle_sec column is still 43200 seconds (12hours). I kept the session open over the night to try but session was ended after 12 hours
When I tried to set 21600 second (6hours) it worked fine, apex_workspace_sessions displayed correctly my 21600 setup and session ended after 6 hours
On others topic I read some comments about the ORACLE_APEX_PURGE_SESSIONS scheduler job. I disabled it. Then I retried to keep a session open over the night without success

So questions are :
Why can't I set more than 43200 for the idle time ?
Is there a possibility of doing this ?

Thanks !

Best regards

This post has been answered by Scott Wesley on Nov 22 2021
Jump to Answer
Comments
Post Details
Added on Nov 8 2021
4 comments
1,135 views