close old oracle db connections
Posted on 2008-01-29
ok so the issue is with some old classic code where the db connections are not properly disposed of, we are going through and making that correction. However, is there a way from vb.net to gather the information from the oracle database, that some connections are over 6 hours old, which clearly indicates that it is abandoned, and then kill that connection without an IIS restart. I want to create a utility page where it knows the current connections and their age and I can tell it to terninate the old ones.
I am making this high points to see if it will catch someone eye, also I think this will be kind of advanced to guru level.
I tried to make this worth 1500 and could not, I will add what I can when close and grade.