Oracle Application Express (MOSC)

MOSC Banner

APEX how to link the wwv_flow_fnd_user to the v$session

To get the workspaces I would query the dba_user views.

select username, user_id from dba_users where username like 'APEX%' order by username;
USERNAME                     USER_ID
------------------------- ----------
APEX_030200                      190
APEX_LISTENER                    262
APEX_PUBLIC_USER                 170
APEXSYSUSER                      280
APEX_REST_PUBLIC_USER            263
APEX_040100                      216
APEX_LISTENER_USER               217
APEX_050000                      223                   
APEX_210100                      279                  <--

Then with that result I would use it to the APEX table wwv_flow_fnd_user

select user_id, user_name from APEX_210100.wwv_flow_fnd_user; 

   USER_ID USER_NAME
---------- ----------------------------------------
0015941536 APEXME
9454048894 USER1
8043592063 USER2

Question is how do I link this apex user_id to the v$session so we know who is currently active and what queries or process the apex users are running. Thanks.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center