Oracle International Corporation

Leng Leng Tan

Karl Dias

Gary C Ngai

Mark Charles Ramacher

Benoit Dageville

Graham Wood

Jonathan D Klein

Alex Tsukerman

Richard Sarwal

William H Waddington

Venkateshwaran Venkataramani

Sushil Kumar

Uri Shaft

Mohamed Ziauddin

Patricia C Grewell

Hasan Rizvi

Tirthankar Lahiri

Mohamed Zait

Roger J Bamford

Balasubrahmanyam Kuchibhotla

Khaled Yagoub

Sanjay Kaluskar

Dinesh Das

Vasudha Krishnaswamy

Sujatha Muthulingam

Gianfranco Putzolu

Leonidas Galanis

John Mark Beresniewicz

Yair Sarig

Gary Hallmark

Chao Liang

Marcus Fallen

Yujun Wang

Ajith Kumar Mysorenagarajarao

Allen Brumm

Wanli Yang

Vishwanath Karra

Hailing Yu

Gregory Scott Smith

Francisco Sanchez

Shivani Gupta

Michael Feng

Mike Feng

Balasubrahmanya Kuchibhotla

Hsiao-te Su

Amir Valiani

Jyotin Gautam

Techniques for indicating the status or health of a software system in a simple and summarized manner. In one embodiment, a health meter is displayed that displays a status value indicating the status or health of the software system. The status or health of the system as indicated by the health meter may be based upon one or more characteristics or perspectives (or components) of the system, such as performance, resource utilization, reliability, availability, scalability, and status values computed for the components.

Health meter

One or more usage models are provided for a database. Each usage model includes a set of rules that are used to analyze database performance. A usage model in one or more usage models is determined. Database information is determined based on the usage model. The database information is then analyzed based on rules associated with the usage model. One or more performance problems are determined based on the analysis.

Automatic database diagnostic usage models

A method and apparatus for capturing database system workload and replaying that workload in a database system is provided. According to one aspect, in order to subject a test database system to the same workload to which the production database system actually would be subjected, a database server in the production system captures and records workload that the database server receives from external entities. This captured workload is processed. Processes external to a database server in the test database system send the processed workload to that database server. As a result, the test database system is subjected to the same workload to which the production database system originally was subjected. The foregoing technique permits a database administrator to determine how the production database system will fare if the difference that is present in the test database system is introduced into the production database system.

Database workload capture and replay architecture

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.

Diagnosability system

Various embodiments of the invention provide solutions that can offer a consistent framework for tools that assist in the configuration, tuning, and/or troubleshooting of a database and/or an RDBMS. Merely by way of example, one set of embodiments provides a software framework for an advisor component of a database and/or RDBMS. In accordance with some embodiments, the framework might specify a common data model for such advisor components. The data model can include, merely by way of example, a set of one or more findings (which might, in some cases, describe the result of an analysis of a circumstance in the database, RDBMS, and/or a mid-tier application used with the database) and/or a set of one or more recommendations (which might provide suggestions for addressing the circumstance). In particular embodiments. In particular embodiments, the data model might include a set of on or more rationales, which can explain the recommendations. In some cases, the software framework might include a task associated with the advisor component and/or one or more interfaces, which can include, inter alia, user interfaces and/or APIs. Other sets of embodiments can provide methods, systems and/or software programs for implementing an advisor framework.

Advisor framework, systems, methods and software for implementing the same

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.

Self-managing performance statistics repository for databases

A method for receiving a database query language statement and performance information about the statement at an optimizer and generating one or more tuning actions for the statement with the performance information is disclosed.

Automatic SQL tuning advisor

Systems and methods to define and store performance baselines. A baseline may be defined as a pair of snapshots, each snapshot containing the same set of statistics and having a timestamp value associated therewith. The present invention allows for the designation, automatically or manually, of statistics collected over a certain period of time to be stored and used for comparison. Baselines may be used, for example, to manually or automatically compare with current system performance, compare difference-difference values and set thresholds to monitor current system performance.

Database performance baselines

An intelligent database infrastructure wherein the management of all database components is performed by and within the database itself by integrating management of various components with a central management control. Each individual database component, as well as the central management control, is self-managing. A central management control module integrates and interacts with the various database components. The database is configured to automatically tune to varying workloads and configurations, correct or alert about bad conditions, and advise on ways to improve overall system performance.

Self-managing database architecture

An approach for recovering after premature termination of a plurality of transactions involves: A) selecting a previously unselected transaction from the plurality of transactions; B) processing the selected transaction by undoing the lesser of a predetermined number of changes made by the selected transaction and all changes made by the selected transaction; and C) repeating steps A) and B) until all of the plurality of transactions have been processed. Another aspect of the approach involves: A) selecting a previously unselected transaction from the plurality of transactions, wherein the selected transaction is the previously unselected transaction from the plurality of transactions that made the fewest number of changes in the database; B) processing the selected transaction by undoing one or more changes in the database made by the selected transaction; and C) repeating steps A) and B) until all transactions from the plurality of transactions have been processed.

Method and apparatus for improved transaction recovery

A method and apparatus manage shared resources in a multiprocessing computer system. A coordinator process identifies resources to be operated upon by a plurality of worker processes. The coordinator process acquires locks to lock the resources on behalf of the plurality of worker processes. The plurality of worker processes then operate on the resources locked by the coordinator process.

Method for managing shared resources in a multiprocessing computer system

A method and apparatus for parallelizing operations that change a database is provided. A coordinator process receives a statement that requires data to be written into the database. In response to the statement, the coordinator process assigns granules of work to multiple processes. Each of the multiple processes executes the granule of work by writing to the database a distinct portion of the set of data that is to be added to the database. The various portions of data are then merged to update the set of data to be added to the database.

Method and apparatus for parallelizing operations that insert data into

A method for managing termination of a process that holds a resource lock on behalf of another process is described. A first process acquires a first lock to a resource on behalf of a second process to exclude other processes from accessing the resource. The second process then acquires a wait lock to the resource. Later, when a third process acquires the first lock to the resource, the third process determines whether the first process terminated without releasing the lock. If the first process did terminate without releasing the lock, the third process attempts to acquire the wait lock. In attempting to acquire the wait lock, execution of the third process is suspended until the second process releases the wait lock. Consequently, acquisition of the wait lock by the third process prevents concurrent access to the resource by the third process and the second process.

Method for managing termination of a lock-holding process using a

A method and system for recovering after a crash of an instance in a database is disclosed. According to the method, transaction information corresponding to all the transactions that existed in the failed instance is inspected. These transactions that were active at the time the instance crashed are marked as 'dead.' The database is made available to users after updating the transaction information and before undoing all of the changes or updates performed by dead transactions. The changes made by the dead transactions may be undone by new transactions on a on-demand basis after the database is made available. Specifically, when a new transaction is waiting to obtain a lock on a resource held by another transaction, the new transaction determines whether the owner of the lock is one of the dead transactions. If so, the new transaction rolls back some or all of the changes made by the dead transaction.

A method and apparatus for recovering an object that includes logged data and a set of non-logged data is provided. According to the method, a copy of the object resides in volatile memory. A change is made to the copy of the object. If the change does not change any data within the object other than the non-logged data, then the change is made to the copy of the object without generating redo information. If the change changes any data within the object other than the non-logged data, then redo information is generated in response to the change. The redo information is stored on non-volatile storage. After a failure, the redo information is used to restore all data within the object other than the non-logged data. The non-logged data may be restored by retrieving the non-logged data from a different object for which redo information was generated for the non-logged data. A description of how this technique may be used to efficiently perform selective non-deferred block cleanout is also provided.

Caching data in recoverable objects

Growing community of inventors

Sunnyvale, CA, United States of America

Leng Leng Tan