Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Automatic performance identification tuning system based on Oracle database

A database and tuning technology, applied in the field of database management, can solve problems such as manual search, time-consuming and laborious, and achieve the effect of saving labor costs and improving operation stability

Inactive Publication Date: 2012-08-01
SHANDONG UNIV
View PDF2 Cites 27 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the optimization scheme in this article requires the database administrator to analyze and solve the whole process. When the database response time exceeds the expected time, the reason can only be manually found and optimized, which is time-consuming and laborious.

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
  • Automatic performance identification tuning system based on Oracle database
  • Automatic performance identification tuning system based on Oracle database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0025] Embodiment 1: (system embodiment)

[0026] Embodiment 1 of the system of the present invention is as figure 1 Shown: a kind of automatic performance identification tuning system based on Oracle database, comprises performance acquisition module 3, performance analysis module 2 and performance tuning module 1, is characterized in that performance tuning module 1 comprises SQL statement level tuning module 4, Instance-level tuning module 5, logical object-level tuning module 6 and system-level tuning module 7, SQL statement-level tuning module 4 in performance tuning module 1, instance-level tuning module 5, and logical object-level tuning module 6 and the system-level tuning module 7 are respectively connected with the performance analysis module 2, the performance analysis module 2 is connected with the performance acquisition module 3, and the performance acquisition module 3 is connected with the database 8; the performance analysis module 2 includes an intelligent le...

Embodiment 2

[0027] Embodiment 2: (method embodiment)

[0028] A kind of working method of above-mentioned tuning system, such as figure 2 Shown: The steps are as follows:

[0029] (1) The performance collection module collects database performance data;

[0030] (2) The performance analysis module obtains performance parameters from the performance collection module, analyzes performance problems, and sends tuning instructions to the SQL statement-level tuning module, instance-level tuning module, logical object-level tuning module, and system-level tuning module;

[0031] (3) After the system-level tuning module receives the optimization instruction from the performance analysis module, it optimizes the operating system, disk, and network components according to the optimal theoretical value. For example, to avoid high I / O of the system, the data files are distributed in The physical I / O of different physical disks and data hotspot files is separated. After the optimization is comple...

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 automatic performance identification tuning system based on an Oracle database, belonging to the technical field of database management. The system comprises a performance acquisition module, a performance analysis module and a performance tuning module and is characterized in that: the performance tuning module comprises an SQL (structured query language) sentence-level tuning module, an instance-level tuning module, a logic object-level tuning module and a system-level tuning module, wherein the SQL sentence-level tuning module, the instance-level tuning module, the logic object-level tuning module and the system-level tuning module in the performance tuning module are connected with the performance analysis module respectively; and the performance analysis module is connected with the performance acquisition module. The system disclosed by the invention has the beneficial effects that: intelligent analysis and tuning on the Oracle database are realized, the traditional optimization method simply using manual and artificial judgment is changed, the DBA is released from the complicated operation and maintenance environment, the operational stability of the database is greatly improved, and the labor cost is saved.

Description

technical field [0001] The invention relates to an automatic performance identification and tuning system based on an Oracle database, which belongs to the technical field of database management. Background technique [0002] As a mainstream database system, Oracle is widely used in large-scale enterprise-level applications and data warehouses. In the case of high concurrent access by multiple users, a good user experience is essential, and this requires the database to have good performance. . Database performance is an overall index to measure and evaluate the operating efficiency of the database, and seeking good database performance is an important task for maintaining and managing the database. Once a performance problem occurs in the database, it is sometimes very difficult to locate the cause and solve the problem due to the complexity of the database itself and factors such as the operating system and the network. The article "Optimization Design Scheme for Large O...

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
IPC IPC(8): G06F17/30
Inventor 江铭炎李占红
Owner SHANDONG UNIV
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com