OraFAQ Forum: Server Administration » About an Oracle's Isolation Levels and lock mode

Home » RDBMS Server » Server Administration » About an Oracle's Isolation Levels and lock mode (Oracle 11g, oracle linux 6.4)

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

About an Oracle's Isolation Levels and lock mode [message #631497]

Wed, 14 January 2015 04:25

trybestpro
Messages: 17
Registered: September 2014
Location: HCM

Junior Member

Hi All,
I read document and know Oracle's Isolation Levels have the following categories: Read Uncommitted, Read Committed, Repeatable Read, Serializable.
Oracle's lock mode have the following categories (not all) : ROW SHARE (RS), ROW EXCLUSIVE (RX), SHARE (S), SHARE ROW EXCLUSIVE (SRX),
EXCLUSIVE (X).
But I don't understand what difference of Oracle's Isolation Levels and Oracle's lock mode ?

Thanks all.
Best regards.

Report message to a moderator

[Message index]

		About an Oracle's Isolation Levels and lock mode By: trybestpro on Wed, 14 January 2015 04:25
		Re: About an Oracle's Isolation Levels and lock mode By: Michel Cadot on Wed, 14 January 2015 04:55
		Re: About an Oracle's Isolation Levels and lock mode By: cookiemonster on Wed, 14 January 2015 05:14
		Re: About an Oracle's Isolation Levels and lock mode By: trybestpro on Wed, 14 January 2015 07:55
		Re: About an Oracle's Isolation Levels and lock mode By: BlackSwan on Wed, 14 January 2015 08:05
		Re: About an Oracle's Isolation Levels and lock mode By: trybestpro on Wed, 14 January 2015 08:08
		Re: About an Oracle's Isolation Levels and lock mode By: BlackSwan on Wed, 14 January 2015 08:11
		Re: About an Oracle's Isolation Levels and lock mode By: trybestpro on Wed, 14 January 2015 08:41
		Re: About an Oracle's Isolation Levels and lock mode By: Michel Cadot on Wed, 14 January 2015 08:29
		Re: About an Oracle's Isolation Levels and lock mode By: BlackSwan on Wed, 14 January 2015 08:32
		Re: About an Oracle's Isolation Levels and lock mode By: trybestpro on Wed, 14 January 2015 08:36
		Re: About an Oracle's Isolation Levels and lock mode By: John Watson on Wed, 14 January 2015 05:29

Previous Topic:	Upgrade Oracle10g to Oracle11g
Next Topic:	opatch directory oracle 9i is missing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 16:11:59 CDT 2024