Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

Make your likes visible on Facebook?

Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.

No, thanks

Oracle – Table Lock Modes

Did you ever read and try to remember that compatibility matrix? When knowing the meaning of each mode, it can be easier. Let’s build it..
by

Franck Pachot

on 1 May 2014

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Oracle – Table Lock Modes

Row-S
Row-X
Share
S/Row-X
eXclusive
Row-S
Row-X
Share
S/Row-X
eXclusive
Share allows concurrent Share
Exclusive prevents concurrent Share
and concurrent exclusive
Lock on Sub-part do not prevent concurrent locks on (other) sub-part
Share vs eXclusive
Sub-part (Row)
Table blocks Subparts
Exclusive prevents Row-X and Row-S
Share prevents Row-X
but allows Row-S
S/Row-X = Share + Row-X
Share prevents eXclusive and Row-X
Row-X prevents Share
S/Row-X are not compatible
and is only compatible with Row-S
build the matrix
Row-S
Row-X
Share
S/Row-X
eXclusive
Row-S
Row-X
Share
S/Row-X
eXclusive
Lock compatibility matrix
Oracle
http://www.soug.ch/fileadmin/user_upload/Newsletter/NL_public/NL_2013_1_Award_Article.pdf
Please read the article to have lock mode definitions before:
This prezi illustrate how to build, understand and remember the lock compatibility matrix.
Franck Pachot
Oracle Database 12c Administrator Certified Professional
Oracle Database 11g Performance Tuning Certified Expert

franck.pachot@dbi-services.com
http://www.dbi-services.com
http://twitter.com/FranckPachot
Full transcript