i think i've been there and done that(Kevin T u know what i'm
talking about),
Question, do you have bitmap indexes on the tables being
updated? if so, then thats your culprit.
joe
>>> NDATFM_at_labor.state.ny.us 06/22/01 09:35AM
>>>All,My current application (still under development) is
experiencing Oracledeadlock problems. The applications people are
performing stress testingwhere the application is being repeatedly called
simulating actual usershitting the database.The application is
written using VB thru ADO and COM, Oracle 816 on NT.My problem is that,
while I can review the trace file produced, I can'tfigure out what the
actual deadlock is occurring on. I have seen deadlocktrace files that
clearly state "table blah", but in this case, I get:*** 2001-06-21
14:32:03.841*** SESSION ID:(27.31211) 2001-06-21 14:32:03.810DEADLOCK
DETECTEDDeadlock
graph:
---------Blocker(s)-----------------Waiter(s)---------Resource
Name process session holds
waits process session
holdswaitsDX-0000003b-00000000
22 18
X
24 27Xsession 18: DID
0001-0018-0000003C session 27: DID 0001-0018-0000003CRows
waited on:Session 27: no row*** 2001-06-21 14:32:03.857ksedmp:
internal or fatal errorORA-00060: deadlock detected while waiting for
resourceIs there something like TKPROF that will process the trace file
and give memore info on what is happening? It looks like I am waiting
for a resourceto be freed, but which one is the question.thanks for
any help.Tom MercadanteOracle Certified Professional--
Please see the official ORACLE-L FAQ: <A
href="
http://www.orafaq.com">
http://www.orafaq.com-- Author:
Mercadante, Thomas F INET: NDATFM_at_labor.state.ny.usFat City
Network Services -- (858) 538-5051 FAX: (858)
538-5051San Diego, California --
Public Internet access / Mailing
Lists--------------------------------------------------------------------To
REMOVE yourself from this mailing list, send an E-Mail messageto:
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list
you want to be removed from). You mayalso send the HELP command for
other information (like subscribing).
Received on Fri Jun 22 2001 - 09:35:31 CDT
