Skip to Main Content
Feature Request FR-2353
Product Area Installation and Administration
Status CLOSED

12 Voters

Allow longer session timeouts with Autonomous Database

josh.urbain Public · Feb 23 2022

Idea Summary
Currently, while using Autonomous Database hosting for APEX, the Session Time Out setting is locked https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/apex-restrictions.html#GUID-E13D5044-B9DD-4168-8A12-C99532940DA9

This is painful for users, since it's set quite short and causes multiple logins during a workday and possible loss of data.

Use Case
Normal day-to-day development usage

Preferred Solution (Optional)
Allow the value to be changed, or at the very least, be transparent about the maximum value.

This is a great idea! So much that we have already implemented it in a previous release of APEX.

Comments

Comments

  • vladislav.uvarov APEX Team OP 1.6 years ago

    The Session Timeout settings have been available in APEX on Autonomous Database for some time:

    • Instance level: APEX Administration Services → Manage Instance → Instance Settings → Security → Session Timeout or using APEX_INSTANCE_ADMIN.set_parameter API (for example, MAX_SESSION_LENGTH_SEC).
    • Workspace level: Workspace Administration → Manage Service → Set Workspace Preferences → Session Timeout. (The same currently cannot be set from APEX Administration Services as documented here or by using API).
    • Application level: Shared Components → Security → Security Attributes → Session Management.

    The behavior of these settings and the default values are the same as in on-premises APEX environments. The default values are listed in the Configuring Session Timeout for an Instance chapter in APEX documentation.

  • tcaruth OP 1.6 years ago

    The documentation states (link):

    The following Oracle APEX Administration Services configuration options are disabled, or have been predefined by Oracle and cannot be altered

    …

    Manage Workspaces, Existing Workspaces, Edit Workspace Information:

    • Login Control
    • Session Timeout
    • Workspace Isolation

    If that's truly no longer the case then the documentation should be updated, and the idea marked as delivered.

  • jayson hanes Admin OP 1.6 years ago

    I cannot help with the docs, but I can close this feature - it just doesn't make sense to close it in association with an APEX release, but can close as “Already Implemented” - but if it truly wasn't at the time of this submission, please accept this closure for what it is :)

  • tcaruth OP 1.6 years ago

    How can I get in touch with someone who can update the documentation? Can you put a request in to them for us?

  • vladislav.uvarov APEX Team OP 1.6 years ago

    We can update the documentation in general. However, the documentation you referenced is accurate as of APEX 23.2 on Dec 15, 2023. Basically, on ADB, Instance Administrator currently cannot define Session Timeout at specifically the workspace level, but Workspace Administrator can. This is clearly a gap that we plan to close (bug 36111893), but as far as the general ability to set Session Timeout parameters at different levels - this is possible today using the options we listed above.

  • jflores OP 6 months ago

    http timeout should be included, 5 min is too low specially when even asynchronous transactions using APEX_UTIL are limited.