There are many kinds of deadlocks in the Oracle world.
The following MetaLink notes will be of interest.
166924.1
62365.1
There are no doubt others, but these are two I had bookmarked.
Jared
On Sat, 2003-09-06 at 00:54, Mladen Gogala wrote:
Harvey Deitel: Operating Systems.
Andrew
Harvey Deitel: Operating Systems.
Andrew Tannenbaum: Modern Operating Systems
Avi Silbershatz: Operating System Concepts
On 2003.09.06 00:14, Veeraraju_Mareddi wrote:
What is a dead lock ? Does oracle manages with a dead lock or DBA has to
involve ? What are other locks , latches A DBA has to
Raj
Imagine two user programs, Joe and Fred. Both need access to table
PAYROLL and EMPLOYEES. First, Joe locks table PAYROLL and processes on it
awhile. Next, Fred locks table EMPLOYEE and processes on it awhile. Then Joe
attempts to lock table EMPLOYEE. Instead of succeeding, this program
Thanks a lot.
--
From: DENNIS WILLIAMS[SMTP:[EMAIL PROTECTED]
Reply To: [EMAIL PROTECTED]
Sent: Saturday, September 06, 2003 7:19 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Dead locks how ?
Raj
Imagine two user programs, Joe and Fred
On 2003.09.06 09:49, DENNIS WILLIAMS wrote:
Raj
Imagine two user programs, Joe and Fred. Both need access to table
PAYROLL and EMPLOYEES. First, Joe locks table PAYROLL and processes on it
Dennis, I'm not sure that your explanation, while perfectly accurate and
correct, is a good service to
Mladen
Well, at least you didn't say that I got it wrong. ;-) I think your
answer was the right one, learn some computer science, but I was concerned
that it might seem a little too intimidating. A really bright person can
pick up a lot from a C.S. textbook, but some people might be frustrated.
What is a dead lock ? Does oracle manages with a dead lock or DBA has to
involve ? What are other locks , latches A DBA has to take care of. Any
examples, docs, notes will be helpful.
Thanks
Rajuveera
**
This email
- Yes, the stmts are rolled back.
- You can look for them where the parameter
user_dump_dest indicates. However you can receive two
kinds of deadlocks. The ORA-60 ones or ORA-4020 ones.
The first ones deals with enqueues and the second ones
implies an library cache lock.
Regards.
---
Hi lists,
If a dead lock occurs , will the statements be rolledback by oracle ?
will oracle do anything other than dumping trace?
I tried. But both session never comeout. Just they hung.
Regards,
Srinivas
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tatireddy,
HI,
yes, you will find a line in the alertSID.ora that specifies the trace
file
in which you can find information about the deadlock.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, November 02, 2001 1:00 PM
Hi lists,
If a dead lock
10 matches
Mail list logo