hi, friends: >>>select count(*) into :b0 from USERCONFIRMINFO where USER_ID=:b1 >>>The following deadlock is not an ORACLE error. It is a >>>deadlock due to user error in the design of an application >>>or from issuing incorrect ad-hoc SQL. The following >>>information may aid in determining the deadlock: >>> >>>Deadlock graph: >>>---------Blocker(s)-------- ---------Waiter(s)--------- >>>Resource Name process session holds waits process session holds waits >>>TX-000e005d-00037cfa 306 484 X 306 484 S >>>session 484: DID 0001-0165-00010802 session 484: DID 0001-0165-00010802 >>>Rows waited on: >>>Session 484: no row Another trace file like: >>>*** 2003-03-02 16:50:22.447 >>>DEADLOCK DETECTED >>>Current SQL statement for this session: >>>select USER_ID ,USER_EMAIL into :b0,:b1 from USERPRIVATEINFO where USER_ACCOUNT=:b2 >>>The following deadlock is not an ORACLE error. It is a >>>deadlock due to user error in the design of an application >>>or from issuing incorrect ad-hoc SQL. The following >>>information may aid in determining the deadlock: >>>Deadlock graph: >>> ---------Blocker(s)-------- ---------Waiter(s)--------- >>>Resource Name process session holds waits process session holds waits >>>TX-0012004a-000374f8 293 263 X 306 512 S >>>session 263: DID 0001-0165-0004EC65 session 512: DID 0001-0165-0004EC65 >>>Rows waited on: >>>Session 512: no row
I ever saw message talking about two session deadlock with no rows waited on, maybe it is because of pctfree/initrans, How about session wait on itself then? And how can it happen? Regards zhu chao msn:[EMAIL PROTECTED] www.happyit.net www.cnoug.org(China Oracle User Group) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).