Oracle Apex - Session (or application context)

Card Puncher Data Processing

About

A Session is created after :

Id

Each session is assigned a unique identifier. The Application Express engine uses this identifier (or session ID) to store and retrieve an application's working set of data (or session state) before and after each page view.

Management

Get

The session ID can be seen:

Variable

APP_SESSION

You can reference the session ID variable using the syntax:

  • Short substitution string: &APP_SESSION.
  • PL/SQL: V('APP_SESSION')
  • Bind variable: :APP_SESSION

Example with the Apex url

f?p=6000:6003:&APP_SESSION.::NO:6003:MY_ITEM:1234 

APP_SESSION_VISIBLE

APP_SESSION_VISIBLE enhance APP_SESSION by implementing also the zero session feature

View

Viewing Active Sessions

Time out

Application Properties > Security > Session Timeout

Api

APEX_UTIL

See the APEX_UTIL package:

  • GET_SESSION_LANG Function
  • GET_SESSION_TERRITORY Function
  • GET_SESSION_TIME_ZONE Function

APEX_CUSTOM_AUTH

You can use the APEX_CUSTOM_AUTH package to perform various operations related to session management.

Purge

The ORACLE_APEX_PURGE_SESSIONS job (DBMS_SCHEDULER) purges sessions older than 12 hours (the default). This job runs every hour.

Zero

The zero session ID function is in use in a public navigation context. See Zero Session Feature





Discover More
Card Puncher Data Processing
Oracle Apex - (Authentication|Identity)

This page makes part of the security theme and talks authentication implementation in Apex. Once a user has been identified, the Application Express engine keeps track of each user by setting: ...
Oracle Apex Items Type
Oracle Apex - (Form|Page) (Field|Item)

An item (also called a field) is a HTML form elements such as text fields, select lists, and check boxes. Every item has a session state value that can be referenced by a variable. Item names...
Card Puncher Data Processing
Oracle Apex - Custom Authentication

Authentication Function Name: my_authentication PL/SQL Code: REQUESTApex URLPage processing section REQUESTApex URL“”page rendering session id To have proper redirection, the login function...
Card Puncher Data Processing
Oracle Apex - Database (Schema|Session)

Each page requested during an Apex session results in the Application Express engine creating or reusing an Oracle database session to access database resources. Often these database sessions last just...
Card Puncher Data Processing
Oracle Apex - Public Navigation (Page and user)

The public navigation mechanism in Apex. A public navigation means that: the user is a public user (not authenticated), the target page is a public page in the current application This prerequisites...
Oracle Apex Session State Scope
Oracle Apex - Session state

Session state is a workspace that contains all variables with their values for one user. Session state can be maintained: Per session (to maintain session state per session). The session ID locate...
Card Puncher Data Processing
Oracle Apex - URL

The format of the APEX URL and URL management. Where: pocserver01:7777...
Oracle Apex Application Security Public User
Oracle Apex - User

A user in Apex. Once a user has been identified, the Application Express engine keeps track of each user by setting the value of the variable APP_USER. APP_USER...



Share this page:
Follow us:
Task Runner