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

Method and system for dealing with Oracle overload

A coping method and user process technology, applied in the computer field, can solve problems such as low work efficiency, and achieve the effects of improving work efficiency, ensuring safety, and perfecting the database

Inactive Publication Date: 2017-12-05
ZHENGZHOU YUNHAI INFORMATION TECH CO LTD
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The purpose of the present invention is to provide a method and system for dealing with Oracle overload, which is used to solve the problem of low work efficiency in artificially finding the cause of accidents

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 and system for dealing with Oracle overload
  • Method and system for dealing with Oracle overload

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] In order to clearly illustrate the technical features of this solution, the present invention will be described in detail below through specific implementation modes and in conjunction with the accompanying drawings. The following disclosure provides many different embodiments or examples for implementing different structures of the present invention. To simplify the disclosure of the present invention, components and arrangements of specific examples are described below. Furthermore, the present invention may repeat reference numerals and / or letters in different instances. This repetition is for the purpose of simplicity and clarity and does not in itself indicate a relationship between the various embodiments and / or arrangements discussed. It should be noted that components illustrated in the figures are not necessarily drawn to scale. Descriptions of well-known components and processing techniques and processes are omitted herein to avoid unnecessarily limiting the...

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 and system for dealing with Oracle overload. The method comprises the steps of obtaining a process occupying the most resources; determining a corresponding session in Oracle according to the obtained process; determining a client side according to the session, and obtaining a user process running on the client side. The system comprises a user process module and a monitoring unit, the user process module is arranged on the client side, and the monitoring unit is arranged on a server side; the monitoring unit comprises a PGA process module and a session module; the PGA process module is connected with the user process module and used for establishing communication between the monitoring unit and the client side and verifying the user process module; after verification is successful, the session module corresponding to the user process module is established on the server side and used for operating an instance and calling a database. Compared with the prior art, according to the method and system for dealing with the Oracle overload, the user process causing the Oracle overload can be quickly located, and the working efficiency is improved.

Description

technical field [0001] The invention relates to the technical field of computers, in particular to a method and system for dealing with Oracle overload. Background technique [0002] Oracle database system is a popular relational database management system in the world at present. The system has good portability, convenient use, and strong functions, and is suitable for various large, medium, small, and microcomputer environments. It is a high-efficiency, reliable, and high-throughput database solution. [0003] As one of the most widely used commercial database servers in the world, Oracle database servers are mostly running important businesses, requiring 24-hour service, and unplanned downtime is not allowed. However, in daily use, there are often risks of malicious attacks on the database or bad scripts run by staff, resulting in unsmooth business use or even close to downtime. [0004] In the prior art, when the above situation is encountered, it is necessary to manua...

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/07G06F21/55
CPCG06F11/079G06F11/0793G06F21/552G06F21/554G06F2201/80
Inventor 王承龙
Owner ZHENGZHOU YUNHAI INFORMATION TECH CO LTD
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