2 Replies Latest reply: Dec 5, 2012 6:54 AM by Patrick Wolf-Oracle RSS

    Apex Sessions on database

      Hi I have a database with 150 users.. but it is creating 200-300 sessions.. of which only 5-20 are used at peak..

      is teh number of sessions create an automatic function of APEX.. or is there a parameter somewhere?

        • 1. Re: Apex Sessions on database
          Apex doesn't maintain a database session. So each time you refresh a page etc, a new session is created.
          • 2. Re: Apex Sessions on database
            Patrick Wolf-Oracle
            Hi Deam,

            are all those session for user APEX_PUBLIC_USER?
            Which web server are you using OHS with mod_plsql, APEX Listener, EPG?
            If you use OHS with mod_plsql, which version are you using?
            If you use OHS you should check http://joelkallman.blogspot.co.uk/2008/01/oracle-http-server-apache-20-and.html and http://docs.oracle.com/cd/E14571_01/portal.1111/e12041/concept.htm (search for session) to understand how the database connection pooling of mod_plsql works.

            My Blog: http://www.inside-oracle-apex.com
            APEX Plug-Ins: http://apex.oracle.com/plugins
            Twitter: http://www.twitter.com/patrickwolf