关于独占锁,或者说排他锁EXCLUSIVE-LOCK的用法?
答案:2 悬赏:20 手机版
解决时间 2021-03-23 11:27
- 提问者网友：人傍凄凉立暮秋
- 2021-03-22 11:51
关于独占锁,或者说排他锁EXCLUSIVE-LOCK的用法?
最佳答案
- 五星知识达人网友：毛毛
- 2021-03-22 12:08
我暂时保留我的看法！
全部回答
- 1楼网友：夜风逐马
- 2021-03-22 12:54
Oracle 独占锁(exclusive lock)允许其它事务读取数据吗？
清华大学出版的《数据库概论》上面说，独占锁不允许其它事务读取，不能更新，
lock table产生的锁对其它的session、user有作用。本会话还是能做修改，以commit或rollback结束lock。
Use the LOCK TABLE statement to lock one or more tables (or table partitions or
subpartitions) in a specified mode. This lock manually overrides automatic locking
and permits or denies access to a table or view by other users for the duration of
your operation.
Some forms of locks can be placed on the same table at the same time. Other locks
allow only one lock for a table.
///////////////////////////
A locked table remains locked until you either commit your transaction or roll it
back, either entirely or to a savepoint before you locked the table.
//////////////////////////////////////////
A lock never prevents other users from querying the table. A query never places a
lock on a table. Readers never block writers and writers never block readers.
清华大学出版的《数据库概论》上面说，独占锁不允许其它事务读取，不能更新，
lock table产生的锁对其它的session、user有作用。本会话还是能做修改，以commit或rollback结束lock。
Use the LOCK TABLE statement to lock one or more tables (or table partitions or
subpartitions) in a specified mode. This lock manually overrides automatic locking
and permits or denies access to a table or view by other users for the duration of
your operation.
Some forms of locks can be placed on the same table at the same time. Other locks
allow only one lock for a table.
///////////////////////////
A locked table remains locked until you either commit your transaction or roll it
back, either entirely or to a savepoint before you locked the table.
//////////////////////////////////////////
A lock never prevents other users from querying the table. A query never places a
lock on a table. Readers never block writers and writers never block readers.
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
点此我要举报以上问答信息
大家都在看
推荐资讯