For monitoring my own instance, I'm creating a report of all the Apex sessions currently active. I can get that from the apex_workspace_sessions view, which includes the user name and session id. Is there a good way to determine what application a given session is for? I can't find any apex_* view that would provide that information.
All the information is present in apex_workspace_activity_log, but that's one row per page view, so would be very inefficient for what I want.
One option is apex_xxxxxx.wwv_flow_session$, where the on_new_instance_fired_for column seems to contain a list of application ids separated by a "b" (an odd choice for separator). But there's no public synonym for that table, so the region source would have to change with each Apex version.