CN106126409B - A kind of method and device monitoring oracle monolithic read latency in real time - Google Patents

Abstract

The invention discloses a method and device for real-time monitoring oracle single-block read delay. The method includes: performing real-time monitoring on currently generated single-block read events to obtain the read time used to complete the single-block read time; output. Through the above-mentioned technical solution disclosed in this application, the single-block read events generated in the oracle system are monitored in real time, and the read time used by each single-block read event is output in real time, so that the staff can obtain each single-block read event in real time The single-block read delay, that is, the read time; different from the prior art that outputs the average value of the single-block read time that occurs within a period of time as the monitored single-block read delay, in this application, each single-block read The read time of the event is output, so that the staff can know the read time of each single block read event in time, achieve real-time monitoring of the single block read event, and then effectively realize the monitoring of the single block read event.

Description

A method and device for real-time monitoring oracle single block read delay

technical field

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

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.

The method used to monitor single-block read in the prior art is realized through the awr (automatic workload repository) that comes with the oracle system, and the basic principle of awr for the monitoring of single-block read is as follows: realize the single-block read within a period of time Monitor, and output the average time of single-block reads that occur during this period as the monitored single-block read delay. It can be seen that in the prior art, the data obtained by the monitoring of the single block read realized by awr is the average value of the time used for the single block read within a period of time, rather than the real-time value, therefore, it cannot effectively reflect the single block read. real-time situation.

To sum up, there is a problem of poor effectiveness in the way of implementing the monitoring of single block reading in the prior art.

Contents of the invention

The object of the present invention is to provide a method and device for real-time monitoring of oracle single-block read delay, so as to solve the problem of poor effectiveness in the way of realizing the monitoring of single-block read in the prior art.

In order to achieve the above object, the present invention provides the following technical solutions:

A method for monitoring oracle single block read latency in real time, including:

Carry out real-time monitoring on the current single-block read event, and obtain the read time used to complete the single-block read time;

The read time is output.

Preferably, it also includes:

Judging whether the read time is greater than a preset time, if so, outputting an alarm message.

Preferably, output alarm information, including:

The read time and the preset time are carried in the alarm information and sent to a designated terminal.

Preferably, the read time is output, including:

The reading time is displayed on the corresponding display screen.

Preferably, the read time is output, including:

Voice broadcast the reading time.

A device for real-time monitoring of oracle single block read delay, comprising:

A read event generation module is used to generate a read event;

A monitoring module, configured to monitor in real time the single-block read event currently generated by the read event generating module, to obtain the read time used to complete the single-block read time;

An output module, configured to output the read time.

Preferably, it also includes:

A judging module, configured to judge whether the read time is greater than a preset time, and if so, output an alarm message.

Preferably, the judging module includes:

An alarm unit, configured to include the read time and the preset time in the alarm information and send it to a designated terminal.

Preferably, the output module includes:

The first output unit is used to display the reading time on a corresponding display screen.

Preferably, the output module includes:

The second output unit is used for voice broadcasting the reading time.

A method and device for real-time monitoring oracle single-block read delay provided by the present invention, wherein the method includes: performing real-time monitoring on currently generated single-block read events to obtain the read time used to complete the single-block read time; The reading time is output. Through the above-mentioned technical solution disclosed in this application, the single-block read events generated in the oracle system are monitored in real time, and the read time used by each single-block read event is output in real time, so that the staff can obtain each single-block read event in real time The single-block read delay, that is, the read time; different from the prior art that outputs the average value of the single-block read time that occurs within a period of time as the monitored single-block read delay, in this application, each single-block read The read time of the event is output, so that the staff can know the read time of each single block read event in time, achieve real-time monitoring of the single block read event, and then effectively realize the monitoring of the single block read event.

Description of drawings

In order to more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the following will briefly introduce the drawings that need to be used in the description of the embodiments or the prior art. Obviously, the accompanying drawings in the following description are only It is an embodiment of the present invention, and those skilled in the art can also obtain other drawings according to the provided drawings without creative work.

Fig. 1 is a flow chart of a method for real-time monitoring oracle single block read delay provided by an embodiment of the present invention;

FIG. 2 is a schematic structural diagram of a device for real-time monitoring oracle single-block read latency provided by an embodiment of the present invention.

Detailed ways

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.

Please refer to Fig. 1, which shows a flow chart of a method for real-time monitoring oracle single block read delay provided by an embodiment of the present invention, which may include the following steps:

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.

In the method for real-time monitoring of oracle single-block read delay provided by an embodiment of the present invention, the subject of the steps not marked with a subject may be a device for real-time monitoring of oracle single-block read delay. Specifically, in the embodiment of the present invention, a corresponding script can be executed on the oracle database server to generate a single-block read event, that is, the script is run to read a single data block, and then the device can monitor the single-block read event in real time, And get the read time used by each single block read event.

S12: Output the read time.

Every time a read time corresponding to a single block read time is obtained, it is output, so as to realize real-time monitoring of the single block read time.

Through the above-mentioned technical solution disclosed in this application, the single-block read events generated in the oracle system are monitored in real time, and the read time used by each single-block read event is output in real time, so that the staff can obtain each single-block read event in real time The single-block read delay, that is, the read time; different from the prior art that outputs the average value of the single-block read time that occurs within a period of time as the monitored single-block read delay, in this application, each single-block read The read time of the event is output, so that the staff can know the read time of each single block read event in time, achieve real-time monitoring of the single block read event, and then effectively realize the monitoring of the single block read event.

A method for real-time monitoring oracle single block read delay provided by the embodiment of the present invention may also include:

Determine whether the read time is greater than the preset time, and if so, output an alarm message.

It should be noted that the preset time is determined by the staff according to the actual needs, and is specifically the maximum value that can be achieved by the time for single-block read events when the performance of the oracle system is normal. Correspondingly, if the read event of the single block read event is greater than the preset event, it indicates that there is an abnormality in the single block read event. At this time, an alarm message is output to notify the staff to detect and maintain the performance of the oracle system. If the read time of the single-block read event is less than the preset time, it means that there is no abnormality in the single-block read event. At this time, no processing can be performed and the monitoring can be continued. In this way, it is ensured that the staff can timely discover and deal with the exception of the single-block read event, and ensure the normal operation of the oracle system.

Among them, there are many ways to output alarm information, such as outputting alarm information, which can include:

Carry the read time and preset time in the alarm message and send it to the designated terminal.

Wherein, the designated terminal may be a terminal corresponding to the staff, and the above output method may be to output the alarm information to the terminal corresponding to the staff in the form of a short message, so that the staff can be informed of the abnormality of the single block read event in time. Of course, other settings can also be made according to actual needs, such as setting an alarm for buzzer alarm, etc., all within the protection scope of the present invention.

A method for real-time monitoring oracle single-block read delay provided by an embodiment of the present invention outputs the read time, which may include:

Display the reading time on the corresponding display screen.

Output the read time, which can also include:

Voice broadcast will read the time.

Through the above method, the reading time can be intuitively output, which is convenient for the staff to know the reading time in time.

Corresponding to the above method, the embodiment of the present invention also provides a device for real-time monitoring oracle single block read delay, as shown in Figure 2, which may include:

Read event generation module 11, for generating read event;

The monitoring module 12 is used to monitor in real time the single block read event currently generated by the read event generation module, and obtain the read time used to complete the single block read time;

The output module 13 is configured to output the read time.

It should be noted that the read event generating module may be the above-mentioned script for generating read events. Specifically, the above-mentioned device provided by the embodiment of the present invention may also include a database, which stores data for the read event generation module to read, and the monitoring to obtain the read time may specifically monitor the read event, and read the event from start to The completed process is obtained in the form of code, and then the code is converted to obtain the corresponding read event.

A device for real-time monitoring oracle single block read delay provided by an embodiment of the present invention may also include:

The judging module is used to judge whether the reading time is greater than the preset time, and if so, output an alarm message.

The embodiment of the present invention provides a device for real-time monitoring oracle single block read delay, and the judging module may include:

The alarm unit is used to carry the read time and preset time in the alarm information and send it to the designated terminal.

The embodiment of the present invention provides a device for real-time monitoring oracle single block read delay, the output module may include:

The first output unit is used to display the reading time on the corresponding display screen.

The embodiment of the present invention provides a device for real-time monitoring oracle single block read delay, the output module may include:

The second output unit is used for voice broadcasting the reading time.

For the description of the relevant parts of the device for real-time monitoring oracle single-block read delay provided by the embodiment of the present invention, please refer to the detailed description of the corresponding part in the method for real-time monitoring of oracle single-block read delay provided by the embodiment of the present invention, here No longer.

The above description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the invention. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the invention. Therefore, the present invention will not be limited to the embodiments shown herein, but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.

Claims (6)

1. A method for real-time monitoring oracle single block read delay, characterized in that, comprising: Carry out real-time monitoring on the current single-block read event, and obtain the read time used to complete the single-block read event; outputting the read time; The method also includes: Judging whether the read time is greater than a preset time, if so, outputting an alarm message; Output alarm information, including: The read time and the preset time are carried in the alarm information and sent to a designated terminal. 2. The method according to claim 1, wherein outputting the read time comprises: The reading time is displayed on the corresponding display screen. 3. The method according to claim 1, wherein outputting the read time comprises: Voice broadcast the reading time. 4. A device for real-time monitoring oracle single block read delay, characterized in that, comprising: A read event generation module is used to generate a read event; A monitoring module, configured to monitor in real time the single-block read event currently generated by the read event generating module, and obtain the read time used to complete the single-block read event; an output module, configured to output the read time; The device also includes: A judging module, used to judge whether the read time is greater than a preset time, and if so, output an alarm message; The judgment module includes: An alarm unit, configured to include the read time and the preset time in the alarm information and send it to a designated terminal. 5. The device according to claim 4, wherein the output module comprises: The first output unit is used to display the reading time on a corresponding display screen. 6. The device according to claim 4, wherein the output module comprises: The second output unit is used for voice broadcasting the reading time.