CN106126409A - A kind of method and device of real-time monitoring oracle monolithic read latency - Google Patents
A kind of method and device of real-time monitoring oracle monolithic read latency Download PDFInfo
- Publication number
- CN106126409A CN106126409A CN201610516165.3A CN201610516165A CN106126409A CN 106126409 A CN106126409 A CN 106126409A CN 201610516165 A CN201610516165 A CN 201610516165A CN 106126409 A CN106126409 A CN 106126409A
- Authority
- CN
- China
- Prior art keywords
- time
- read
- monolithic
- real
- read time
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/34—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
- G06F11/3409—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment for performance assessment
- G06F11/3419—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment for performance assessment by assessing time
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
- G06F2201/80—Database-specific techniques
Abstract
The invention discloses the method and device of a kind of real-time monitoring oracle monolithic read latency, the method includes: monitors the current single block read events produced in real time, has obtained this read time used by monolithic read time；Read time is exported.By technique scheme disclosed in the present application, the single block read events produced in monitoring oracle system in real time, and the read time used by each single block read events is exported, so that staff can obtain the monolithic read latency of each single block read events, i.e. read time in real time in real time；Carry out exporting different as the monolithic read latency monitored from the meansigma methods that in prior art, the monolithic occurred in a period of time is read the time used, in the application, the read time to each single block read events all exports, so that staff can know the read time of each single block read events in time, reach the real-time monitoring for single block read events, and then effectively achieve the monitoring for single block read events.
Description
Technical field
The present invention relates to field of computer technology, more particularly, it relates to a kind of monitoring oracle monolithic read latency in real time
Method and device.
Background technology
In oracle system, when occurring that program is passed through index and read data, or program is read in order to concordance reads
It is required to carry out the reading of individual data block, i.e. monolithic during the situations such as the data of roll-back segment read；Wherein, oracle is Oracle
The abbreviation of Database, i.e. oracle database.It should be noted that carry out once single under default situations in oracle system
The time that block is read is within several milliseconds, and this value is considered as this system and there is certain performance issue, such as magnetic if more than
Dish needs to change disk etc. the most slowly, therefore, it can the monitoring by reading monolithic, it is achieved for the monitoring of systematic function.
The mode read for monitoring monolithic in prior art is the awr (automatic carried by oracle system
Workload repository) realize, and the ultimate principle of the monitoring that awr reads for monolithic is as follows: real within a period of time
The monitoring now monolithic read, and the meansigma methods that the interior monolithic occurred reads the time used during this period of time is read as the monolithic monitored
Postpone to export.Visible, prior art utilize the data obtained by the monitoring that the monolithic that awr realizes reads in a period of time
Monolithic read meansigma methods rather than the instantaneous value of time used, therefore, can not effectively reflect the real-time feelings that monolithic is read
Condition.
In sum, there is, to the mode of the monitoring that monolithic is read, the problem that effectiveness is poor for realization in prior art.
Summary of the invention
It is an object of the invention to provide the method and device of a kind of real-time monitoring oracle monolithic read latency, existing to solve
The problem that the effectiveness that exists for the mode of monitoring realizing reading monolithic in technology is poor.
To achieve these goals, the present invention provides following technical scheme:
A kind of method of real-time monitoring oracle monolithic read latency, including:
The current single block read events produced is monitored in real time, has obtained this read time used by monolithic read time；
Described read time is exported.
Preferably, also include:
Judge whether described read time is more than Preset Time, if it is, output warning message.
Preferably, export warning message, including:
Described read time and described Preset Time are carried in described warning message and send to designated terminal.
Preferably, described read time is exported, including:
Described read time is shown on corresponding display screen.
Preferably, described read time is exported, including:
Described read time is carried out voice broadcast.
A kind of device of real-time monitoring oracle monolithic read latency, including:
Reading event generation module, is used for producing reading event；
Monitoring module, monitors in real time for the single block read events currently produced described reading event generation module,
To the read time completed used by this monolithic read time；
Output module, for exporting described read time.
Preferably, also include:
Judge module, is used for judging whether described read time is more than Preset Time, if it is, output warning message.
Preferably, described judge module includes:
Alarm unit, for being carried in described warning message transmission to specifying by described read time and described Preset Time
Terminal.
Preferably, described output module includes:
First output unit, for showing described read time at corresponding display screen.
Preferably, described output module includes:
Second output unit, for carrying out voice broadcast by described read time.
The method and device of a kind of real-time monitoring oracle monolithic read latency that the present invention provides, wherein, the method includes:
The current single block read events produced is monitored in real time, has obtained this read time used by monolithic read time；By described reading
Time exports.By technique scheme disclosed in the present application, the monolithic produced in monitoring oracle system in real time reads thing
Part, and the read time used by each single block read events is exported, so that staff can obtain often in real time in real time
The monolithic read latency of individual single block read events, i.e. read time；With prior art, the monolithic occurred in a period of time is read institute's used time
Between meansigma methods carry out output difference, read time to each single block read events in the application as the monolithic read latency monitored
All export such that it is able to make staff can know the read time of each single block read events in time, reach for list
The real-time monitoring of block read events, and then effectively achieve the monitoring for single block read events.
Accompanying drawing explanation
In order to be illustrated more clearly that the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
In having technology to describe, the required accompanying drawing used is briefly described, it should be apparent that, the accompanying drawing in describing below is only this
Inventive embodiment, for those of ordinary skill in the art, on the premise of not paying creative work, it is also possible to according to
The accompanying drawing provided obtains other accompanying drawing.
The flow chart of the method for a kind of real-time monitoring oracle monolithic read latency that Fig. 1 provides for the embodiment of the present invention；
The structural representation of the device of a kind of real-time monitoring oracle monolithic read latency that Fig. 2 provides for the embodiment of the present invention
Figure.
Detailed description of the invention
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is carried out clear, complete
Describe, it is clear that described embodiment is only a part of embodiment of the present invention rather than whole embodiments wholely.Based on
Embodiment in the present invention, it is every other that those of ordinary skill in the art are obtained under not making creative work premise
Embodiment, broadly falls into the scope of protection of the invention.
Refer to Fig. 1, it illustrates the side of a kind of real-time monitoring oracle monolithic read latency that the embodiment of the present invention provides
The flow chart of method, may comprise steps of:
S11: the current single block read events produced is monitored, when having obtained this reading used by monolithic read time in real time
Between.
The method of a kind of real-time monitoring oracle monolithic read latency that the embodiment of the present invention provides is not indicated the step of subject
Rapid subject can be all the device of a kind of real-time monitoring oracle monolithic read latency.Specifically, can in the embodiment of the present invention
To perform corresponding script on oracle database server, to produce single block read events, i.e. run this script to carry out list
The reading of individual data block, and then single block read events is monitored in real time by this device, and when obtaining the reading used by each single block read events
Between.
S12: read time is exported.
Often obtain a read time corresponding to monolithic read time just it to be exported, thus realize for monolithic read time
Real-time monitoring.
By technique scheme disclosed in the present application, single block read events of generation in monitoring oracle system in real time, and
And the read time used by each single block read events is exported, so that staff can obtain each monolithic in real time in real time
The monolithic read latency of reading event, i.e. read time；With prior art, the monolithic occurred in a period of time is read the flat of time used
Average carries out output difference as the monolithic read latency monitored, and in the application, the read time to each single block read events is all carried out
Output such that it is able to make staff can know the read time of each single block read events in time, reaches to read thing for monolithic
The real-time monitoring of part, and then effectively achieve the monitoring for single block read events.
The method of a kind of real-time monitoring oracle monolithic read latency that the embodiment of the present invention provides, it is also possible to including:
Judge whether read time is more than Preset Time, if it is, output warning message.
Determine according to actual needs it should be noted that Preset Time is staff, be specially in oracle system
The maximum that in the case of performance is normal, the time used by single block read events can reach.Corresponding, if the reading of single block read events
Event is more than predeterminable event, then illustrate that this list block read events exists abnormal, now export warning message, to notify staff couple
The performance of oracle system detects and safeguards.If the read time of single block read events is less than Preset Time, then this list is described
There is not exception in block read events, at this point it is possible to be left intact, continues monitoring.Thus ensure that staff is for monolithic
Read finding in time and processing of event anomalies, it is ensured that the normal work of oracle system.
Wherein, the mode of output warning message has a variety of, such as output warning message, may include that
Read time and Preset Time are carried in warning message and send to designated terminal.
Wherein, it is intended that terminal can be the terminal corresponding with staff, the above-mentioned way of output can be the shape with note
Formula is by terminal corresponding for warning message output to staff such that it is able to make staff know single block read events in time
Abnormal.Arrange it is, of course, also possible to carry out other according to actual needs, carry out buzzing warning etc., all at this as arranged siren
Within bright protection domain.
The method of a kind of real-time monitoring oracle monolithic read latency that the embodiment of the present invention provides, carries out defeated by read time
Go out, may include that
Read time is shown on corresponding display screen.
Read time is exported, it is also possible to including:
Read time is carried out voice broadcast.
By the way, it is possible to exported by read time intuitively, timely for read time of staff is facilitated
Know.
Corresponding with said method, the embodiment of the present invention additionally provides the dress of a kind of real-time monitoring oracle monolithic read latency
Put, as in figure 2 it is shown, may include that
Reading event generation module 11, is used for producing reading event；
Monitoring module 12, monitors in real time for the single block read events currently produced reading event generation module, obtains
Complete this read time used by monolithic read time；
Output module 13, for exporting read time.
It should be noted that reading event generation module can be the script producing reading event being mentioned above.Concrete next
Saying, the said apparatus that the embodiment of the present invention provides can also include data base, and in data base, storage has for reading event generation module
Read data, and monitor obtain read time can be specifically by monitoring reading event, by reading event by the mistake terminated
Journey obtains with the form of code, and then carries out this code changing to obtain corresponding reading event.
The device of a kind of real-time monitoring oracle monolithic read latency that the embodiment of the present invention provides, it is also possible to including:
Judge module, is used for judging whether read time is more than Preset Time, if it is, output warning message.
The device of a kind of real-time monitoring oracle monolithic read latency that the embodiment of the present invention provides, it is judged that module can be wrapped
Include:
Alarm unit, sends to designated terminal for read time and Preset Time being carried in warning message.
The device of a kind of real-time monitoring oracle monolithic read latency that the embodiment of the present invention provides, output module can wrap
Include:
First output unit, for showing read time at corresponding display screen.
The device of a kind of real-time monitoring oracle monolithic read latency that the embodiment of the present invention provides, output module can wrap
Include:
Second output unit, for carrying out voice broadcast by read time.
The explanation of relevant portion in the device of a kind of real-time monitoring oracle monolithic read latency that the embodiment of the present invention provides
In the method for a kind of real-time monitoring oracle monolithic read latency referring to embodiment of the present invention offer, corresponding part is specifically
Bright, do not repeat them here.
Described above to the disclosed embodiments, makes those skilled in the art be capable of or uses the present invention.To this
The multiple amendment of a little embodiments will be apparent from for a person skilled in the art, and generic principles defined herein can
With without departing from the spirit or scope of the present invention, realize in other embodiments.Therefore, the present invention will not be limited
It is formed on the embodiments shown herein, and is to fit to consistent with principles disclosed herein and features of novelty the widest
Scope.
Claims (10)
1. the method for a real-time monitoring oracle monolithic read latency, it is characterised in that including:
The current single block read events produced is monitored in real time, has obtained this read time used by monolithic read time；
Described read time is exported.
Method the most according to claim 1, it is characterised in that also include:
Judge whether described read time is more than Preset Time, if it is, output warning message.
Method the most according to claim 2, it is characterised in that output warning message, including:
Described read time and described Preset Time are carried in described warning message and send to designated terminal.
Method the most according to claim 1, it is characterised in that described read time is exported, including:
Described read time is shown on corresponding display screen.
Method the most according to claim 1, it is characterised in that described read time is exported, including:
Described read time is carried out voice broadcast.
6. the device of a real-time monitoring oracle monolithic read latency, it is characterised in that including:
Reading event generation module, is used for producing reading event；
Monitoring module, monitors in real time for the single block read events currently produced described reading event generation module, has obtained
Become this read time used by monolithic read time；
Output module, for exporting described read time.
Device the most according to claim 6, it is characterised in that also include:
Judge module, is used for judging whether described read time is more than Preset Time, if it is, output warning message.
Device the most according to claim 7, it is characterised in that described judge module includes:
Alarm unit, sends to specifying end for described read time and described Preset Time being carried in described warning message
End.
Device the most according to claim 6, it is characterised in that described output module includes:
First output unit, for showing described read time at corresponding display screen.
Device the most according to claim 6, it is characterised in that described output module includes:
Second output unit, for carrying out voice broadcast by described read time.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610516165.3A CN106126409B (en) | 2016-07-01 | 2016-07-01 | A kind of method and device monitoring oracle monolithic read latency in real time |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610516165.3A CN106126409B (en) | 2016-07-01 | 2016-07-01 | A kind of method and device monitoring oracle monolithic read latency in real time |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106126409A true CN106126409A (en) | 2016-11-16 |
| CN106126409B CN106126409B (en) | 2018-11-23 |
Family
ID=57469226
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610516165.3A Active CN106126409B (en) | 2016-07-01 | 2016-07-01 | A kind of method and device monitoring oracle monolithic read latency in real time |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106126409B (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6957211B1 (en) * | 2002-05-06 | 2005-10-18 | Oracle International Corporation | Query optimizer cost model |
| US7296070B2 (en) * | 2000-12-22 | 2007-11-13 | Tier-3 Pty. Ltd. | Integrated monitoring system |
| CN103186603A (en) * | 2011-12-29 | 2013-07-03 | 中国移动通信集团浙江有限公司 | Method, system and equipment for determining influence of SQL statements on performance of key businesses |
| JP2014096145A (en) * | 2012-10-22 | 2014-05-22 | Boeing Co | Real time control system management |
| CN104834634A (en) * | 2014-02-07 | 2015-08-12 | 西门子公司 | Regression-based cost modeling method and device for predicting SQL statement performance |
| CN105681402A (en) * | 2015-11-25 | 2016-06-15 | 北京文云易迅科技有限公司 | Distributed high speed database integration system based on PCIe flash memory card |
-
2016
- 2016-07-01 CN CN201610516165.3A patent/CN106126409B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7296070B2 (en) * | 2000-12-22 | 2007-11-13 | Tier-3 Pty. Ltd. | Integrated monitoring system |
| US6957211B1 (en) * | 2002-05-06 | 2005-10-18 | Oracle International Corporation | Query optimizer cost model |
| CN103186603A (en) * | 2011-12-29 | 2013-07-03 | 中国移动通信集团浙江有限公司 | Method, system and equipment for determining influence of SQL statements on performance of key businesses |
| JP2014096145A (en) * | 2012-10-22 | 2014-05-22 | Boeing Co | Real time control system management |
| CN104834634A (en) * | 2014-02-07 | 2015-08-12 | 西门子公司 | Regression-based cost modeling method and device for predicting SQL statement performance |
| CN105681402A (en) * | 2015-11-25 | 2016-06-15 | 北京文云易迅科技有限公司 | Distributed high speed database integration system based on PCIe flash memory card |
Non-Patent Citations (3)
| Title |
|---|
| CZMMIAO: ""Oracle数据库性能模型"", 《HTTP://CZMMIAO.ITEYE.COM/BLOG/1544114》 * |
| JONATHAN LEWIS: ""Single block reads"", 《HTTPS://JONATHANLEWIS.WORDPRESS.COM/2014/01/14/SINGLE-BLOCK-READS/》 * |
| 姚曼曼: ""实时监视数据库性能（二）监视实例活动"", 《HTTP://BLOG.SINA.COM.CN/S/BLOG_B43F755B0101GPWU.HTML》 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106126409B (en) | 2018-11-23 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103533084B (en) | Real-time DMS (device management system) of B/S (browser/server) framework and method thereof | |
| CN102354296B (en) | A kind of monitoring system and method that can expanding monitoring resources | |
| CN207976875U (en) | A kind of monitoring system based on modular data center | |
| CN105224439A (en) | Method and device for detecting CPU occupancy rate of terminal APP and terminal | |
| CN104125085B (en) | A kind of data management-control method and device based on ESB | |
| CN104065526A (en) | Server fault alarming method and device thereof | |
| CN109556899A (en) | A kind of refrigerator detection method, industrial personal computer and refrigerator detection system | |
| CN105404224A (en) | Method and apparatus for processing machine room fault | |
| CN105847092A (en) | Method and device for monitoring website in real time | |
| CN102739842A (en) | System for monitoring health condition of mobile phone, and method thereof | |
| CN102201927A (en) | Alarm information processing method and device | |
| CN109284193A (en) | A kind of distributed data processing method and server based on multithreading | |
| CN106126409A (en) | A kind of method and device of real-time monitoring oracle monolithic read latency | |
| TWI702157B (en) | Charging device for electric vehicles, automatic troubleshooting method and computer program product | |
| CN116980958A (en) | Radio equipment electric fault monitoring method and system based on data identification | |
| CN104680423A (en) | Electricity charge abnormity detection system and method | |
| CN213780745U (en) | Automobile fault diagnosis system based on CAN bus | |
| CN110633165B (en) | Fault processing method, device, system server and computer readable storage medium | |
| CN112508268A (en) | Intelligent management, diagnosis and early warning system for factory equipment | |
| CN112614324A (en) | Method for realizing energy consumption platform | |
| CN103220187A (en) | Method and device for detecting state of three-layer port | |
| CN105574055A (en) | Method and apparatus for preventing memory from being exhausted | |
| CN114844800B (en) | Abnormality detection method and device for equipment, readable storage medium and electronic equipment | |
| CN203929839U (en) | Anti-infrared telepilot electricity filching device, intelligent electric meter system | |
| CN102064952B (en) | Large-scale equipment link management method and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |