Oracle International Corporation

Geoffrey Wilson

Todd Guay

Jay Rossiter

Jonathan Fredericks Soule

Vipul Manubhai Shah

Yong Feng

Gregory P Smith

Gregory Scott Smith

Gaylen D Royal

Jonathan Riel

An intelligent approach for collecting statistical information in information systems generally involves performing a set of administrative function steps within a &ldquo;maintenance window&rdquo; that is defined by one or more specified time periods. First, a set of administrative function steps to be performed are identified. The set of administrative function steps is prioritized to produce a set of prioritized administrative function steps. Then, the set of prioritized administrative function steps is performed during the maintenance window. Aspects and features of the invention include: identifying and prioritizing administrative function steps; estimated function times and maintenance window; failure prediction; environment recommendations; history information and learning techniques; saving state and context information; and user feedback.

Approach for collecting statistical information in information systems

A workload reduction mechanism for index tuning is described that selects relevant database statements from a database workload, standardizes a format of the relevant database statements and reduces the formatted, relevant database statements into a representative set of database statements. These statements may then be provided to an index tuning mechanism.

Workload reduction mechanism for index tuning

An intelligent approach for performing administrative functions generally involves performing a set of administrative function steps within a &ldquo;maintenance window&rdquo; that is defined by one or more specified time periods. First, a set of administrative function steps to be performed are identified. The set of administrative function steps is prioritized to produce a set of prioritized administrative function steps. Then, the set of prioritized administrative function steps is performed during the maintenance window. Aspects and features of the invention include: identifying and prioritizing administrative function steps; estimated function times and maintenance window; failure prediction; environment recommendations; history information and learning techniques; saving state and context information; and user feedback.

Approach for performing administrative functions in information systems

A method for non-recursive data driven parameter evaluation within an information management system (e.g., a relational database management system, RDBMS). Parameters are attributes within an RDBMS system whose value can be modified to influence the manner in which a database environment responds. Depending on the character of the data within a database environment or the hardware resources allocated to the database, the parameter values have a large influence on the performance efficiency of the database. For instance, a parameter value may influence the memory size of certain data storage areas within a database environment and, if set too small, can cause an inefficiently large amount of input/output accesses to occur as data is moved in and out of disk storage. Also, many parameters are data dependent on other parameters. The novel system presents an automated system for evaluating parameters using a non-recursive evaluation process. By using a non-recursive approach, the evaluation process is streamlined in that only one pass yields an optimum parameter evaluation and the results are reproducible. The novel system identifies a set of parameters within an environment to be tuned, eliminates cyclic dependencies, and orders the parameters based on independence, levels of dependence, impact on system performance and common data usage. The present invention is data driven because rules within a respective parameter are then evaluated based on data availability to arrive at a set of parameter value recommendations. In one embodiment instance, tablespace, system environment, and schema parameters can be evaluated within a RDBMS tuning session.

Growing community of inventors

Nashua, NH, United States of America

Geoffrey Wilson