oracle connection not closing

i am accessing oracle database within cold fusion and asp.net. but i am noticeing that oracle is not releasing the connections. when i look at toad i see multiple inactive sessions. can someone point me to the right direction
LVL 1
augblayAsked:
Who is Participating?
 
RichWConnect With a Mentor Commented:
I am having the same exact problem, and I have posted a question like this one in the .Net section.

A workaround is to change the <processModel tag's timeout settings in the machine.config file from Indefinite to something like 5 minutes.

Whatever time you set the session objects in Oracle will go away, BUT, by using this method you are essentially destroying the worker process, so if your users are not active in the session for that amount of time you lose the session information.

I have contacted Oracle about this and I swear they don't have one .Net developer around.  I think they paid an OEM fee to Microsoft to develop the Oracle data access object.

0
 
iozturkCommented:
Are you closing connections? I dont know much about asp.Net but in asp you should close connections.
0
 
Helena Markováprogrammer-analystCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

Accept RichW's comment as answer.

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Henka
EE Cleanup Volunteer
0
 
RichWCommented:
I forgot about this question.  The answer I discovered is to remember to dispose of the reader and/or datadaptor objects along with the connection objects.

Once you dispose of the connection and other data objects the inactive session objects in the Oracle server go away.

RichW
0
All Courses

From novice to tech pro — start learning today.