The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Aug. 10, 2010
Filed:
Sep. 03, 2004
Gary Ngai, Saratoga, CA (US);
Michael Feng, San Mateo, CA (US);
Alex Tsukerman, Foster City, CA (US);
Benoit Dageville, Foster City, CA (US);
Mark Ramacher, San Carlos, CA (US);
Karl Dias, Foster City, CA (US);
Graham S. Wood, El Granada, CA (US);
Leng Leng Tan, Sunnyvale, CA (US);
Richard Sarwal, Portola Valley, CA (US);
Sushil Kumar, San Jose, CA (US);
Gary Ngai, Saratoga, CA (US);
Michael Feng, San Mateo, CA (US);
Alex Tsukerman, Foster City, CA (US);
Benoit Dageville, Foster City, CA (US);
Mark Ramacher, San Carlos, CA (US);
Karl Dias, Foster City, CA (US);
Graham S. Wood, El Granada, CA (US);
Leng Leng Tan, Sunnyvale, CA (US);
Richard Sarwal, Portola Valley, CA (US);
Sushil Kumar, San Jose, CA (US);
Oracle International Corporation, Redwood Shores, CA (US);
Abstract
A self-managing workload repository (AWR) infrastructure useful for a database server to collect and manage selected sets of important system performance statistics. Based on a schedule, the AWR runs automatically to collect data about the operation of the database system, and stores the data that it captures into the database. The AWR is advantageously designed to be lightweight and to self manage its use of storage space so as to avoid ending up with a repository of performance data that is larger than the database that it is capturing data about. 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. Both the frequency of the statistics data capture and length of time for which data is kept is adjustable. Manual snapshots and purging may also be performed. The AWR captured data allows for both system level and user level analysis to be automatically performed without unduly impacting system performance, e.g., by eliminating or reducing the requirement to repeat the workload in order to diagnose problems.