公开(公告)号：US20090105982A1

公开(公告)日：2009-04-23

申请号：US12251667

申请日：2008-10-15

申请人： Yair Sarig ,  Benoit Dageville ,  Marcus Fallen ,  Ajith Kumar Mysorenagarajarao ,  Karl Dias ,  Mark Ramacher ,  Gary Ngai

发明人： Yair Sarig ,  Benoit Dageville ,  Marcus Fallen ,  Ajith Kumar Mysorenagarajarao ,  Karl Dias ,  Mark Ramacher ,  Gary Ngai

IPC分类号： G06F19/00 ,  G06F15/00

CPC分类号： G06F11/0778 ,  G06F11/0748 ,  G06F11/0781 ,  H04L41/0681 ,  H04L41/16

摘要： Techniques for controlling collection of diagnostic data in a monitored system. A set of flood control rules are configured for the monitored system for controlling the gathering of diagnostic data in the monitored system. The set of flood control rules may include one or more default flood control rules. The set of flood control rules are user-configurable enabling the user of the monitored system to set policies for dynamically controlling gathering of diagnostic data for the monitored system. In one embodiment, diagnostic data gathering is controlled based upon a number of previous occurrences of a condition in some predefined or user-configured time frame that triggers diagnostic data gathering and/or a number of previous executions of an action performed in some predefined or user-configured time frame responsive to the condition in the monitored system.

摘要翻译： 用于控制监控系统中诊断数据收集的技术。 为监控系统配置了一组防洪规则，用于控制监控系统中诊断数据的收集。 防洪规则集可以包括一个或多个默认防洪规则。 一组防洪规则是用户可配置的，使受监控系统的用户能够设置动态控制监控系统诊断数据采集的策略。 在一个实施例中，诊断数据收集是基于在某些预定义或用户配置的时间帧中的先前事件的数量来控制的，该时间帧触发诊断数据收集和/或在某些预定义或用户中执行的动作的先前执行的数量 响应于受监视系统中的状况而配置的时间帧。

公开(公告)号：US08296104B2

公开(公告)日：2012-10-23

申请号：US12251648

申请日：2008-10-15

申请人： Mark Ramacher ,  Gary Ngai ,  Benoit Dageville ,  Karl Dias ,  Yair Sarig ,  Marcus Fallen ,  Ajith Kumar Mysorenagarajarao

发明人： Mark Ramacher ,  Gary Ngai ,  Benoit Dageville ,  Karl Dias ,  Yair Sarig ,  Marcus Fallen ,  Ajith Kumar Mysorenagarajarao

IPC分类号： G06F11/00 ,  G06F11/30

CPC分类号： G06F11/0778 ,  G06F11/0748 ,  G06F11/0781 ,  H04L41/0681 ,  H04L41/16

摘要： An infrastructure is provided for gathering diagnostic data that is relevant to an error or other conditions detected in a monitored system. A diagnosability framework is provided that automates the gathering of relevant diagnostic data upon occurrence of the condition in the monitored system. In one embodiment, context data is determined for the condition detected in the monitored system. A rule-based engine is provided that is configured to automatically determine one or more actions to be performed for the condition detected in the monitored system based on the determined context data. The actions may include performing tasks that gather diagnostic data that is relevant to the detected condition, store the gathered diagnostic data in a repository, recommend one or more diagnostic actions to a user, and other diagnostic related actions.

摘要翻译： 提供了一个基础设施，用于收集与受监视系统中检测到的错误或其他条件相关的诊断数据。 提供了一种诊断框架，可在受监控系统中发生状况时自动收集相关诊断数据。 在一个实施例中，为在所监视的系统中检测到的状况确定上下文数据。 提供了一种基于规则的引擎，其被配置为基于所确定的上下文数据来自动确定要在被监视系统中检测到的条件执行的一个或多个动作。 动作可以包括执行收集与检测到的条件相关的诊断数据的任务，将收集的诊断数据存储在存储库中，向用户推荐一个或多个诊断动作以及其他诊断相关的动作。

公开(公告)号：US08255182B2

公开(公告)日：2012-08-28

申请号：US12251667

申请日：2008-10-15

申请人： Yair Sarig ,  Benoit Dageville ,  Marcus Fallen ,  Ajith Kumar Mysorenagarajarao ,  Karl Dias ,  Mark Ramacher ,  Gary Ngai

发明人： Yair Sarig ,  Benoit Dageville ,  Marcus Fallen ,  Ajith Kumar Mysorenagarajarao ,  Karl Dias ,  Mark Ramacher ,  Gary Ngai

IPC分类号： G06F11/30 ,  G06F19/00

CPC分类号： G06F11/0778 ,  G06F11/0748 ,  G06F11/0781 ,  H04L41/0681 ,  H04L41/16

摘要： Techniques for controlling collection of diagnostic data in a monitored system. A set of flood control rules are configured for the monitored system for controlling the gathering of diagnostic data in the monitored system. The set of flood control rules may include one or more default flood control rules. The set of flood control rules are user-configurable enabling the user of the monitored system to set policies for dynamically controlling gathering of diagnostic data for the monitored system. In one embodiment, diagnostic data gathering is controlled based upon a number of previous occurrences of a condition in some predefined or user-configured time frame that triggers diagnostic data gathering and/or a number of previous executions of an action performed in some predefined or user-configured time frame responsive to the condition in the monitored system.

摘要翻译： 用于控制监控系统中诊断数据收集的技术。 为监控系统配置了一组防洪规则，用于控制监控系统中诊断数据的收集。 防洪规则集可以包括一个或多个默认防洪规则。 一组防洪规则是用户可配置的，使受监控系统的用户能够设置动态控制监控系统诊断数据采集的策略。 在一个实施例中，诊断数据收集是基于在某些预定义或用户配置的时间帧中的先前事件的数量来控制的，该时间帧触发诊断数据收集和/或在某些预定义或用户中执行的动作的先前执行的数量 响应于受监视系统中的状况而配置的时间帧。

公开(公告)号：US08135988B2

公开(公告)日：2012-03-13

申请号：US12251711

申请日：2008-10-15

申请人： Mark Ramacher ,  Gary Ngai ,  Benoit Dageville ,  Karl Dias ,  Yair Sarig ,  Marcus Fallen ,  Ajith Kumar Mysorenagarajarao

发明人： Mark Ramacher ,  Gary Ngai ,  Benoit Dageville ,  Karl Dias ,  Yair Sarig ,  Marcus Fallen ,  Ajith Kumar Mysorenagarajarao

IPC分类号： G06F11/00

CPC分类号： G06F11/0778 ,  G06F11/0748 ,  G06F11/0781 ,  H04L41/0681 ,  H04L41/16

摘要： Techniques for non-intrusive performance of diagnostic actions including actions that result in gathering of diagnostic data in response to a condition detected in a monitored system. In one embodiment, the diagnostic actions are performed asynchronously by processes or threads that are different from the failing process or thread that receives or detects the condition that triggers the diagnostic actions such that the failing process or thread can continue processing without being affected by the executions of the diagnostic actions. Multiple asynchronous processes or threads that are different from the failing process or thread may be spawned to perform multiple diagnostic actions in parallel. The asynchronous processes or threads may be monitored to ensure that they do not adversely impact the monitored system.

摘要翻译： 用于非侵入式执行诊断动作的技术，包括导致响应于在受监视系统中检测到的状况而收集诊断数据的动作。 在一个实施例中，诊断动作由与接收或检测触发诊断动作的状况不同的进程或线程不同的进程或线程异步执行，使得故障进程或线程可以继续处理而不受执行的影响 的诊断动作。 可能会产生与故障进程或线程不同的多个异步进程或线程，以并行执行多个诊断操作。 可以监视异步进程或线程，以确保它们不会对受监视的系统产生不利影响。

公开(公告)号：US07603340B2

公开(公告)日：2009-10-13

申请号：US10934344

申请日：2004-09-03

申请人： Gary Ngai ,  Mark Ramacher ,  Graham Wood ,  Connie Green ,  Venkateshwaran Venkatatamani ,  Karl Dias ,  Benoit Dageville ,  Michael Feng

发明人： Gary Ngai ,  Mark Ramacher ,  Graham Wood ,  Connie Green ,  Venkateshwaran Venkatatamani ,  Karl Dias ,  Benoit Dageville ,  Michael Feng

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F17/30289 ,  Y10S707/99932 ,  Y10S707/99945

摘要： A self-managing workload repository infrastructure (or “AWR” for Automatic workload repository) which is useful for a database server to collect and manage useful system performance statistics. The AWR runs automatically to collect performance data about the operation of the database system, and stores the data that it captures into the database. The collection process is done inside the database, and the collection process is highly efficient as data is retrieved directly from the shared memory of the database kernel. The data captured allows both system level and user level analysis to be performed without unduly impacting system performance, e.g., by eliminating or reducing the requirement to repeat the workload in order to diagnose problems. The AWR is configured to automatically capture snapshots of statistics data on a periodic basis as well as purge stale data on a periodic basis. The captured performance data includes one or more of the top N (e.g., 20 or 30) statistics for activities involving a large set of objects, time-based statistics, cumulative statistics, sampled data and metrics and other data types.

摘要翻译： 自管理工作负载存储库基础架构（或自动工作负载存储库的“AWR”），可用于数据库服务器收集和管理有用的系统性能统计信息。 AWR自动运行以收集有关数据库系统操作的性能数据，并将其捕获的数据存储到数据库中。 收集过程在数据库内完成，并且收集过程非常有效，因为直接从数据库内核的共享内存中检索数据。 捕获的数据允许执行系统级别和用户级别分析，而不会不必要地影响系统性能，例如通过消除或减少重复工作负载以便诊断问题的要求。 AWR配置为定期自动捕获统计数据的快照，并定期清除过期数据。 捕获的性能数据包括涉及大量对象，基于时间的统计，累积统计，采样数据和度量以及其他数据类型的活动的前N（例如，20或30）统计信息中的一个或多个。

公开(公告)号：US20090106589A1

公开(公告)日：2009-04-23

申请号：US12251731

申请日：2008-10-15

申请人： Mark Ramacher ,  Gary Ngai ,  Benoit Dageville ,  Karl Dias ,  Yair Sarig ,  Marcus Fallen ,  Ajith Kumar Mysorenagarajarao

发明人： Mark Ramacher ,  Gary Ngai ,  Benoit Dageville ,  Karl Dias ,  Yair Sarig ,  Marcus Fallen ,  Ajith Kumar Mysorenagarajarao

IPC分类号： G06F11/07

CPC分类号： G06F11/0778 ,  G06F11/0748 ,  G06F11/0781 ,  H04L41/0681 ,  H04L41/16

摘要： An infrastructure is provided for gathering diagnostic data that is relevant to an error or other conditions detected in a monitored system. A diagnosability framework is provided that automates the gathering of relevant diagnostic data upon occurrence of the condition in the monitored system. In one embodiment, context data is determined for the condition detected in the monitored system. A rule-based engine is provided that is configured to automatically determine one or more actions to be performed for the condition detected in the monitored system based on the determined context data. The actions may include performing tasks that gather diagnostic data that is relevant to the detected condition, store the gathered diagnostic data in a repository, recommend one or more diagnostic actions to a user, and other diagnostic related actions.

摘要翻译： 提供了一个基础设施，用于收集与受监视系统中检测到的错误或其他条件相关的诊断数据。 提供了一种诊断框架，可在受监控系统中发生状况时自动收集相关诊断数据。 在一个实施例中，为在所监视的系统中检测到的状况确定上下文数据。 提供了一种基于规则的引擎，其被配置为基于所确定的上下文数据来自动确定要在被监视系统中检测到的条件执行的一个或多个动作。 动作可以包括执行收集与检测到的条件相关的诊断数据的任务，将收集的诊断数据存储在存储库中，向用户推荐一个或多个诊断动作以及其他诊断相关的动作。

公开(公告)号：US20050086242A1

公开(公告)日：2005-04-21

申请号：US10934344

申请日：2004-09-03

申请人： Gary Ngai ,  Mark Ramacher ,  Graham Wood ,  Connie Green ,  Venkateshwaran Venkataramani ,  Karl Dias ,  Benoit Dageville ,  Michael Feng

发明人： Gary Ngai ,  Mark Ramacher ,  Graham Wood ,  Connie Green ,  Venkateshwaran Venkataramani ,  Karl Dias ,  Benoit Dageville ,  Michael Feng

IPC分类号： G06F7/00 ,  G06F17/00 ,  G06F17/30

CPC分类号： G06F17/30289 ,  Y10S707/99932 ,  Y10S707/99945

摘要： A self-managing workload repository infrastructure (or “AWR” for Automatic workload repository) which is useful for a database server to collect and manage useful system performance statistics. The AWR runs automatically to collect performance data about the operation of the database system, and stores the data that it captures into the database. The collection process is done inside the database, and the collection process is highly efficient as data is retrieved directly from the shared memory of the database kernel. The data captured allows both system level and user level analysis to be performed without unduly impacting system performance, e.g., by eliminating or reducing the requirement to repeat the workload in order to diagnose problems. The AWR is configured to automatically capture snapshots of statistics data on a periodic basis as well as purge stale data on a periodic basis. The captured performance data includes one or more of the top N (e.g., 20 or 30) statistics for activities involving a large set of objects, time-based statistics, cumulative statistics, sampled data and metrics and other data types.

摘要翻译： 自管理工作负载存储库基础架构（或自动工作负载存储库的“AWR”），可用于数据库服务器收集和管理有用的系统性能统计信息。 AWR自动运行以收集有关数据库系统操作的性能数据，并将其捕获的数据存储到数据库中。 收集过程在数据库内完成，并且收集过程非常有效，因为直接从数据库内核的共享内存中检索数据。 捕获的数据允许执行系统级别和用户级别分析，而不会不必要地影响系统性能，例如通过消除或减少重复工作负载以便诊断问题的要求。 AWR配置为定期自动捕获统计数据的快照，并定期清除过期数据。 捕获的性能数据包括涉及大量对象，基于时间的统计，累积统计，采样数据和度量以及其他数据类型的活动的前N（例如，20或30）统计信息中的一个或多个。

公开(公告)号：US08239167B2

公开(公告)日：2012-08-07

申请号：US12251731

申请日：2008-10-15

申请人： Mark Ramacher ,  Gary Ngai ,  Benoit Dageville ,  Karl Dias ,  Yair Sarig ,  Marcus Fallen ,  Ajith Kumar Mysorenagarajarao

发明人： Mark Ramacher ,  Gary Ngai ,  Benoit Dageville ,  Karl Dias ,  Yair Sarig ,  Marcus Fallen ,  Ajith Kumar Mysorenagarajarao

IPC分类号： G06F11/30

CPC分类号： G06F11/0778 ,  G06F11/0748 ,  G06F11/0781 ,  H04L41/0681 ,  H04L41/16

摘要： An infrastructure is provided for gathering diagnostic data that is relevant to an error or other conditions detected in a monitored system. A diagnosability framework is provided that automates the gathering of relevant diagnostic data upon occurrence of the condition in the monitored system. In one embodiment, context data is determined for the condition detected in the monitored system. A rule-based engine is provided that is configured to automatically determine one or more actions to be performed for the condition detected in the monitored system based on the determined context data. The actions may include performing tasks that gather diagnostic data that is relevant to the detected condition, store the gathered diagnostic data in a repository, recommend one or more diagnostic actions to a user, and other diagnostic related actions.

摘要翻译： 提供了一个基础设施，用于收集与受监视系统中检测到的错误或其他条件相关的诊断数据。 提供了一种诊断框架，可在受监控系统中发生状况时自动收集相关诊断数据。 在一个实施例中，为在所监视的系统中检测到的状况确定上下文数据。 提供了一种基于规则的引擎，其被配置为基于所确定的上下文数据来自动确定要在被监视系统中检测到的条件执行的一个或多个动作。 动作可以包括执行收集与检测到的条件相关的诊断数据的任务，将收集的诊断数据存储在存储库中，向用户推荐一个或多个诊断动作以及其他诊断相关的动作。

公开(公告)号：US20090105989A1

公开(公告)日：2009-04-23

申请号：US12251711

申请日：2008-10-15

申请人： Mark Ramacher ,  Gary Ngai ,  Benoit Dageville ,  Karl Dias ,  Yair Sarig ,  Marcus Fallen ,  Ajith Kumar Mysorenagarajarao

发明人： Mark Ramacher ,  Gary Ngai ,  Benoit Dageville ,  Karl Dias ,  Yair Sarig ,  Marcus Fallen ,  Ajith Kumar Mysorenagarajarao

IPC分类号： G21C17/00

CPC分类号： G06F11/0778 ,  G06F11/0748 ,  G06F11/0781 ,  H04L41/0681 ,  H04L41/16

摘要： Techniques for non-intrusive performance of diagnostic actions including actions that result in gathering of diagnostic data in response to a condition detected in a monitored system. In one embodiment, the diagnostic actions are performed asynchronously by processes or threads that are different from the failing process or thread that receives or detects the condition that triggers the diagnostic actions such that the failing process or thread can continue processing without being affected by the executions of the diagnostic actions. Multiple asynchronous processes or threads that are different from the failing process or thread may be spawned to perform multiple diagnostic actions in parallel. The asynchronous processes or threads may be monitored to ensure that they do not adversely impact the monitored system.

摘要翻译： 用于非侵入式执行诊断动作的技术，包括导致响应于在受监视系统中检测到的状况而收集诊断数据的动作。 在一个实施例中，诊断动作由与接收或检测触发诊断动作的状况不同的进程或线程不同的进程或线程异步执行，使得故障进程或线程可以继续处理而不受执行的影响 的诊断动作。 可能会产生与故障进程或线程不同的多个异步进程或线程，以并行执行多个诊断操作。 可以监视异步进程或线程，以确保它们不会对受监视的系统产生不利影响。

公开(公告)号：US07937623B2

公开(公告)日：2011-05-03

申请号：US12252056

申请日：2008-10-15

申请人： Mark Ramacher ,  Gary Ngai ,  Benoit Dageville ,  Karl Dias ,  Yair Sarig ,  Marcus Fallen ,  Ajith Kumar Mysorenagarajarao ,  John Beresniewicz ,  Mike Feng ,  Jonathan Klein ,  Hailing Yu ,  Leng Tan ,  Balasubrahmanya Kuchibhotla ,  Uri Shaft ,  Venkateshwaran Venkataramani ,  Amir Valiani

发明人： Mark Ramacher ,  Gary Ngai ,  Benoit Dageville ,  Karl Dias ,  Yair Sarig ,  Marcus Fallen ,  Ajith Kumar Mysorenagarajarao ,  John Beresniewicz ,  Mike Feng ,  Jonathan Klein ,  Hailing Yu ,  Leng Tan ,  Balasubrahmanya Kuchibhotla ,  Uri Shaft ,  Venkateshwaran Venkataramani ,  Amir Valiani

IPC分类号： G06F11/00

CPC分类号： G06F11/0778 ,  G06F11/0748 ,  G06F11/0781 ,  H04L41/0681 ,  H04L41/16

摘要： A diagnosability system for automatically collecting, storing, communicating, and analyzing diagnostic data for one or more monitored systems. The diagnosability system comprises several components configured for the collection, storage, communication, and analysis of diagnostic data for a condition detected in monitored system. The diagnosability system enables targeted dumping of diagnostic data so that only diagnostic data that is relevant for diagnosing the condition detected in the monitored system is collected and stored. This in turn enables first failure analysis thereby reducing the time needed to resolve the condition detected in the monitored system.

摘要翻译： 用于自动收集，存储，通信和分析一个或多个受监控系统的诊断数据的诊断系统。 诊断系统包括被配置用于收集，存储，通信和分析诊断数据的几个组件，用于在被监控系统中检测到的状况。 诊断系统能够有针对性地倾倒诊断数据，以便仅收集和存储与监视系统中检测到的病症相关的诊断数据。 这反过来使得能够进行第一次故障分析，从而减少解决在被监视系统中检测到的状况所需的时间。