My experience on ORACLE Data locks, my experience on oracle

My experience on ORACLE Data locks, my experience on oracle
Part of the post content is for the attachments in The Post (a warrior's understanding about the lock), Understanding/question,
Before reading this post, read this article.
First, let's talk about the various types of locks: Shared locks, arrange it, and share the exclusive locks (define the sharing of the table, and record the table operation ).
1. What I like about locks in this article is to define tables (including table structures and constraints) Before performing operations on table records)
A shared lock is added to avoid DDL operations on the table.
For example, when you insert a record to TAB1, a field COL8 in the table is allowed to be blank and this field of this record is inserted.
The value of is empty. If a share lock is not applied to the table definition, another SESSION adds a non-empty constraint to TAB1.COL8,
The table structure modification conflicts with the inserted records. Therefore, when you execute the DML operation, you must add DDL to the operated table.
Shared lock. This is the intention lock I understand. 2. As mentioned in the article, record rows do not have a shared lock. In my opinion, this is different: When a sub-table is inserted/modified, the primary key of the corresponding parent table
A shared lock should be applied to the record, because the existence of the parent key must be ensured. It is tested that when a sub-table is inserted, modified, or deleted, the parent table
If an SS lock is applied, the primary key of the parent table can be inserted but cannot be modified or deleted. This is logical. Because
The insert operation does not affect the relationship between the primary and Foreign keys. However, deletion/modification is possible.
3. What is the difference between SHARE and row share?
I guess: ROW SHARE is (Level = 2) a shared lock is applied to the table definition. SHARE (Level = 4) is used to define the table and "all" of the table.
Add a shared lock to the record. But there is a problem in this way: 1. select for update generates TM = 2. the query records are generated with TX = 6.
The lock should conflict with the share lock applied to the "all" Records of the table? But not actually. In fact, when you add SHARE to a table
During the lock, you can still execute select for update for the table, but cannot execute DML operations!
Http://c.tieba.baidu.com/p/3400159140
Http://c.tieba.baidu.com/p/3400168642
Http://c.tieba.baidu.com/p/3400175529
Http://c.tieba.baidu.com/p/3400211249
Http://c.tieba.baidu.com/p/3400215954
Http://c.tieba.baidu.com/p/3400221959
Http://c.tieba.baidu.com/p/3400211249
Http://c.tieba.baidu.com/p/3400225722
Http://c.tieba.baidu.com/p/3400234615
Http://c.tieba.baidu.com/p/3400251666
Http://c.tieba.baidu.com/p/3400285180
Http://c.tieba.baidu.com/p/3400308243
Http://c.tieba.baidu.com/p/3400319333
Http://c.tieba.baidu.com/p/3400334202
Http://c.tieba.baidu.com/p/3400395154
Http://c.tieba.baidu.com/p/3400421901
Http://c.tieba.baidu.com/p/3400395154
Http://c.tieba.baidu.com/p/3400469233
Http://c.tieba.baidu.com/p/3400728367
Http://c.tieba.baidu.com/p/3400901029
Http://c.tieba.baidu.com/p/3401014743
Http://c.tieba.baidu.com/p/3401031288
Http://c.tieba.baidu.com/p/3401047300
Http://c.tieba.baidu.com/p/3401051984
Http://c.tieba.baidu.com/p/3401059077
Http://c.tieba.baidu.com/p/3401062426
Http://c.tieba.baidu.com/p/3401071821
Http://c.tieba.baidu.com/p/3401076277
Http://c.tieba.baidu.com/p/3401080588
Http://c.tieba.baidu.com/p/3401086641
Http://c.tieba.baidu.com/p/3401089865
Http://c.tieba.baidu.com/p/3401106948
Http://c.tieba.baidu.com/p/3401113470
Http://c.tieba.baidu.com/p/3401116534
Http://c.tieba.baidu.com/p/3401120253
Http://c.tieba.baidu.com/p/3401125709
Http://c.tieba.baidu.com/p/3401205780
Http://c.tieba.baidu.com/p/3401206229
Http://c.tieba.baidu.com/p/3401207985
Http://c.tieba.baidu.com/p/3401129461
Http://c.tieba.baidu.com/p/3401134021
Http://c.tieba.baidu.com/p/3401049605
Http://c.tieba.baidu.com/p/3401140102
Http://c.tieba.baidu.com/p/3401142196
Http://c.tieba.baidu.com/p/3401145015
Http://c.tieba.baidu.com/p/3401149211
Http://c.tieba.baidu.com/p/3401153873
Http://c.tieba.baidu.com/p/3401149211
Http://c.tieba.baidu.com/p/3401162739
Http://c.tieba.baidu.com/p/3401164713
Http://c.tieba.baidu.com/p/3401193190
Http://c.tieba.baidu.com/p/3401194016
Http://c.tieba.baidu.com/p/3401194496
Http://c.tieba.baidu.com/p/3401195213
Http://c.tieba.baidu.com/p/3401195739
Http://c.tieba.baidu.com/p/3401196585
Http://c.tieba.baidu.com/p/3401197174
Http://c.tieba.baidu.com/p/3401197694
Http://c.tieba.baidu.com/p/3401216009
Http://c.tieba.baidu.com/p/3401197694
Http://c.tieba.baidu.com/p/3401198248
Http://c.tieba.baidu.com/p/3401200400
Http://c.tieba.baidu.com/p/3401217947
Http://c.tieba.baidu.com/p/3401200804
Http://c.tieba.baidu.com/p/3401201487
Http://c.tieba.baidu.com/p/3401215076
Http://c.tieba.baidu.com/p/3401205523
Http://c.tieba.baidu.com/p/3401205968
Http://c.tieba.baidu.com/p/3401206396
Http://c.tieba.baidu.com/p/3401207761
Http://c.tieba.baidu.com/p/3401208567
Http://c.tieba.baidu.com/p/3387723288
Http://c.tieba.baidu.com/p/3401208893
Http://c.tieba.baidu.com/p/3401209841
Http://c.tieba.baidu.com/p/3401210266
Http://c.tieba.baidu.com/p/3401210667
Http://c.tieba.baidu.com/p/3401211192
Http://c.tieba.baidu.com/p/3401211676
Http://c.tieba.baidu.com/p/3401212307
Http://c.tieba.baidu.com/p/3401212872
Http://c.tieba.baidu.com/p/3401213277
Http://c.tieba.baidu.com/p/3401213610
Http://c.tieba.baidu.com/p/3401214872
Http://c.tieba.baidu.com/p/3401216078
Http://c.tieba.baidu.com/p/3401216438
Http://c.tieba.baidu.com/p/3401218074
Http://c.tieba.baidu.com/p/3401218797
Http://c.tieba.baidu.com/p/3401219800
Http://c.tieba.baidu.com/p/3401220191
Http://c.tieba.baidu.com/p/3401220973
Http://c.tieba.baidu.com/p/3401222058
Http://c.tieba.baidu.com/p/3401221420
Http://c.tieba.baidu.com/p/3401222937
Http://c.tieba.baidu.com/p/3401224454
Http://c.tieba.baidu.com/p/3401225208
Http://c.tieba.baidu.com/p/3401225902
Http://c.tieba.baidu.com/p/3401226507
Http://c.tieba.baidu.com/p/3401227239
Http://c.tieba.baidu.com/p/3401229594
Http://c.tieba.baidu.com/p/3401230714
Http://c.tieba.baidu.com/p/3401231802
Http://c.tieba.baidu.com/p/3401232831
Http://c.tieba.baidu.com/p/3401233898
Http://c.tieba.baidu.com/p/3401234845
Http://c.tieba.baidu.com/p/3401235912
Http://c.tieba.baidu.com/p/3401237191
Http://c.tieba.baidu.com/p/3401238709
Http://c.tieba.baidu.com/p/3401239625
Http://c.tieba.baidu.com/p/3401240718
Http://c.tieba.baidu.com/p/3401242498
Http://c.tieba.baidu.com/p/3401243539
Http://c.tieba.baidu.com/p/3401245054
Http://c.tieba.baidu.com/p/3401246362
Http://c.tieba.baidu.com/p/3401249158
Http://c.tieba.baidu.com/p/3401250931
Http://c.tieba.baidu.com/p/3401252403
Http://c.tieba.baidu.com/p/3401253962
Http://c.tieba.baidu.com/p/3401255468
Http://c.tieba.baidu.com/p/3401257602
Http://c.tieba.baidu.com/p/3401258908
Http://c.tieba.baidu.com/p/3401261090
Http://c.tieba.baidu.com/p/3401262501
Http://c.tieba.baidu.com/p/3401265064
Http://c.tieba.baidu.com/p/3401267418
Http://c.tieba.baidu.com/p/3401269064
Http://c.tieba.baidu.com/p/3401271975
Http://c.tieba.baidu.com/p/3401275139
Http://c.tieba.baidu.com/p/3401277774
Http://c.tieba.baidu.com/p/3401281005
Http://c.tieba.baidu.com/p/3401283127
Http://c.tieba.baidu.com/p/3401286484
Http://c.tieba.baidu.com/p/3401288923
Http://c.tieba.baidu.com/p/3401292451
Http://c.tieba.baidu.com/p/3401295600
Http://c.tieba.baidu.com/p/3401300264
Http://c.tieba.baidu.com/p/3401306089
Http://c.tieba.baidu.com/p/3401309158
Http://c.tieba.baidu.com/p/3401311653
Http://c.tieba.baidu.com/p/3401314703
Http://c.tieba.baidu.com/p/3401319245
Http://c.tieba.baidu.com/p/3401322787
Http://c.tieba.baidu.com/p/3401326676
Http://c.tieba.baidu.com/p/3401334776
Http://c.tieba.baidu.com/p/3401339395
Http://c.tieba.baidu.com/p/3401342356
Http://c.tieba.baidu.com/p/3401347019
Http://c.tieba.baidu.com/p/3401350674
Http://c.tieba.baidu.com/p/3401356183
Http://c.tieba.baidu.com/p/3401359224
Http://c.tieba.baidu.com/p/3401362226
Http://c.tieba.baidu.com/p/3401366680
Http://c.tieba.baidu.com/p/3401370283
Http://c.tieba.baidu.com/p/3401374214
Http://c.tieba.baidu.com/p/3401379095
Http://c.tieba.baidu.com/p/3401386339
Http://c.tieba.baidu.com/p/3401390687
Http://c.tieba.baidu.com/p/3401396398
Http://c.tieba.baidu.com/p/3401399908
Http://c.tieba.baidu.com/p/3401404692
Http://c.tieba.baidu.com/p/3401425618
Http://c.tieba.baidu.com/p/3401446967
Http://c.tieba.baidu.com/p/3401464586
Http://c.tieba.baidu.com/p/3401470328
Http://c.tieba.baidu.com/p/3401493923
Http://c.tieba.baidu.com/p/3401536865
Http://c.tieba.baidu.com/p/3401578384
Http://c.tieba.baidu.com/p/3401600310
Http://c.tieba.baidu.com/p/3401617472
Http://c.tieba.baidu.com/p/3401621365
Http://c.tieba.baidu.com/p/3401646342
Http://c.tieba.baidu.com/p/3401740182
Http://c.tieba.baidu.com/p/3401744637
Http://c.tieba.baidu.com/p/3401750120
Http://c.tieba.baidu.com/p/3401773776
Http://c.tieba.baidu.com/p/3401784027
Http://c.tieba.baidu.com/p/3401794711
Http://c.tieba.baidu.com/p/3401838348
Http://c.tieba.baidu.com/p/3401843910
Http://c.tieba.baidu.com/p/3401870124
Http://c.tieba.baidu.com/p/3401894568
Http://c.tieba.baidu.com/p/3401898069
Http://c.tieba.baidu.com/p/3401908319
Http://c.tieba.baidu.com/p/3401927756
Http://c.tieba.baidu.com/p/3401940484
Http://c.tieba.baidu.com/p/3401944994
Http://c.tieba.baidu.com/p/3401976111
Http://c.tieba.baidu.com/p/3402008894
Http://c.tieba.baidu.com/p/3402016021
Http://c.tieba.baidu.com/p/3402024262
Http://c.tieba.baidu.com/p/3402029534
Http://c.tieba.baidu.com/p/3402060255
Http://c.tieba.baidu.com/p/3402073540
Http://c.tieba.baidu.com/p/3402082631
Http://c.tieba.baidu.com/p/3402086977
Http://c.tieba.baidu.com/p/3402098504
Http://c.tieba.baidu.com/p/3402104975
Http://c.tieba.baidu.com/p/3402111219
Http://c.tieba.baidu.com/p/3402115447
Http://c.tieba.baidu.com/p/3402121604
Http://c.tieba.baidu.com/p/3402128379
Http://c.tieba.baidu.com/p/3402137145
Http://c.tieba.baidu.com/p/3402153119
Http://c.tieba.baidu.com/p/3402158202
Http://c.tieba.baidu.com/p/3402162910
Http://c.tieba.baidu.com/p/3402171049
Http://c.tieba.baidu.com/p/3402178919
Http://c.tieba.baidu.com/p/3402184592
Http://c.tieba.baidu.com/p/3402241131
Http://c.tieba.baidu.com/p/3402272311
Http://c.tieba.baidu.com/p/3402276862
Http://c.tieba.baidu.com/p/3402281836
Http://c.tieba.baidu.com/p/3402284675
Http://c.tieba.baidu.com/p/3402290435
Http://c.tieba.baidu.com/p/3402294605
Http://c.tieba.baidu.com/p/3402306073
Http://c.tieba.baidu.com/p/3402311292
Http://c.tieba.baidu.com/p/3402311709
Http://c.tieba.baidu.com/p/3402315515
Http://c.tieba.baidu.com/p/3402316393
Http://c.tieba.baidu.com/p/3402320261
Http://c.tieba.baidu.com/p/3402321165
Http://c.tieba.baidu.com/p/3402324645
Http://c.tieba.baidu.com/p/3402325846
Http://c.tieba.baidu.com/p/3402329233
Http://c.tieba.baidu.com/p/3402330407
Http://c.tieba.baidu.com/p/3402332819
Http://c.tieba.baidu.com/p/3402642518
Http://c.tieba.baidu.com/p/3402614519