公开(公告)号：US09582367B2

公开(公告)日：2017-02-28

申请号：US13721895

申请日：2012-12-20

Applicant: Oracle International Corporation

Inventor： George An ,  Pete Belknap ,  Uri Shaft ,  Benoit Dageville ,  Ameet Kini

IPC: G06F17/30 ,  G06F11/14 ,  G06F11/32

CPC classification number: G06F11/1435 ,  G06F11/321 ,  G06F11/323 ,  G06F17/30424

Abstract: A method for obtaining data items from an unresponsive database host. The method includes receiving an indication that the database host is unresponsive, receiving, from a management server via a diagnostic connection, a first request for a first organized data item, and sending a first query, using a first interface, to a memory for the first organized data item. The method further includes receiving, from the management server via a normal connection, a second request for a second organized data item, retrieving, from memory on the database host, a first data item in response to the first query, converting the first data item into the first organized data item, and sending the first organized data item to the management server, wherein the first organized data item is analyzed to determine a source causing the database host to be unresponsive.

Abstract translation: 一种从无响应数据库主机获取数据项的方法。 该方法包括接收数据库主机不响应的指示，从管理服务器经由诊断连接接收对第一组织数据项的第一请求，以及使用第一接口向存储器发送第一查询 首先组织的数据项。 该方法还包括从管理服务器经由正常连接接收对第二组织数据项的第二请求，从数据库主机上的存储器检索响应于第一查询的第一数据项，转换第一数据项 进入第一组织数据项，并将第一组织数据项发送到管理服务器，其中分析第一组织数据项以确定导致数据库主机无响应的源。

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

公开(公告)号：US20140095453A1

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

申请号：US13721895

申请日：2012-12-20

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： George An ,  Pete Belknap ,  Uri Shaft ,  Benoit Dageville ,  Ameet Kini

IPC: G06F11/14 ,  G06F17/30

CPC classification number: G06F11/1435 ,  G06F11/321 ,  G06F11/323 ,  G06F17/30424

Abstract: A method for obtaining data items from an unresponsive database host. The method includes receiving an indication that the database host is unresponsive, receiving, from a management server via a diagnostic connection, a first request for a first organized data item, and sending a first query, using a first interface, to a memory for the first organized data item. The method further includes receiving, from the management server via a normal connection, a second request for a second organized data item, retrieving, from memory on the database host, a first data item in response to the first query, converting the first data item into the first organized data item, and sending the first organized data item to the management server, wherein the first organized data item is analyzed to determine a source causing the database host to be unresponsive.

Abstract translation: 一种从无响应数据库主机获取数据项的方法。 该方法包括接收数据库主机不响应的指示，从管理服务器经由诊断连接接收对第一组织数据项的第一请求，以及使用第一接口向存储器发送第一查询 首先组织的数据项。 该方法还包括从管理服务器经由正常连接接收对第二组织数据项的第二请求，从数据库主机上的存储器检索响应于第一查询的第一数据项，转换第一数据项 进入第一组织数据项，并将第一组织数据项发送到管理服务器，其中分析第一组织数据项以确定导致数据库主机无响应的源。