利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

75 条记录 (耗时 0.031 秒)

    Automatic database diagnostic monitor architecture
    4.
    发明申请
    Automatic database diagnostic monitor architecture 有权
    自动数据库诊断监视器架构

    公开(公告)号：US20050055673A1

    公开(公告)日：2005-03-10

    申请号：US10775531

    申请日：2004-02-09

    申请人： Karl Dias ,  Shivani Gupta ,  Mark Ramacher ,  Uri Shaft ,  Venkateshwaran Venkataramani ,  Graham Wood ,  Juan Loaiza

    发明人： Karl Dias ,  Shivani Gupta ,  Mark Ramacher ,  Uri Shaft ,  Venkateshwaran Venkataramani ,  Graham Wood ,  Juan Loaiza

    IPC分类号： G06F9/44

    CPC分类号： G06F17/30306 ,  G06F17/30371

    摘要： Techniques for self-diagnosing performance problems in a database are provided. The techniques include classifying one or more performance problems in a database system. One or more values for quantifying an impact of the one or more performance problems on the database system are then determined. The quantified values are determined based on the performance of operations in the database system. A performance problem based on the one or more quantified values is then determined. A solution for the performance problem is generated and may be outputted.

    摘要翻译： 提供了数据库中自我诊断性能问题的技术。 这些技术包括对数据库系统中的一个或多个性能问题进行分类。 然后确定用于量化一个或多个性能问题对数据库系统的影响的一个或多个值。 量化值基于数据库系统中的操作性能来确定。 然后确定基于一个或多个量化值的性能问题。 产生性能问题的解决方案，并可以输出。

    Time model
    6.
    发明授权
    Time model 有权
    时间模型

    公开(公告)号：US07376682B2

    公开(公告)日：2008-05-20

    申请号：US10775513

    申请日：2004-02-09

    申请人： Mark Ramacher ,  Graham S. Wood ,  Juan Loaiza ,  Tirthankar Lahiri ,  Karl Dias

    发明人： Mark Ramacher ,  Graham S. Wood ,  Juan Loaiza ,  Tirthankar Lahiri ,  Karl Dias

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30008 ,  Y10S707/99957

    摘要： Quantifying the impact of wasteful operations on a database system is provided. One or more operations that are determined to be wasteful are received. The impact of the wasteful operations on performance in a database may then be quantified. The database is monitored to determine when a wasteful operation is being performed. When a wasteful operation is detected, a time value is recorded of the time spent on processing the wasteful operation. The time value is stored and used to quantify an impact of a performance problem in a database. The time value may be stored and associated with other time values that are recorded for the same wasteful operation. Thus, the impact of wasteful operations that are performed and processed in a database may be determined.

    摘要翻译： 提供了浪费操作对数据库系统的影响。 接收到被确定为浪费的一个或多个操作。 然后可以量化浪费操作对数据库中的性能的影响。 监视数据库以确定何时执行浪费的操作。 当检测到浪费的操作时，记录处理浪费操作花费的时间的时间值。 时间值被存储并用于量化数据库中性能问题的影响。 时间值可以被存储并且与为相同的浪费操作记录的其他时间值相关联。 因此，可以确定在数据库中执行和处理的浪费操作的影响。

    Automatic workload repository battery of performance statistics
    7.
    发明申请
    Automatic workload repository battery of performance statistics 有权
    自动工作负载库电池的性能统计

    公开(公告)号：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）统计信息中的一个或多个。