Detecting and Resolving Distributed Locking Conflicts

Maclean Liu(刘相兵

PURPOSE
-------

Oracle's Distributed Database Option provides the ability to perform
transactions spanning multiple networked databases.

As in standalone databases, transactions may block each other as they
try to exclusively access database table rows, causing Locking Conflicts.
In the former case, tools and scripts exist that can help the DBA
detect and resolve such conflicts.

In distributed databases, the same tools do not always help in the detection
of such conflicts, as they operate on locking information obtained only from
the database on which they are run. This information cannot be used to detect
distributed locking conflicts unless it is combined with similar information
obtained from all databases in the distributed environment.

Such distributed locking conflicts are automatically resolved by the RDBMS
by rolling back any blocked distributed transactions that have been waiting
for a time longer than DISTRIBUTED_LOCK_TIMEOUT seconds (default 60 sec).
Unfortunately there is no facility for allowing the blocked session to continue
after arranging for the blocker to commit/rollback/kill its session.

There are situations where it would be useful for the DBA to be able to
detect whether a session is blocked waiting on a distributed transaction
and to find the session blocking it in the network of distributed databases.
The DBA can then resolve the conflict in the usual manner e.g. by arranging
for the blocker to commit or rollback or by killing the blocking session.

This Bulletin describes a method and provides a script for performing the
above actions. When presented with a session that is assumed blocked by a
distributed locking conflict, the DBA can run the provided script and determine
the location and the identity of the session blocking the waiter. With this
information available it becomes simple for the DBA to resolve the locking
conflict by use of the same mechanisms used in standalone databases.




Detecting and Resolving Distributed Locking Conflicts.zip (58.26 KB, 下载次数: 5, 售价: 10 金钱)

2012-3-9 22:21 上传

点击文件名下载附件
售价: 10 金钱  [记录]

zhuqibs

oracle的分布数据库，还不是nosql的，下下来看看