We are using Fluent nHibernate in the Data Access layer of our WCF Rest Web Service to read data from Oracle Database through ODP.Net data provider. During peak loads, We could observe that number of database session keep increasing and we could see that the status of these sessions are Inactive form the Database end. It take a minimum of 30 mins - 1 hour for oracle to close these inactive sessions in spite of a session.close from the nHibernate end. Can you please let us know why the Oracle sessions are not closed even after a nhibernate session.close? any suggestions on how to overcome this scenarios?
Please see the code snippets attached. -- You received this message because you are subscribed to the Google Groups "nhusers" group. To view this discussion on the web visit https://groups.google.com/d/msg/nhusers/-/H9BmDDDcAGoJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
nHibernate_Oracle_Session_Closing_Issue.docx
Description: application/vnd.openxmlformats-officedocument.wordprocessingml.document
