-Original Message-From: Mercadante, Thomas F
[mailto:[EMAIL PROTECTED]]Sent: Friday, June 22, 2001 3:48
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Deadlock Detection
Anita Riyaj,
Thanks for the replies. My email server "went
away" for awhile, so I am just ge
: Deadlock Detection -
Resolved
All,
thanks to Anita, Waleed, Riyaj, Vladimir and Ravinder
for pointing me to Bug #132899 in regard to my Deadlock
problem.
I
upgraded the database from release 8.1.6 to 8.1.7.1 (on NT) and the problem
went away.
thanks again
Tom
:
Deadlock Detection - Resolved
Sorry to butt in guys, but what is Bug #132899 , I can't
find it on Metalink?
Kev
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Mercadante, Thomas
FSent: Wednesday, June 27, 2001 12:09 PMTo: Multiple
by:Subject: Deadlock Detection
[EMAIL PROTECTED
All,
My current application (still under development) is experiencing Oracle
deadlock problems. The applications people are performing stress testing
where the application is being repeatedly called simulating actual users
hitting the database.
The application is written using VB thru ADO and
Tom,
You should have 2 of these traces, one for each process involved. In this
case, the processes are 22, 18 and 24, 27. If you run them through tkprof,
they will be more readable, but the information is there. You need to look up
the table, based on the resource id that was given under
to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Deadlock Detection
All,
My current application (still under development) is experiencing Oracle
deadlock problems. The applications people are performing stress testing
where
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
[EMAIL PROTECTED] 06/22/01 09:35AM
All,My current application (still under development) is
experiencing
Is it
8.1.6.3?? It had lots of deadlock problems.
[EMAIL PROTECTED] 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
The DX resource is a new one on memaybe i just
haven't had coffee yetare you, by chance, in a
distributed database environment? are links involved?
-Original Message-
Sent: Friday, June 22, 2001 9:36 AM
To: Multiple recipients of list ORACLE-L
All,
My current application
Tom,
The information you need should be in the trace file,
but it's not in the excerpt you've listed, but the
true problem is listed:
Rows waited on:
Session 27: no row
No row indicates that the deadlock is due to a lack
of available ITL slots in the datablock.
Unfortunately resolving this
wow. great post.
-Original Message-
Sent: Friday, June 22, 2001 11:50 AM
To: Multiple recipients of list ORACLE-L
Tom,
The information you need should be in the trace file,
but it's not in the excerpt you've listed, but the
true problem is listed:
Rows waited on:
Session 27: no
]
cc:
Subject:Re: Deadlock Detection
Tom,
The information you need should be in the trace file,
but it's not in the excerpt you've listed, but the
true problem is listed:
Rows waited on:
Session 27: no row
No row indicates that the deadlock is due to a lack
of available ITL slots
Anita
Riyaj,
Thanks
for the replies. My email server "went away" for awhile, so I am just
getting your replies now.
Anita,
I am able to modify INITRANS for the tables (I tried this on a test table), and
I will try this. Right now, we are performing other stress tests to narrow
down the
:
Subject:RE: Deadlock Detection
Anita Riyaj,
Thanks for the replies. My email server went away for awhile, so I am just getting your replies now.
Anita, I am able to modify INITRANS for the tables (I tried this on a test table), and I will try this. Right now, we are performing other
Certified Oracle DBA
i2 technologies www.i2.com
A. Bardeen [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
06/22/01 10:50 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Re: Deadlock Detection
Anita,
It must be a lack of sleep thing. :)
Paul
-Original Message-
Sent: Friday, June 22, 2001 7:46 PM
To: Multiple recipients of list ORACLE-L
Riyaj,
Doh! My bad. I completely missed the DX. You are
absolutely correct that what I wrote is applicable
only to TX locks.
Thanks
Did you check bug 1328999 if it applicable in your case.
Regards,
Waleed
-Original Message-
Sent: Friday, June 22, 2001 9:36 AM
To: Multiple recipients of list ORACLE-L
All,
My current application (still under development) is experiencing Oracle
deadlock problems. The applications
18 matches
Mail list logo