OraFAQ Forum: Server Administration » wt is the diff b/w exclusive Lock And Dead Lock?

Home » RDBMS Server » Server Administration » wt is the diff b/w exclusive Lock And Dead Lock?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

wt is the diff b/w exclusive Lock And Dead Lock? [message #621189]

Mon, 11 August 2014 08:44

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Hi ,

wt is the diff b/w exclusive Lock And Dead Lock? Please explain with one example

Thanks in advanced.

Report message to a moderator

Re: wt is the diff b/w exclusive Lock And Dead Lock? [message #621190 is a reply to message #621189]

Mon, 11 August 2014 08:45

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

unwilling or incapable to use GOOGLE yourself?

http://docs.oracle.com/database/121/index.htm

Report message to a moderator

Re: wt is the diff b/w exclusive Lock And Dead Lock? [message #621191 is a reply to message #621189]

Mon, 11 August 2014 08:53

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Can any one please explain with atleast one exmample on this , i have searched in Google, but not understanding.

Report message to a moderator

Re: wt is the diff b/w exclusive Lock And Dead Lock? [message #621192 is a reply to message #621191]

Mon, 11 August 2014 08:55

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

> i have searched in Google, but not understanding.
if you don't understand what you have read so far, why should we waste time posting same words here to have you not understand here?

Report message to a moderator

Re: wt is the diff b/w exclusive Lock And Dead Lock? [message #621201 is a reply to message #621191]

Mon, 11 August 2014 09:45

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

mist598 wrote on Mon, 11 August 2014 19:23

Can any one please explain with atleast one exmample on this , i have searched in Google, but not understanding.

To start with, have a look here http://lalitkumarb.wordpress.com/2014/02/25/oracle-deadlock-replication/

I have given most basic steps to replicate deadlock, steps include intermediate locks, ultimately resulting in a deadlock. But I strongly insist, read the documentation.

Report message to a moderator

Previous Topic:	How to find the alert log path when database is down.
Next Topic:	index performance

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 23 02:49:39 CDT 2023