Table Lock

Normal 0 0 2 false false false EN-US ZH-TW X-NONE Table Lock Mode        Description

ROW SHARE                Permits concurrent access to the locked table, but prohibits other users from locking the entire table for exclusive access.

ROW EXCLUSIVE            Same as ROW SHARE, but also prohibits locking in SHARE mode. This type of lock is obtained automatically with standard DML commands such as UPDATE, INSERT, or DELETE.

SHARE                              Permits concurrent queries but prohibits updates to the table; this mode is required to create an index on a table and is automatically obtained when using the CREATE INDEX statement.

SHARE ROW EXCLUSIVE  Used to query a whole table and to allow other users to query the table, but to prevent other users from locking the table in SHARE mode or updating rows.

EXCLUSIVE            The most restrictive locking mode; permits queries on the locked table but prohibits any DML by any other users. This mode is required to drop the table and is automatically obtained when using the DROP TABLE statement.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10314474/viewspace-617818/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10314474/viewspace-617818/