For user and server processes, PMON will release the locks held by users, roll back every uncommitted transaction, and release any resources this process is using.
而对于用户和服务器进程,PMON将释放用户持有的锁,回滚每个未提交事件,并释放该进程正在使用的所有资源。
When DB2 performs an index or table scan, DB2 will block on a row lock when it comes across an uncommitted row which another transaction has exclusively (X) locked.
DB2在执行索引或表扫描时,如果遇到一个被另一个事务独占 (X) 锁定的未提交行,那么 DB2将阻塞在行锁上。
Isolation: the degree of isolation this transaction has from the work of other transactions. For example, can this transaction see uncommitted writes from other transactions?
事务隔离:当前事务和其它事务的隔离的程度。例如,这个事务能否看到其他事务未提交的写数据?
We show that this protocol is free of deadlock and in addition a high priority transaction is not blocked by uncommitted lower priority transactions.
这个协议可以避免死锁,而且高优先级事务不会被未提交的低优先级事务阻塞。
Each query executed by a transaction sees only data that was committed before the query (not the transaction) began. An Oracle query never reads dirty (uncommitted) data.
事务中的查询只能看到在此查询之前(而非事务开始之前)提交的数据。
Each query executed by a transaction sees only data that was committed before the query (not the transaction) began. An Oracle query never reads dirty (uncommitted) data.
事务中的查询只能看到在此查询之前(而非事务开始之前)提交的数据。
应用推荐