skroba (11/18/2014)
Sounds very reasonable and understandable but one question is left...How to release orphaned Application, Exclusive, Session lock without dba interaction and without killing session itself? How release the lock from other session?
Any ideas, if it really possible...?
Thanks,
You can't, not easily. It's like a lost transaction. You need DBA interference or you need to build callable scripts to force releases.
In a way, you don't want it to. Usually for something like this you need the DBA to reset other pieces too, and you need to figure out at what point the app hung. A catch-all fix for processes that would usually use this isn't in the cards, unless they're incredibly simplistic... in which case I'd be looking for alternate methods.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA