It seems APEX_PUBLIC_USER sessions are not closed on 12c database when APEX listener is stopped or restarted.
I'm trying to configure new multitenant features (APEX Listener 2.0.5) on 12c database (Linux & VirtualBox). Listener was restarted many times during the process and I ended with 50+ db sessions. Those sessions are left as INACTIVE and are associated with the relevant container (V$SESSION.CON_ID).
I can replicate it in standalone mode and with Tomcat.
On 11gR2 database APEX_PUBLIC_USER sessions are closed once listener is stopped.
Is it an expected behaviour on 12c, but or I'm doing something wrong ?
Jan
