Optimal configuration method and system of ORACLE database

A technology for optimizing configuration and database, applied in the database field, it can solve problems such as large differences in database performance, many combinations of configuration parameters, and large workload.

Active Publication Date: 2015-12-16
INSPUR BEIJING ELECTRONICS INFORMATION IND
View PDF4 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Database performance before and after configuration optimization may vary greatly
However, there are many configuration parameters in the ORACLE database, the number reaches more than a few hundred, the dependencies between the configuration parameters are not clear, and there are many combinations of configuration parameters.
If manual configuration is used, the database configuration is difficult and the workload is heavy

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Optimal configuration method and system of ORACLE database
  • Optimal configuration method and system of ORACLE database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0050] The core of the present invention is to provide a method for optimizing the configuration of the ORACLE database, which can greatly reduce the workload of configuring the ORACLE database, reduce the difficulty of configuration, and provide a scientific method for obtaining configuration optimization combinations.

[0051] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments It is a part of embodiments of the present invention, but not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0052] Please refer ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses an optimal configuration method and system of ORACLE database. The optimal configuration method comprises: establishing a configuration base category, correspondingly establishing a configuration parameter according to the configuration base category respectively, and setting a value list for the configuration parameter; obtaining the configuration parameter through a configuration base, and selecting an operated benchmark test case from a benchmark test case base; setting a parameter value according to a rule base, and forming preset configuration parameter combinations according to a permutation and combination method; modifying an ORACLE database start configuration file according to each preset configuration parameter combination, and operating the benchmark test case to obtain a test result of each preset configuration parameter combination; carrying out performance analysis on the test result of each preset configuration parameter combination; and selecting the configuration parameter combination meeting preset requirements according to the analysis result. The method can be used for reducing the optimal configuration difficulty of the ORACLE database and reducing the workload.

Description

technical field [0001] The invention relates to the field of databases, in particular to a method and system for optimal configuration of an ORACLE database. Background technique [0002] ORACLE database is a large-scale relational database based on client / server architecture developed by ORACLE. It is widely used in the field of online transaction processing and is used in key industries such as finance, telecommunications, energy, transportation, social security, and public security. [0003] Whether the ORACLE database configuration reflects the characteristics of the business system, and whether it is optimally matched with the business load directly affects the performance of the database. The database performance gap before and after configuration optimization may vary greatly. However, there are many configuration parameters of the ORACLE database, the number reaches more than several hundred, the dependencies between configuration parameters are not clear, and there...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/217G06F16/2228G06F16/284
Inventor 杨治康玉琢陈昌浩
Owner INSPUR BEIJING ELECTRONICS INFORMATION IND
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap