A method and device for real-time monitoring oracle single block read delay
A technology of real-time monitoring and single-block reading, applied in the computer field, can solve the problems of poor effectiveness and achieve the effect of monitoring
Active Publication Date: 2018-11-23
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 moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0034] The technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only a part of the embodiments of the present invention, rather than all the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative work shall fall within the protection scope of the present invention.
[0035] See figure 1 , Which shows a flowchart of a method for real-time monitoring of oracle single-block read delay provided by an embodiment of the present invention, which may include the following steps:
[0036] S11: Perform real-time monitoring of the current single block read event, and obtain the read time used to complete the single block read time.
[0037] In the method for real-time monitoring of oracle single-block read delay pr...
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
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 invention relates to the field of computer technology, and more specifically, to a method and device for real-time monitoring of 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, that is, 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 this value is exceeded, it is considered that the system has certain performance problems, such as the disk is too slow and needs to be replaced. Therefore, the monitoring of system performance can be realized through the monitoring of single block reading. [0003] In the prior art, the method for monitoring single-block reads is realized throu...
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
Login to View More Patent Type & Authority Patents(China)
IPC IPC(8): G06F11/34
CPCG06F11/3419G06F2201/80
Inventor 初贤哲杨磊
Owner INSPUR BEIJING ELECTRONICS INFORMATION IND