Re: Dead locks how ?

2003-09-07 Thread Jared Still
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

Re: Dead locks how ?

2003-09-06 Thread Mladen Gogala
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

RE: Dead locks how ?

2003-09-06 Thread DENNIS WILLIAMS
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

RE: Dead locks how ?

2003-09-06 Thread Veeraraju_Mareddi
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

Re: Dead locks how ?

2003-09-06 Thread Mladen Gogala
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

RE: Dead locks how ?

2003-09-06 Thread DENNIS WILLIAMS
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.

Dead locks how ?

2003-09-05 Thread Veeraraju_Mareddi
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

Re: Dead locks

2001-11-03 Thread Christian Trassens
- 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. ---

Dead locks

2001-11-02 Thread Tatireddy, Shrinivas (MED, Keane)
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,

Re: Dead locks

2001-11-02 Thread claudio cutelli
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