公开(公告)号：US20200004860A1

公开(公告)日：2020-01-02

申请号：US16024868

申请日：2018-07-01

Applicant: Oracle International Corporation

Inventor： Arvind Kumar Maheshwari ,  Uri Shaft ,  Karl Dias ,  Vishwanath Karra ,  Stephen Wexler ,  Anil Kumar Kothuri

IPC: G06F17/30

Abstract: Techniques for analyzing an execution of a query statement based on a random archive are disclosed. A plurality of query statements that are executed during a particular time period are identified. A random sampling function is executed to randomly select a set of query statements from the plurality of query statements. Execution plans and/or performance metrics associated with each execution of the randomly-selected query statements are stored into a random archive. Responsive to determining that a performance metric for a current execution of a particular query statement does not satisfy a performance criteria, information associated with the particular query statement from the random archive is analyzed. A model plan characteristic associated with an execution of the particular query statement stored in the random archive is determined. An execution plan associated with the model plan characteristic is determined for another execution of the particular query statement.

公开(公告)号：US10997171B2

公开(公告)日：2021-05-04

申请号：US16024868

申请日：2018-07-01

Applicant: Oracle International Corporation

Inventor： Arvind Kumar Maheshwari ,  Uri Shaft ,  Karl Dias ,  Vishwanath Karra ,  Stephen Wexler ,  Anil Kumar Kothuri

IPC: G06F16/2453

Abstract: Techniques for analyzing an execution of a query statement based on a random archive are disclosed. A plurality of query statements that are executed during a particular time period are identified. A random sampling function is executed to randomly select a set of query statements from the plurality of query statements. Execution plans and/or performance metrics associated with each execution of the randomly-selected query statements are stored into a random archive. Responsive to determining that a performance metric for a current execution of a particular query statement does not satisfy a performance criteria, information associated with the particular query statement from the random archive is analyzed. A model plan characteristic associated with an execution of the particular query statement stored in the random archive is determined. An execution plan associated with the model plan characteristic is determined for another execution of the particular query statement.

公开(公告)号：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数据。

公开(公告)号：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数据。