Database fault analysis method and device, electronic equipment, storage medium and product

CN121979715BActive Publication Date: 2026-06-26SYM TECH (GUANGDONG) CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
SYM TECH (GUANGDONG) CO LTD
Filing Date
2026-03-27
Publication Date
2026-06-26

AI Technical Summary

Technical Problem

Existing technologies struggle to quickly and accurately pinpoint the source of blockages in Oracle databases, leading to business delays and transaction timeouts. Furthermore, full log parsing is inefficient and results in high information redundancy.

Method used

By quickly identifying the blocking session identifier and time window using dynamic views, and extracting transaction records using the LogMiner tool, and cross-checking them with auxiliary information, we can obtain information on blocking SQL, transaction status, and resource contention.

Benefits of technology

It improves the efficiency and accuracy of troubleshooting blocking faults, ensures rapid identification of the root cause of the fault, reduces the inefficiency and redundancy of full log parsing, and enhances database stability.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN121979715B_ABST
    Figure CN121979715B_ABST
Patent Text Reader

Abstract

The application relates to a database fault analysis method and device, electronic equipment, a storage medium and a product. The method comprises the following steps: determining core associated information in a current fault scene through a dynamic view; wherein the core associated information comprises identification information of a blocking session, a blocking time window and auxiliary information of a blocked session; acquiring a log file of a database covering the blocking time window; extracting transaction records of a target session from the log file according to the identification information; extracting link information of a target transaction according to the transaction records; wherein the link information comprises at least one of a blocking structured query language statement, a transaction state of the target transaction and resource competition information; and cross-checking the link information with the auxiliary information to obtain a fault analysis result. In this way, the efficiency, accuracy and traceability of blocking fault troubleshooting are improved, and the root cause of the fault is quickly locked, thereby providing reliable support for stable operation of a database in a key business scenario.
Need to check novelty before this filing date? Find Prior Art