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?
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