0 Replies Latest reply: Oct 28, 2013 10:31 AM by Jan N RSS

    APEX Listener not closing sessions on 12c

    Jan N

      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