Oracle APEX Registered Users

Since APEX (like any web system) is stateless, there is no clear list of people who are logged in. Someone may have accessed the page 1 second ago, then closed their browser and closed the PC. Are they still "signed in"? APEX doesn't know they don't exist yet.

So, I would probably go for something like this:

select count(*)
from APEX_WORKSPACE_LOG_SUMMARY_USR
where workspace = 'MY_WORKSPACE'
and apex_user != 'nobody'
and last_view > sysdate-15/24/60;

      

        
        
        
      

    

i.e. authenticated people who have viewed a page in my workspace in the last 15 minutes.