Re: User locks in db causing stuck threads that aren't timed out

2013-08-19 Thread Armen Avedisijan
Paul, RE: 2. Does anyone have any idea of a way to detect these before it gets real bad, other than looking for steady thread growth? If time that it takes to get "3rd party vendor information for the site a device is associated with" is impacted for "other" sites (not the site on which

Re: User locks in db causing stuck threads that aren't timed out

2013-08-15 Thread Longwing, Lj
gt; > ** ** > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Grooms, Frederick W > *Sent:* Thursday, August 15, 2013 1:46 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: User locks in db causing stuck threads that aren&#

Re: User locks in db causing stuck threads that aren't timed out

2013-08-15 Thread Campbell, Paul (Paul)
rooms, Frederick W Sent: Thursday, August 15, 2013 1:46 PM To: arslist@ARSLIST.ORG Subject: Re: User locks in db causing stuck threads that aren't timed out ** We are running a similar setup (pure custom, multiple servers, 7.6.04 on RHEL with Oracle that is) and I received an email from the DBA on

User locks in db causing stuck threads that aren't timed out

2013-08-15 Thread Campbell, Paul (Paul)
OK, put on your thinking caps for this one, it's a good one I had a situation where our database was experiencing user locks for a specific sql transaction that was causing fast threads to get hung in a waiting state, some for days, so for the background: Our environment: We are running a four