This content has been marked as final. Show 2 replies
Apex doesn't maintain a database session. So each time you refresh a page etc, a new session is created.
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