Is it
8.1.6.3?>? It had lots of deadlock problems.>>>
NDATFM_at_labor.state.ny.us 6/22/01 9:35:56 AM >>>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:51:42 CDT
