APEX System Views

-- Definitions
select * from APEX_DICTIONARY;
select * from APEX_WORKSPACES;
select * from APEX_APPLICATIONS ORDER BY WORKSPACE, APPLICATION_ID;
select * from APEX_WORKSPACE_APEX_USERS;
select * from APEX_WORKSPACE_SCHEMAS;

-- Development
select * from APEX_DEBUG_MESSAGES;
select * from APEX_DEVELOPER_ACTIVITY_LOG;
select WORKSPACE_NAME, USER_NAME, IS_ADMIN, IS_APPLICATION_DEVELOPER, ACCOUNT_LOCKED  from APEX_WORKSPACE_DEVELOPERS ORDER BY 1,2;

-- Environment
select * from APEX_RELEASE;
select * from APEX_PATCHES;
select * from APEX_INSTANCE_PARAMETERS;
select * from APEX_WORKSPACE_SESSIONS;

-- Logging
select * from APEX_USAGE_METRICS;
select * from APEX_WORKSPACE_ACCESS_LOG;
select * from APEX_WORKSPACE_ACTIVITY_LOG;