Re: Deadlock errors in PeopleSoft CRM 8.14 Help Desk
Date: 25 Nov 2002 15:46:48 -0800
Message-ID: <1b061893.0211251546.51022956_at_posting.google.com>
You could look at the data in V$LOCK, to see which session is creating this deadlock. Deadlock details can also be found in the alert file. After you found which session created the deadlock, spool the SQL generated by PeopleSoft (I know nothing about PeopleSoft, but in Siebel we can do this, and I assume that there must also be a way to do this in PeopleSoft). If you can provide me with more details, I could help (user actions when that occurs, SQL code generating the deadlock, alert file data, ...). You can email me if you want.
Daniel
> We are getting deadlock errors intermittently...of course PeopleSoft
> is scratching their heads...does anyone know anything about this? We
> are running the web and app server on sun solaris and the db on
> AIX/UNIX. db is Oracle. I can reciprocate if you are also having
> issues...information from PS is hard to come by that is meaningful.
Received on Tue Nov 26 2002 - 00:46:48 CET