Seema,
Changing INITRANS may help IF you see waits for data block headers.
INITRANS/MAXTRANS deal with the number of transactions that can lock a block
at a given time.
Deadlocks are caused when TransactionA has locked RowA and TxB has
locked RowB. Then TxA needs to lock RowB (but can't because TxB has locked
it) and TxB needs to lock RowA (but can't because TxA has locked it). The
locks won't be released until the transaction completes, but they cannot
complete successfully since they cannot acquire the needed lock. So you have
a round robin affair. The transaction discovering the deadlock will be
rolled back.
Check the application code. Therein lies the problem.
Dan Fink
-----Original Message-----
Sent: Thursday, December 19, 2002 12:55 PM
To: Multiple recipients of list ORACLE-L
Hi
I have been noticing some times following error with one table during
update.
DEADLOCK DETECTED
Current SQL statement for this session:
"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:"
Is chaning of INITTRANS would help ?
Thx
-Seema
_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Seema Singh
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Fink, Dan
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).
