Posted on: 1/12/2014 12:34:37 PM | Views : 656

Hello!
how are you?i need help?i am using oracle for database and Visual Studio for the front end.i am connecting to oaracle and using a strategy of open a connection inside a function and closing before the end of that function. every function has its own opening and closing.it creates load on database server. i want to decrease the load the reason is that oracle retains connection in the pool after closing and doesnot terminate or kill connection. so i want that connection is terminated and connected without remaining in the pool and capturing resources.

hope for positive results

regards

Go to the complete details ...