Link to home
Start Free TrialLog in
Avatar of augblay
augblay

asked on

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
Avatar of iozturk
iozturk
Flag of Türkiye image

Are you closing connections? I dont know much about asp.Net but in asp you should close connections.
ASKER CERTIFIED SOLUTION
Avatar of RichW
RichW
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Helena Marková
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
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