Oracle International Corporation

Oracel International Corporation

Vishwanath Karra

Sujatha Muthulingam

Karl Dias

Alex Tsukerman

Benoit Dageville

Amit Ganesh

Tirthankar Lahiri

Jonathan D Klein

Uri Shaft

Mohamed Ziauddin

Gary C Ngai

Mark Charles Ramacher

Dmitry Mikhailovich Potapov

Vasudha Krishnaswamy

Graham Wood

Gianfranco Putzolu

Alexander Tsukerman

Leng Leng Tan

Arvind Kumar Maheshwari

Wanli Yang

Sushil Kumar

Nicholas A Whyte

Richard Sarwal

Francisco Sanchez

Hsiao-te Su

Stephen Wexler

Anil Kumar Kothuri

Techniques for analyzing an execution of a query statement based on a random archive are disclosed. A plurality of query statements that are executed during a particular time period are identified. A random sampling function is executed to randomly select a set of query statements from the plurality of query statements. Execution plans and/or performance metrics associated with each execution of the randomly-selected query statements are stored into a random archive. Responsive to determining that a performance metric for a current execution of a particular query statement does not satisfy a performance criteria, information associated with the particular query statement from the random archive is analyzed. A model plan characteristic associated with an execution of the particular query statement stored in the random archive is determined. An execution plan associated with the model plan characteristic is determined for another execution of the particular query statement.

Database performance analysis based on a random archive

A method and system of reclaiming storage space in data storage systems is disclosed. In one embodiment, a high water mark of a data container is adjusted after data in the data container is compacted. As a result, unused space in the data container can be reclaimed.

Method and system of reclaiming storage space in data storage systems

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

A fact table is set up without any dimension columns. The data in the table is ordered according to an order corresponding to the ordering of the dimensions. The table is divided into segments corresponding to contiguous portions of data. The portions of the table containing non-null values for the measures are placed into the segments. The size of the segments and the location segments may be determined according to the density of discontinuities in the data. An indexed organized table is used to determine the beginning and end of each segment of the table, the locations of the discontinuities in the data, and to facilitate accessing the measures of the table.

Fact table storage in a decision support system environment

A method and apparatus for the dynamic management of disk space by multiple database server instances in a cluster configuration is disclosed. A segment is partitioned. Each partition is associated with a bitmap block. A partition's bitmap block indicates the freeness of the partition's data blocks. A partition's bitmap block may be owned by one server instance at a time. After determining from a partition's bitmap block where free disk space is located within the partition, the partition's bitmap block's owner may allocate the free disk space for the owner's use. A bitmap block may become owned by different server instances at different times. When a server instance ceases to actively use its bitmap block, another server instance may 'steal' the bitmap block. Thus, multiple server instances may allocate disk space in the same partition over time, preventing disk space waste.

Dynamic disk space management by multiple database server instances in a cluster configuration

Growing community of inventors

San Jose, CA, United States of America

Vishwanath Karra