Hello,
          my current setup is DotNetNuke 4.8.4 with its associated Oracle Data Provider and Oracle 10g as the database.
Now that the site is increasing in number of visitors i start to have a lot of problems with the database (TNS listener instability , connection timeout errors etc).Inspecting the DB i see a lot of open sessions (with open cursors) that stay inactive for even 15-20 minutes).So eventually open sessions stack up and new connections from visitors cannot open and errors occur.
Is this a problem/misconfiguration of Data Provider ? Oracle ? Both? or something else?
Any suggestions would be helpful.

In the Enterprise Manager in the sessions i see both entries like GetModuleSettings or GetSearchItems, AddSearchItem as well entries from some custom modules I have made.
Concerning coding style in my OracleDataProvider classes most of my getMethods are something like
 

return CBO.FillCollection(OracleSqlHelper.ExecuteReader(ConnectionString,DatabaseOwner & ObjectQualifier & procName,arguments,"returnValue", GetType (businessClass))

Where should i intervene to close the reader?
Should instead of return immediately do something like
OracleSqlHelper.GetConnection(ConnectionString).Close()
or something else?

Thank you again for your help.