In general, multiuser databases use some form of data locking to solve the problems
associated with data concurrency, consistency, and integrity. Locks are mechanisms
that prevent destructive interaction between transactions accessing the same resource.
Resources include two general types of objects:
■ User objects, such as tables and rows (structures and data)
■ System objects not visible to users, such as shared data structures in the memory
and data dictionary rows
锁机制
1. 锁是一种防止多个事务访问同一资源时产生破坏性的相互影响的机制
2. 这样的资源可以分为两类：
* 用户对象,例如表及数据行
* 用户不可见的系统对象,例如内存中的共享数据结构和数据字典中的信息
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10599713/viewspace-988273/ ，如需转载，请注明出处，否则将追究法律责任。
-
博文量740
-
访问量2002861
最新文章
- 人力&人手&人才&人物
- oracle树中prior的用法
- Using Supplied Packages to Manage Stored Outlines
- $ORACLE_HOMERDBMSADMIN目录下各SQL的含义
- PRODUCT_USER_PROFILE Table
- Backing Up Server Parameter Files with RMAN
- Backing Up Control Files with RMAN
- Backing Up Individual Tablespaces with RMAN
- Making Whole Database Backups with RMAN
- 目睹奥运火炬传递
