oracle lock level defined

2011-10-09  来源:本站原创  分类:Database  人气:40 

0 none
1 NULL air Select
2 SS (Row-S) line-level shared lock, other objects can query the data lines Select for update, Lock for update, Lock row share
3 SX (Row-X) row-level exclusive lock is not allowed to do before submitting DML operations Insert, Update, Delete, Lock row share
4 S (Share) shared locks Create index, Lock share
5 SSX (S / Row-X) shared row-level exclusive lock Lock share row exclusive
6 X (Exclusive) Exclusive lock Alter table, Drop able, Drop index, Truncate table, Lock exclusive

Can refer to:
http://oracledba.iteye.com/blog/446606

相关文章
  • oracle lock level defined 2011-10-09

    0 none 1 NULL air Select 2 SS (Row-S) line-level shared lock, other objects can query the data lines Select for update, Lock for update, Lock row share 3 SX (Row-X) row-level exclusive lock is not allowed to do before submitting DML operations Insert

  • Detailed analysis of three ORACLE lock mechanism 2010-09-19

    ORACLE locking mechanism is mainly to control the concurrent operation, to ensure data consistency and accuracy. Here we learn ORACLE lock mechanism. Oracle RDBMS blockade can be divided into the following three categories: 1, the internal closure wi

  • oracle lock Xiangjie 2010-04-19

    Oracle introduced multiple granularity locking mechanism Under the protection of different objects, Oracle database lock can be divided into the following categories: (1) DML lock (data locks, data locks): used to protect the integrity of data; (2) D

  • ORACLE isolation level 2011-07-12

    ORACLE Isolation level :http://epub.itpub.net/3/4.htm Author : Parrotao Isolation level (isolation level) l Defines the transaction isolation level and the degree of isolation between transactions . l Isolation level and concurrency are mutually cont

  • ORACLE isolation level (forward) 2011-07-20

    ORACLE isolation level Author: Parrotao Isolation level (isolation level) l defines the transaction isolation level and the degree of isolation between transactions. l isolation level and concurrency are mutually contradictory: the higher the degree

  • Oracle lock table problem simple processing techniques 2011-03-27

    Oracle lock table problem simple processing techniques http://database.51cto.com 2010-04-16 14:27 Anonymous I want to comment (0) Abstract: In the development of Oracle database, we often experience frequent operation of Oracle tables, there will be

  • Oracle lock mode the higher the level of six more 2010-11-09

    ORACLE in the locks of the following models: 0: none 1: null null 2: Row-S line sharing (RS): shared table lock, sub share 3: Row-X line of exclusive (RX): for the changes, sub exclusive 4: Share a shared lock (S): stop other DML operations, share 5:

  • Oracle lock mode, the higher the level six more influence 2010-11-09

    ORACLE, the lock has the following modes: 0: none 1: null null 2: Row-S line sharing (RS): a shared table lock, sub share 3: Row-X line of exclusive (RX): for line changes, sub exclusive 4: Share a shared lock (S): stop other DML operation, share 5:

  • oracle lock table (kill the process at the OS level) 2011-03-16

    Close database SQL> shutdown immediate Close the database to ensure that does not kill off all the User Session When the instance can not be closed off when not using shutdown immediate, you can use shutdown abort shut down the instance, but closed a

  • Go into the Oracle isolation level (original) 2011-02-25

    Multi-user environment, concurrent access to data and data consistency Profile In only a single user database, the user can modify the data, without considering other users are simultaneously modifying the same data. But in a multi-user database, mul

  • About oracle lock escalation 2010-07-27

    Lock escalation occurs (lock escalation), the system will reduce the lock granularity. For example, the database system can be a table of 100 rows into a table-level locking locks. Now you are using a "lock to lock a whole," Generally speaking,

  • ORACLE lock management 2010-10-18

    ORACLE in the locks of the following models: 0: none 1: null null 2: Row-S line sharing (RS): shared table lock, sub share 3: Row-X line of exclusive (RX): for the changes, sub exclusive 4: Share a shared lock (S): stop other DML operations, share 5:

  • [Transfer] ORACLE lock management 2010-11-08

    ORACLE in the locks of the following models: 0: none 1: null null 2: Row-S line sharing (RS): shared table lock, sub share 3: Row-X line of exclusive (RX): for the changes, sub exclusive 4: Share a shared lock (S): stop other DML operations, share 5:

  • ORA-00031: session marked for kill on oracle lock table processing 2011-07-29

    ORACLE some operations in the process is killed, the status is set to "killed", but the lock does not release the resources for a long time, no way, when it had to restart the database. But this is not the best solution, now offers a solution to

  • oracle lock mechanism 2010-12-22

    Lock is a mechanism that is used to manage concurrent access to a shared resource. Solution to stop? Concurrent access to resources only when the lock will be used, but a single user mode, the database is not locked. Therefore, the purpose is to lock

  • Oracle lock easily comprehensible principles of articles --- 2011-02-09

    In modern multi-user multi-tasking system, bound to multiple users simultaneously access a shared object, this object may be tables, rows, or memory structure, in order to solve the concurrent access to multiple users brought data security , integrit

  • Stored procedure to set the lock level set transaction isolation level 2011-03-19

    Grammar SET TRANSACTION ISOLATION LEVEL { READ UNCOMMITTED | READ COMMITTED | REPEATABLE READ | SNAPSHOT | SERIALIZABLE } [ ; ] Remarks You can only set an isolation level option, and set the options on that connection will always remain in effect un

  • oracle lock table problem 2011-04-28

    1, Select * From v $ locked_object; lock table object under sessionid, to Tools - sessions to find the appropriate sessions to see the lock table sql statement Or direct execute: Select a.inst_id, c.sid, c.serial #, d.name, b.object_name, c.username,

  • oracle lock waiting for the diagnosis and rule out 2010-03-02

    In ORACLE, the To ensure data consistency, the data in the database in operation, the system will carry out the lock on the data accordingly. When the procedure changes were made to submit (commit) or rolled back (rollback), the locked resources woul

  • oracle lock Introduction 2010-07-14

    Lock (lock) mechanism for managing concurrent access to shared resources. Note that I said "shared resource" instead of "database row." Oracle will lock the row-level data on the table, which is nice, but Oracle will be used in a numbe