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

Method for diagnosing large transactions and hotspot transactions of Oracle database

A database and transaction technology, applied in the database field, can solve the problems of increasing the difficulty of accurately diagnosing transaction problems, and the inability to accurately obtain the source of application modules, etc., to achieve the effect of improving diagnosis efficiency

Active Publication Date: 2016-12-07
FOCUS TECH
View PDF7 Cites 12 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Furthermore, when using traditional monitoring methods to monitor transactions, it is generally only possible to obtain SQL from the monitoring of the database level when identifying large or hot transactions, but cannot accurately obtain the source of the application module that started the transaction, which increases the need for accurate diagnosis of transaction problems difficulty

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 diagnosing large transactions and hotspot transactions of Oracle database
  • Method for diagnosing large transactions and hotspot transactions of Oracle database
  • Method for diagnosing large transactions and hotspot transactions of Oracle database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0045] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be described in further detail below in conjunction with specific embodiments and with reference to the accompanying drawings.

[0046] The present invention establishes an association between the application layer and the database layer by connecting each application program module of the system with the database transaction during the operation of the application system, and is equipped with an automatic monitoring method to monitor the operation time and operation frequency of the transaction, aiming at achieving Threshold standard transactions, based on the relationship between established transactions and application modules, accurately locate applications that start large and hot transactions, so that database managers can find application exceptions in a timely manner, and then implement SQL optimization and application process optimization in...

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 a method for diagnosing large transactions and hotspot transactions of an Oracle database. In the operation process of an Oracle database application system, by relating the applications of the system with the database transactions, correlating an application layer with a database layer and monitoring the operation time and operation frequency of the transactions through an automatic monitoring way, the applications of large transactions and hotspot transactions are accurately positioned and started for the transactions reaching the threshold standard based on the established relation between the transactions and the application module; and the diagnosis of large transactions and hotspot transactions in an operation process of the Oracle database application system comprises the following specific steps: 1) configuring an application module identifier and an Oracle database transaction identifier, and setting a transaction threshold; 2) starting the work threads or processes of the database application system background, wherein the work threads or processes include a sampling thread or process, a screening thread or process and an alarm thread or process; 3) initializing a special database connection pool module, and establishing relation between the application layer and the database layer; and 4) performing transaction sampling, wherein a sampling thread periodically obtains the transaction time consumption information of the transaction identifier from the view of the Oracle database application system.

Description

technical field [0001] The invention belongs to the technical field of databases, in particular to database system monitoring technology, in particular to a method for diagnosing large and hot issues of an Oracle database Background technique [0002] Database Transaction (Database Transaction) refers to a series of operations performed as a single logical unit of work, either completely executed or not executed at all. Transactions ensure that data-oriented resources are not permanently updated unless all operations within the transactional unit complete successfully. A transaction is a logical unit of work in database operation, and the transaction management subsystem in the DBMS is responsible for transaction processing. [0003] Transactions that take too long to run in the database are collectively referred to as large transactions, and transactions that run frequently in the database are collectively referred to as hot transactions. Whether they are large transaction...

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): G06F11/30G06F11/34G06F17/30
CPCG06F11/302G06F11/3065G06F11/3452G06F16/21G06F16/252G06F16/284G06F2201/80G06F2201/87
Inventor 陈涛
Owner FOCUS TECH
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