公开(公告)号：US09477692B2

公开(公告)日：2016-10-25

申请号：US13756154

申请日：2013-01-31

Applicant: Oracle International Corporation

Inventor： John Beresniewicz ,  Stephen Wexler ,  Peter Belknap ,  Hsiao-Te Su ,  Ameet Kini

IPC: G06F17/30 ,  G06F11/32

CPC classification number: G06F17/30289 ,  G06F11/321 ,  G06F17/30306 ,  G06F2201/80

Abstract: Aspects of the present disclosure describe systems and methods for providing active session history data to users for use in database performance analysis. In various aspects, active session history data obtained from monitoring a database and/or database system over a period of time may be segmented into multiple dimensions. The segmented data may be subsequently provide and/or displayed on one or more interfaces, such as a graphical user interface, to users. The interface may visualize the dimensional ASH data in a variety of ways, such as through icons, graphs, charts, histograms, temporal delineations, treemaps, etc.

Abstract translation: 本公开的方面描述了用于向用户提供活动会话历史数据以用于数据库性能分析的系统和方法。 在各个方面，可以将在一段时间内从数据库和/或数据库系统监视获得的活动会话历史数据分割成多个维度。 分段数据可以随后在用户的一个或多个接口（诸如图形用户界面）上提供和/或显示。 该界面可以通过各种方式，例如通过图标，图形，图表，直方图，时间描绘，颤抖等可视化ASH数据。

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

公开(公告)号：US20140236921A1

公开(公告)日：2014-08-21

申请号：US14251521

申请日：2014-04-11

Applicant: Oracle International Corporation

Inventor： Peter Belknap ,  Benoit Dageville ,  Dinesh Das ,  Khaled Yagoub ,  Mohamed Zait ,  Mohamed Ziauddin

IPC: G06F17/30

CPC classification number: G06F17/30469 ,  G06F17/30463

Abstract: Approaches, techniques, and mechanisms are disclosed for ensuring that a database command is executed according to a query plan that has been verified to be actually optimal. Except in rare circumstances, a database server does not execute a query plan unless it is first verified by the database server. The database server receives a request to execute a database command. The database server determines an unverified plan is the best plan for satisfying the request. Rather than risk the unknown behavior of an unverified plan, the database server instead satisfies the request according to a verified plan. Subsequently—for example as part of a scheduled job—the database server executes the unverified plan to determine performance statistics. Based at least on the performance statistics, the database server determines whether or not to verify the unverified plan. Techniques for concurrent and optimistic verifications are also disclosed.

Abstract translation: 公开了方法，技术和机制，以确保根据已被验证为实际最佳的查询计划来执行数据库命令。 除非在极少数情况下，数据库服务器不执行查询计划，除非数据库服务器首先进行了验证。 数据库服务器接收执行数据库命令的请求。 数据库服务器确定未验证的计划是满足请求的最佳方案。 而不是冒险未验证的计划的未知行为，数据库服务器而是根据验证的计划满足请求。 随后 - 例如作为计划作业的一部分 - 数据库服务器执行未验证的计划以确定性能统计信息。 至少基于性能统计，数据库服务器确定是否验证未验证的计划。 还公开了并发和乐观验证的技术。

公开(公告)号：US20140095428A1

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

申请号：US13756154

申请日：2013-01-31

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： John Beresniewicz ,  Stephen Wexler ,  Peter Belknap ,  Hsiao-Te Su ,  Ameet Kini

IPC: G06F17/30

CPC classification number: G06F17/30289 ,  G06F11/321 ,  G06F17/30306 ,  G06F2201/80

Abstract: Aspects of the present disclosure describe systems and methods for providing active session history data to users for use in database performance analysis. In various aspects, active session history data obtained from monitoring a database and/or database system over a period of time may be segmented into multiple dimensions. The segmented data may be subsequently provide and/or displayed on one or more interfaces, such as a graphical user interface, to users. The interface may visualize the dimensional ASH data in a variety of ways, such as through icons, graphs, charts, histograms, temporal delineations, treemaps, etc.

Abstract translation: 本公开的方面描述了用于向用户提供活动会话历史数据以用于数据库性能分析的系统和方法。 在各个方面，可以将在一段时间内从数据库和/或数据库系统监视获得的活动会话历史数据分割成多个维度。 分段数据可以随后在用户的一个或多个接口（诸如图形用户界面）上提供和/或显示。 该界面可以通过各种方式，例如通过图标，图形，图表，直方图，时间描绘，颤抖等可视化ASH数据。

公开(公告)号：US09720941B2

公开(公告)日：2017-08-01

申请号：US14549449

申请日：2014-11-20

Applicant: Oracle International Corporation

Inventor： Peter Belknap ,  Benoit Dageville ,  Karl Dias ,  Khaled Yagoub

IPC: G06F17/30

CPC classification number: G06F17/30463 ,  G06F17/30306 ,  G06F17/30442 ,  G06F17/30477 ,  G06F17/30536 ,  G06F17/30864 ,  Y10S707/99932

Abstract: Techniques are provided for a fully-automated process for tuning database query language statements that selects database query language statements for tuning, tunes the database query language statements and generates tuning recommendations, tests the tuning recommendations, and determines whether to implement the tuning recommendations based on the test results. The fully-automated tuning process may also automatically implement certain tuning recommendations and monitor the performance of the database query language statements for which tuning recommendations have been implemented.

公开(公告)号：US10229158B2

公开(公告)日：2019-03-12

申请号：US14251521

申请日：2014-04-11

Applicant: Oracle International Corporation

Inventor： Peter Belknap ,  Benoit Dageville ,  Dinesh Das ,  Khaled Yagoub ,  Mohamed Zait ,  Mohamed Ziauddin

IPC: G06F7/00 ,  G06F17/00 ,  G06F17/30

Abstract: Approaches, techniques, and mechanisms are disclosed for ensuring that a database command is executed according to a query plan that has been verified to be actually optimal. Except in rare circumstances, a database server does not execute a query plan unless it is first verified by the database server. The database server receives a request to execute a database command. The database server determines an unverified plan is the best plan for satisfying the request. Rather than risk the unknown behavior of an unverified plan, the database server instead satisfies the request according to a verified plan. Subsequently—for example as part of a scheduled job—the database server executes the unverified plan to determine performance statistics. Based at least on the performance statistics, the database server determines whether or not to verify the unverified plan. Techniques for concurrent and optimistic verifications are also disclosed.

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