Method for monitoring SQL statement performance

A statement and performance technology, applied in special data processing applications, instruments, electronic digital data processing, etc., can solve the problems of third-party tool charges, databases not installed in the database, etc., to achieve the effect of reducing workload and easy customization

Inactive Publication Date: 2014-05-14
LANGCHAO ELECTRONIC INFORMATION IND CO LTD
View PDF4 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, in some extreme cases of these graphical tools, for example, the database is not installed with a database or third-party tools are charged, how to monitor the performance of database SQL statements becomes a problem

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
  • Method for monitoring SQL statement performance

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0015] Referring to the accompanying drawings, the implementation process of this structure will be described by taking the monitoring of single sql performance as an example for the content of the present invention.

[0016] As described in the summary of the invention, the logic implementation structure design method of the present invention mainly includes: oracle background process module (1), problem process module (2), problem sql module (3), problem sql resource consumption and execution plan module ( 4), interface module (5).

[0017] A logical structure of a method for monitoring the performance of an SQL statement includes that the oracle background process module is responsible for collecting relevant information of the SQL statement, including the number of executions of the relevant SQL statement within a specified time, the execution time, the number of times of parsing, the number of sub-cursors, etc., and then the These data are stored in the corresponding dict...

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 provides a method for monitoring SQL statement performance, and belongs to the field of computer system design and the field of databases. The performance of related SQL statements is monitored by reading a data dictionary of oracle and performance data of the operating system-level, and the dependence on a graphic interface tool is reduced. The method solves the problems that a traditional imaging management tool is high in cost and hard to manage, and the processing time of database maintenance workers is shortened.

Description

technical field [0001] The present invention relates to the field of computer system design and database field, in particular to a method for monitoring the performance of SQL statement of structured query language (Structured Query Language, SQL). Background technique [0002] In the current high-speed development of the information age, IT system performance issues have always been an insurmountable mountain in front of technicians. Various performance optimization methods are constantly being explored. In various database-based systems, in order to ensure the query efficiency of statements, IT companies have developed many technologies to provide support from various aspects. In terms of SQL optimization and tuning, Oracle's gridcontrol, OEM and other tools, as well as other third-party graphical tools, have done a better job. However, in some extreme cases of these graphical tools, for example, the database is not installed or the third-party tools are charged, how t...

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
CPCG06F11/3409
Inventor 初贤哲
Owner LANGCHAO ELECTRONIC INFORMATION IND CO LTD
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