Re: Orphan sessions

From: John Hurley <hurleyjohnb_at_yahoo.com>
Date: Thu, 23 Jun 2011 10:09:41 -0700 (PDT)
Message-ID: <6fd6d81f-7214-4bdb-b708-f0e977bd7980_at_22g2000yqv.googlegroups.com>



David:

DCD seems to have a number of bugs and problems in recent releases 10.2 and 11.1 ... it won't work correctly in 11.1.0.7.7 unless ( they say ) patch 6918493 is applied.

You may need to do some custom patching of your environment also. Kind of hard to believe that fixes to an old functionality like DCD need one off patches even on top of recent patchset updates ... but there you have it.

# And about the "solution" you warned me about - no, never even thought of trying to hunt those sessions down myself. Especially not like that. :)

Nothing wrong with building in some custom reporting for exceptions ( long idle sessions for example ). You can always report on them for a while without taking any actions to actually kill them off.

Really enabling DCD is not very different from killing sessions from outside of oracle it is mostly a difference of who the hit man is right? Received on Thu Jun 23 2011 - 12:09:41 CDT

Original text of this message