I have to improve the performance of an existing application where Hibernate is used for DB tx. I have also received few statistics of DB where it indicates that there is proper indexing in column of table. However, I have noticed that there was 883 sessions used for around 100 users. Could someone suggest what could be the reason is it because of connection pooling is not proper or connections were not properly closed???