Method and device for detecting database blockage

Abstract

The invention discloses a method and a device for detecting database blockage. The method includes the steps: receiving database detection commands, reading stored current data acquired from databases according to a preset time period, and acquiring detection and analysis results and detected database response time information from the read current data; determining classified databases of the detection and acquisition results according to pre-stored classified database information, inquiring pre-stored classified database response time information and acquiring the corresponding database response time information of the classified databases; and determining the database blockage if the detected database response time exceeds acquired database response time by means of inquiry. By the aid of the method and the device, the detection efficiency of the databases at the HANG state can be improved.

Description

technical field [0001] The invention relates to ORACLE database (DB, DataBase) technology, in particular to a method and device for detecting database blockage (HANG). Background technique [0002] The current database, whether it is used for data warehouse or operational data storage, contains a wealth of massive data object information. Therefore, maintaining and ensuring database performance, that is, database business processing capabilities, is a huge challenge for timely finding and displaying the information users need. When the performance of the database is degraded and cannot meet the requirements of the application business processing capacity, it will cause the application business service to be blocked, making the user obviously perceive that the application business processing is slow and the processing time is long, which seriously affects the user experience. In the following description, the database This phenomenon is called database HANG. [0003] There a...

AI Technical Summary

Problems solved by technology

[0007] It can be seen from the above that the existing methods for detecting database HANG, for the first detection method, since database maintenance personnel or developers are required to monitor and report to the DBA, and then the DBA processes according to the relevant information reported, and in the reporting process , the database is already in the HANG state, such as stopping responding or responding extremely slowly. Therefore, a large area of ​​application business is affected, and the database HANG problem cannot be effectively and quickly detected, and the detection efficiency is low.

For the second method of detection by manually calling the operating system command, if the database is already in the HANG state before accessing or logging in to the database, the monitoring program connected to the database may already be in the HANG state, and all database-related data information cannot be accessed. Normal collection and transmission make it impossible for DBA to access or log in to the database to check the relevant database dynamic performance parameters. Moreover, when the database is in the HANG state, the relevant data information stored in it will not be accessible, so that the DBA cannot obtain relevant data information in time. Therefore, timely analysis and processing cannot be performed according to relevant data information, and at the same time, the database failure time is prolonged, which seriously affects the front-end application business, and the database HANG problem cannot be effectively and quickly detected, and the detection efficiency is low; moreover, due to the large number of databases , if the manual detection method is used for all databases, the workload is very large, and the current state of the database cannot be reflected in time

In addition, the existing methods for detecting database HANG are passive, and it is possible to obtain database-related information only through human operations

Images