Blog - All About APEX Timeouts

APEX_Timeout_Settings.sql

-- You must have the APEX_ADMINISTRATOR_ROLE database role to run this query.
SELECT aw.workspace
,      aa.application_id "App ID"
,      aa.application_name
,      CASE
         WHEN aa.maximum_session_life_seconds IS NOT NULL THEN 'Application'
         WHEN aa.maximum_session_life_seconds IS NULL 
          AND aw.maximum_session_life_seconds IS NOT NULL THEN 'Workspace'
         ELSE 'Instance'
       END "Max Session Life Level"
,      COALESCE(aa.maximum_session_life_seconds, aw.maximum_session_life_seconds, 
                TO_NUMBER(apex_instance_admin.get_parameter ('MAX_SESSION_LENGTH_SEC')), 28800) "Max Session Life Secs"
,      CASE
         WHEN aa.maximum_session_idle_seconds IS NOT NULL THEN 'Application'
         WHEN aa.maximum_session_idle_seconds IS NULL 
          AND aw.maximum_session_idle_seconds IS NOT NULL THEN 'Workspace'
         ELSE 'Instance'
       END "Max Session Idle Level"
,      COALESCE(aa.maximum_session_idle_seconds, aw.maximum_session_idle_seconds,
                TO_NUMBER(apex_instance_admin.get_parameter ('MAX_SESSION_IDLE_SEC'))) "Max Session Idle Secs"
,      CASE
         WHEN aa.session_timeout_warn_seconds IS NOT NULL THEN 'Application'
         WHEN aa.session_timeout_warn_seconds IS NULL 
          AND aw.session_timeout_warn_seconds IS NOT NULL THEN 'Workspace'
         ELSE 'Instance'
       END "Session Timeout Warn Level"
,      COALESCE(aa.session_timeout_warn_seconds, aw.session_timeout_warn_seconds, 
                TO_NUMBER(apex_instance_admin.get_parameter ('SESSION_TIMEOUT_WARNING_SEC')))  "Session Timeout Warn Secs"
FROM   apex_applications aa
,      apex_workspaces   aw
WHERE  aa.workspace    = aw.workspace;