Unlock instant, AI-driven research and patent intelligence for your innovation.

Method and device for real-time monitoring of oracle monoblock read delay

A real-time monitoring and single-block reading technology, applied in the computer field, can solve problems such as poor effectiveness and achieve the effect of monitoring

Active Publication Date: 2016-11-16
INSPUR BEIJING ELECTRONICS INFORMATION IND
View PDF6 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 device for real-time monitoring oracle single-block read delay, to solve the problem of poor effectiveness in the prior art for realizing the monitoring of single-block read

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 device for real-time monitoring of oracle monoblock read delay
  • Method and device for real-time monitoring of oracle monoblock read delay

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0035] see figure 1 , which shows a flow chart of a method for real-time monitoring oracle single-block read latency provided by an embodiment of the present invention, which may include the following steps:

[0036] S11: Perform real-time monitoring on the currently generated single-block read event, and obtain the read time required to complete the single-block read time.

[0037] In the method for real-time monitoring of oracle single-block read delay prov...

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 device for real-time monitoring of oracle monoblock read delay. The method comprises the steps of conducting real-time monitoring of a monoblock read event which is currently generated to obtain the read time required for completing the monoblock read event; outputting the read time. By the adoption of the technical scheme, monoblock read events generated in an oracle system are monitored in real time, and the read time for each monoblock read event is output in real time, so that working staff can obtain the monoblock read delay, namely read time, of each monoblock read event in real time. The method is different from the prior art that the average value of time for monoblock read within a period of time is used as monitored monoblock read delay and output in that the read time of each monoblock read event is output, so that working staff can acquire the read time of each monoblock read event in time, real-time monitoring of monoblock read events is achieved, and then monoblock read events are effectively monitored.

Description

technical field [0001] The present invention relates to the field of computer technology, and more specifically, to a method and device for real-time monitoring oracle single-block read delay. Background technique [0002] In the oracle system, when the program reads data through the index, or the program reads the data of the rollback segment for consistent reading, it is necessary to read a single data block, that is, a single block read; among them, oracle is The abbreviation of OracleDatabase, oracle database. It should be noted that by default, the time for a single block read in the oracle system is within a few milliseconds. If it exceeds this value, it is considered that the system has certain performance problems, such as the disk is too slow and needs to be replaced. Therefore, monitoring of system performance can be realized by monitoring single block read. [0003] The method used to monitor single-block read in the prior art is realized through the awr (automa...

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/34
CPCG06F11/3419G06F2201/80
Inventor 初贤哲杨磊
Owner INSPUR BEIJING ELECTRONICS INFORMATION IND