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