公开(公告)号：US08892536B2

公开(公告)日：2014-11-18

申请号：US13627967

申请日：2012-09-26

Applicant: Oracle International Corporation

Inventor： Uri Shaft ,  Amirali Valiani ,  Peter Belknap

IPC: G06F7/02 ,  G06F17/30

CPC classification number: G06F17/30289

Abstract: A method for resolving a hang in a database system includes receiving a symbolic graph having a plurality of nodes, where each node represents a database session involved in the hang during a specified time interval. The blocking time associated with each node in the symbolic graph is recursively determined. The node that has the longest blocking time is output to a display for review by the database administrator. Alternatively, the database session represented by the node having the longest blocking time may be automatically eliminated.

Abstract translation: 一种用于解决数据库系统中的挂起的方法包括：接收具有多个节点的符号图，其中每个节点在指定的时间间隔内表示涉及挂起的数据库会话。 递归地确定与符号图中的每个节点相关联的阻塞时间。 具有最长阻塞时间的节点被输出到显示器以供数据库管理员查看。 或者，可以自动消除由具有最长阻塞时间的节点表示的数据库会话。

公开(公告)号：US20140089268A1

公开(公告)日：2014-03-27

申请号：US13627967

申请日：2012-09-26

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Uri Shaft ,  Amirali Valiani ,  Peter Belknap

IPC: G06F17/30

CPC classification number: G06F17/30289

Abstract: A method for resolving a hang in a database system includes receiving a symbolic graph having a plurality of nodes, where each node represents a database session involved in the hang during a specified time interval. The blocking time associated with each node in the symbolic graph is recursively determined. The node that has the longest blocking time is output to a display for review by the database administrator. Alternatively, the database session represented by the node having the longest blocking time may be automatically eliminated.

Abstract translation: 一种用于解决数据库系统中的挂起的方法包括：接收具有多个节点的符号图，其中每个节点在指定的时间间隔内表示涉及挂起的数据库会话。 递归地确定与符号图中的每个节点相关联的阻塞时间。 具有最长阻塞时间的节点被输出到显示器以供数据库管理员查看。 或者，可以自动消除由具有最长阻塞时间的节点表示的数据库会话。