CN106201826B - A method of the big affairs of diagnosis oracle database and hot spot affairs - Google Patents
A method of the big affairs of diagnosis oracle database and hot spot affairs Download PDFInfo
- Publication number
- CN106201826B CN106201826B CN201610551752.6A CN201610551752A CN106201826B CN 106201826 B CN106201826 B CN 106201826B CN 201610551752 A CN201610551752 A CN 201610551752A CN 106201826 B CN106201826 B CN 106201826B
- Authority
- CN
- China
- Prior art keywords
- affairs
- big
- transaction
- module
- hot spot
- 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.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/3003—Monitoring arrangements specially adapted to the computing system or computing system component being monitored
- G06F11/302—Monitoring arrangements specially adapted to the computing system or computing system component being monitored where the computing system component is a software system
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/3065—Monitoring arrangements determined by the means or processing involved in reporting the monitored data
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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/3452—Performance evaluation by statistical analysis
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
- G06F2201/87—Monitoring of transactions
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Quality & Reliability (AREA)
- Data Mining & Analysis (AREA)
- Computing Systems (AREA)
- Mathematical Physics (AREA)
- Life Sciences & Earth Sciences (AREA)
- Bioinformatics & Cheminformatics (AREA)
- Bioinformatics & Computational Biology (AREA)
- Evolutionary Biology (AREA)
- Probability & Statistics with Applications (AREA)
- Computer Hardware Design (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Debugging And Monitoring (AREA)
Abstract
A method of the big affairs of diagnosis oracle database and hot spot affairs, in oracle database application system operational process, by by systematic difference program and database business associates, associated application layer and database layer, and it is equipped with the runing time and the operation frequency of the monitor mode monitoring affairs of automation, for the affairs for reaching threshold value standard, precise positioning starts the application program of big affairs and hot spot affairs, specially：1）Application module mark and oracle database Transaction Identifier are configured, transaction threshold is set；2）The worker thread or process on log-on data library application system backstage；3）Proprietary database connection pool module is initialized, the connection of application layer and database layer is established；4）Affairs sampling obtains to sampling thread cycle the affairs time-consuming information of Transaction Identifier from the view of database application system.
Description
Technical field
The invention belongs to database technical fields, especially Database Systems monitoring technology, and in particular to a kind of diagnosis
The method of oracle database big affairs and hot spot affairs
Background technique
Db transaction (Database Transaction) refers to as a series of of single logical unit of work execution
It operates or is completely executed or do not execute fully.Issued transaction may insure except all behaviour in non-transactional unit
It all successfully completes, otherwise will not permanently update the resource of data-oriented.Affairs are the running logic workings of database
Unit, by the processing of the transaction management subsystem responsible affairs in DBMS.
Big affairs are referred to as in the affairs that database operation takes long time, in the database the frequent affairs system of number of run
Referred to as hot spot affairs, either big affairs or hot spot affairs, their operation can long-time occupying system resources, such as CPU, interior
It deposits, data dictionary, journal file etc., leads to the long-play affairs for causing a new round because blocking other affairs, cause thing
The concurrency of business reduces, and seriously affects database overall performance.Big affairs thus are effectively monitored, and notify data depositary management at once
Reason personnel make specific aim corrective measure, to " significantly shortening the execution time of big affairs, improve big affairs execution efficiency and money
Source operational efficiency " has great help.
Furthermore when monitoring affairs using traditional monitoring means, recognizing big affairs or hot spot affairs generally can only be from number
SQL is obtained according to the monitoring of library level, but can not accurately obtain the application module source for starting the affairs, this is Accurate Diagnosis thing
Business problem increases difficulty.
Summary of the invention
For above-mentioned technical deficiency, object of the present invention is to, provide a kind of big affairs of diagnosis oracle database and
The method of hot spot affairs, in system operation, by the way that systematic difference program module and db transaction are established connection,
Associated application layer and database layer, and it is equipped with the runing time and the operation frequency of the monitor mode monitoring affairs of automation, for
The affairs for reaching threshold value standard, being associated with based on established affairs and application program module, precise positioning start big affairs and
The application program of hot spot affairs, notes abnormalities in time convenient for data base administrator；For the affairs and hot spot thing identified
Business, the present invention are provided customized control logic, are easy to be controlled formulation major issue using machine automated manner or manpower intervention mode
Business,
A method of the big affairs of diagnosis oracle database and hot spot affairs, technical solution are as follows：
Step 1：Application module mark and oracle database Transaction Identifier are configured, transaction threshold is set；It is specially each
A application program module distribution can uniquely indicate the mark of application program module, i.e. application module identifies；For each database
Affairs distribute the mark that can uniquely identify the affairs, i.e. Transaction Identifier；Big affairs are set according to affairs practical operating experiences simultaneously
Threshold value and hot spot transaction threshold；
Step 2：The worker thread or process on log-on data library application system backstage；Worker thread or process include：Sampling
Thread or process, screening thread or process, alarm thread or process；
Particularly, the sampling thread/process, screening thread/process and alarm thread/process, each thread or into
Journey can be integrated into the functional module for having identity function, and all functional modules are formed with the database connection pool set in step 3
The Diagnosis Monitoring System of Diagnosis Monitoring System, the formation can be disposed independently of outside database, and regular visit database obtains prison
Control information；
Particularly, for the Diagnosis Monitoring System energy separate configurations of the formation in disposing outside database, system can be regularly
Database is accessed, monitoring information is obtained, implements real-time diagnosis；
Step 3：Proprietary database connection pool module is initialized, the connection of application layer and database layer is established：Work as application
When program is run, the db transaction got from database is associated with application program, i.e. application module by database connection pool
Mark is corresponded to be identified in relevant db transaction, and application program passes through application to database transmitting application module mark
Module id is associated with corresponding db transaction, and database connection is obtained from proprietary database connection pool, establishes application
Program and db transaction contact, and guarantee application program module before executing specific SQL statement, and band association can be called to answer automatically
With the Oracle storing process of module id；
Step 4：Affairs sampling：Sampling thread cycle affairs are obtained from the view of oracle database application system
The affairs time-consuming information of mark records sampling time point when sampling each time, stores the basic letter in relation to collected affairs
Breath, including Transaction Identifier, affairs operating status, transaction start time, associated application module, the movement of execution and other
It can be used to describe the relevant information of operation affairs；In all relevant information deposit affairs capture lists for getting affairs；
Primary sampling terminates, each transaction journal in traversal affairs capture list, according to Transaction Identifier and application module
Mark searches record in big affairs tracking table and hot spot affairs tracking table, and does corresponding data processing；Specific processing step
It is as follows：
Step 4-1：According to Transaction Identifier, if the affairs currently traversed in affairs capture list are in big affairs tracking table
In it is existing, then update the affairs runing time in big affairs tracking table；If the thing currently traversed in affairs capture list
Business is not present in big affairs tracking table, is inserted into a record about the affairs, newly adds affairs runing time, and affairs run shape
State is denoted as " in operation "；
Particularly, the update and the affairs runing time newly added are the difference at present sample time point and transaction start time
Value；
Step 4-2：It inquired in big affairs tracking table, extract the transaction journal that transaction status is " in operation ", concentration is deposited
It stores up these transaction journals to enter in interim table, every record in the traversal interim table obtains application module mark and affairs mark
Know, identified according to the Transaction Identifier and application module obtained from interim table, the affairs traversed described in inquiry are captured in affairs
It whether there is in list；
If it does not exist, illustrate that the affairs have currently been finished, execute the monitoring terminated to the affairs, update the affairs
Transaction status of the Transaction Identifier in big affairs tracking table be " end of run "；If it exists, without any processing；
Particularly, wait traverse all transaction journals in interim table, interim table is emptied；
Step 4-3：Application module mark in list is captured according to affairs, if the application module being currently running can be in warm
It is inquired in point affairs tracking table, updates the execution frequency of affairs corresponding to the application module in hot spot affairs tracking table, it is described
Updated affairs execute the affairs before the frequency=update and execute the frequency+1；If the application program being currently running is in hot spot thing
Be engaged in tracking table in inquiry less than, then be inserted into new record, be arranged affairs corresponding to the application module the execution frequency be 1；
Particularly, above-mentioned update or insertion operation are only performed once to the same transaction guarantee；
Step 5：Screen big affairs and hot spot affairs, the application module of positioning starting affairs operation；It is big to screen thread traverses
Affairs tracking table and hot spot affairs tracking table, for all transaction journals of (1) big affairs tracking table；(2) hot spot affairs tracking table
In all transaction journals screened, according to step 1 set big transaction threshold and hot spot transaction threshold, judge the thing traversed
Whether business reaches threshold value standard, for the affairs reached on standard, executes following steps：
Step 5-1：In big affairs tracking table, the affairs traversed meet：Affairs runing time>Big transaction threshold mark
Standard extracts following information from big affairs tracking table：
(1) Transaction Identifier；
(2) it is identified with the associated application module of affairs；
(3) affairs runing time；
(4) big affairs level threshold value；
Step 5-2：In hot spot affairs tracking table, the affairs traversed meet：Affairs run the frequency>Hot spot transaction threshold
Standard extracts the relevant information of big affairs from hot spot affairs tracking table and big affairs tracking table, includes：
(1) Transaction Identifier
(2) it is identified with the associated application module of affairs；
(3) affairs run the frequency；
(4) hot spot affairs level threshold value；
Step 6：Starting alarm thread by raw alarm information, meet the db transaction information of threshold value standard and corresponding
The combination association of application module information, forms the alarm content for being easy to be read and understood, and use immediate communication tool and electronics
The communication modes such as mail, the big affairs that will be seen that in time and hot spot transaction report give corresponding data base administrator；
Step 7：Summarize the big affairs and hot spot transaction information in a certain particular time range, through data processing, formed with
The statistical report form that visual pattern, which shows that something terrible happens, is engaged in hot spot affairs operation overall picture and details.
Big transaction threshold is using db transaction runing time in system operation as standard；Hot spot transaction threshold is then
Using the operation frequency of each affairs involved in application program module as standard；
Threshold value configuration mode is to customize different threshold values according to the requirement of different application module；For different application modules,
Different threshold values is respectively set；It, should when the corresponding affairs of only each application module reach the big transaction threshold of specified application module
Affairs can just be judged as big affairs.
UserClient.Message.Send and UserClient.Inquiry.Receive module, is respectively set difference
Threshold value：The big transaction threshold of module UserClient.Inquiry.Receive is set as 600 milliseconds, then as v session
When middle module id is that the affairs time-consuming of UserClient.Message.Receive reaches 900 milliseconds, then major issue is judged as
Business；And when the affairs time-consuming that module id is UserClient.Message.Send in v $ session reaches 900 milliseconds, then
Big affairs will not be judged as, because the big transaction threshold standard of affairs UserClient.Message.Send is 1000 milliseconds.
Compared with prior art, the present invention its advantages：
(1) present invention by the way that application module is associated with db transaction, establish between application layer and data Layer by realization
Relevance, guarantee db transaction occur runing time it is too long or operation the frequency it is excessively frequent when, notify data base administration at once
Personnel effectively help them quickly to position the source of abnormal transaction, quickly solve to cause because of the big affairs of database or hot spot affairs
Oracle database operation it is slow or the problem of hang up, in time and accurately discovery leads to the application program of affairs exception, efficiently
Improve the diagnosis efficiency of big affairs and hot spot affairs in ground；
(2) present invention distributes unique identification for the application program module and affairs of each operation, can be according to different application
The practical operating experiences given threshold of module, using as the foundation for judging big affairs or hot spot affairs；By applying journey each
The operation conditions that associated affairs are periodically monitored during sort run, is realized to affairs big in oracle database and hot spot thing
The automatically-monitored and alarm of business, and energy connected applications system long-term monitoring data, it is excellent convenient for cooperation SQL optimization and application flow
Change and threshold value is adjusted flexibly.
Detailed description of the invention
Fig. 1 is the functional block diagram of the Diagnosis Monitoring System constructed in this embodiment of the present invention；
Fig. 2 is a kind of method implementing procedure for diagnosing oracle database big affairs and hot spot affairs in the embodiment of the present invention
Figure；
Fig. 3 is the flow diagram of big affairs and the sampling of hot spot affairs and diagnosis in the embodiment of the present invention；
Fig. 4 is mail alarm schematic diagram when diagnosing big affairs and hot spot affairs in the embodiment of the present invention；
Fig. 5 is SMS alarm schematic diagram when diagnosing big affairs and hot spot affairs in the embodiment of the present invention.
Specific embodiment
To make the objectives, technical solutions, and advantages of the present invention clearer, below in conjunction with specific embodiment, and reference
Attached drawing, the present invention is described in more detail.
The present invention is in application system operational process, by by each application program module and db transaction of system
Connection is established application layer with database layer and is associated with, and is equipped with the runing time and fortune of the monitor mode monitoring affairs of automation
Line frequency time, for the affairs for reaching threshold value standard, contacting based on established affairs and application program module, precise positioning is opened
The application program for moving big affairs and hot spot affairs facilitates data base administrator to be found in time using abnormal and then targeted
Implement SQL optimization and application flow optimization in ground.The present invention can control monitoring logic in a manner of customized, and scalability is strong, convenient
The affairs that the automatic or manual intervention control setting of machine needs to monitor.
Key step is as follows, step 1：Application module mark and database Transaction Identifier are configured, transaction threshold is set；Specifically
For：The mark of application program module can be uniquely indicated for the distribution of each application program module, i.e. application module identifies；It is each
A db transaction distribution can uniquely identify the mark of the affairs, i.e. Transaction Identifier；It is set simultaneously according to affairs practical operating experiences
Set big transaction threshold and hot spot transaction threshold；
Step 2：Start the worker thread or process on backstage；Worker thread or process include：Sample thread/process, screening
Thread/process, alarm thread/process；
Sampling thread/the process：For periodic access database, running db transaction is acquired；The sieve
Route selection journey/process：Judge whether the db transaction in monitoring is big affairs and hot spot thing for the threshold value standard according to setting
Business；According to the Transaction Identifier for being judged as big affairs and hot spot affairs, the application program of positioning associated；The alarm thread/into
Journey：For extracting the relevant information for being judged as big affairs and hot spot affairs and associated application module identification information, according to upper
The warning message for stating information preparation easy-to-read is informed matched in advance in time by communication modes such as short message, wechat and Emails
The data base administrator set；
Step 3：Proprietary database connection pool is initialized, application module obtains and number from proprietary database connection pool
According to the connection in library, by establishing the connection of application layer and database layer, application program module is executing specific database SQL language
Before sentence, the Oracle storing process with associated application module id can be called automatically；
The database connection pool, one is db transaction for identification, the second is for constructing answering for application system
With the connection between program and db transaction, it is managed collectively the resources such as CPU, database, the broadband expended by connection；
Step 4：Thread is sampled according to the period of setting, regularly Accessing Oracle Database, is obtained from Oracle view
Affairs time-consuming information is taken, when sampling each time, sampling time point is recorded, stores the essential information in relation to collected affairs,
Including Transaction Identifier, affairs operating status, transaction start time, associated application module, the movement of execution and other energy
For describing the relevant information of operation affairs；In all relevant information deposit affairs capture lists for getting affairs；
Each transaction journal in affairs capture list is traversed, is identified according to Transaction Identifier and application module, in big affairs
Record is searched in tracking table and hot spot affairs tracking table, and does corresponding data processing；
Step 5：The big affairs tracking table of the screening thread traverses of starting and hot spot affairs tracking table, for the institute in two tables
There is transaction journal, according to big transaction threshold and hot spot transaction threshold that step 1 is set, judges whether the affairs traversed reach threshold
Value standard obtains the application module source for starting big affairs and hot spot affairs；
Step 6：Alarm thread by raw alarm information, meet the db transaction information and corresponding application of threshold value standard
Module information combination association, forms the alarm content for being easy to be read and understood, and use immediate communication tool and Email
Equal communication modes, the big affairs that will be seen that in time and hot spot transaction report give corresponding data base administrator；
Step 7：Alarm thread summarizes big affairs and hot spot transaction information in a certain particular time range, at data
Reason is formed with visual pattern displaying overall picture and detailed statistical report form that something terrible happens is engaged in the operation of hot spot affairs, including：
(1) it clusters：Classified according to affairs runing time to the big affairs identified, analysis belongs to different affairs operations
The big transactions of time grade；It runs the frequency according to affairs to classify to the big affairs identified, analysis, which belongs to, does not work together
The hot spot transactions ratio of business operation frequency grade；
(2) the big affairs relational graph of application module-：For the big affairs that each application program module is associated with, major issue is drawn
Business distribution proportion figure；
(3) application module-hot spot transactional relationship figure：For the hot spot affairs that each application program module management is arrived, draw
Hot spot affairs distribution proportion figure；
(4) big affairs trend chart is drawn：As desired, the big affairs paid close attention to are extracted to be pressed according to runing time
Variation tendency is drawn according to the period (when, day, the moon etc.)；
(5) hot spot affairs variation tendency is drawn：As desired, the hot spot affairs paid close attention to are extracted, according to operation the frequency,
Variation tendency is drawn according to the period (when, day, the moon etc.)；
Fig. 1 is the functional block diagram of the monitoring system constructed in the embodiment of the present invention, and monitoring configuration is outside database
Portion, periodic access database obtain affairs and run message, and the monitoring system includes：Database connection pool module, configuration mould
Block, affairs monitoring module, control module, alarm module；
The database connection pool module 101 db transaction for identification constructs systematic difference module and database
Between connection, be managed collectively the resources such as CPU, database, broadband for expending by connection；Application module is from proprietary database
Data connection is obtained in connection pool, it is automatic to call oracle database storing process before executing SQL, and transmitted to database
Application module mark；The configuration module 102：Standard value for given threshold；
Affairs monitoring module, control module, alarm module include to sampling thread/process, screening thread/process and alarm
The control of thread/process becomes above-mentioned functional module, all functional modules and the data to each thread or process sets
Library connection pool set forms Diagnosis Monitoring System.
In embodiments of the present invention, big transaction threshold is using db transaction runing time in system operation as mark
It is quasi-；Hot spot transaction threshold is then using the operation frequency of each affairs involved in application program module as standard；
Threshold value configuration mode in the embodiment of the present invention is divided into two kinds：
One is unified configuration.For example, being 1000 millis to all affairs setting uniform threshold (big_session_time)
Second, then when detecting in oracle database that having affairs SQL to execute the time is more than 1000 milliseconds, regardless of executing the affairs
Which application module SQL belongs to, and is judged as big affairs.
The second is customizing different threshold values according to the requirement of different application module.Such as
Different threshold values is respectively set, such as in UserClient.Message.Send and UserClient.Inquiry.Receive module
Shown in table 1：Since the big transaction threshold of module UserClient.Inquiry.Receive is set as 600 milliseconds, then work as v
When the affairs time-consuming that module id is UserClient.Message.Receive in session reaches 900 milliseconds, then it is judged
For big affairs；And when the affairs time-consuming that module id is UserClient.Message.Send in v $ session reaches 900 millis
When the second, then big affairs will not be judged as, because the big transaction threshold standard of affairs UserClient.Message.Send is
1000 milliseconds.
Table 1：Transaction threshold allocation list
The affairs monitoring module 103：For the case where periodically acquisition and garbled data library affairs are run；The present invention is real
The affairs monitoring module applied in example is made of sampling thread and screening thread；
Particularly, the sampling thread cycle automatically inquires data base view, and obtains from Oracle view
The transaction information that oracle database is currently running specifically includes Transaction Identifier, application module mark, affairs runing time, thing
Business operating status, affairs execute frequency and other can be used for describing information of affairs operation conditions etc.；
The control module 104：For executing configured alarm stream for the big affairs and hot spot affairs identified
Journey and monitoring process；The configured monitoring process summarizes big affairs and hot spot transaction information within the scope of certain time,
It is handled through data mart modeling, forms visual statistical report form；The configured alarm flow, according to big affairs and hot spot affairs
Mark, extract associated application module mark and relevant information of affairs operating condition etc.；
The alarm module 105：Information for being extracted according to control module, establishment can easy-to-read alarm signal
Breath, by communication modes such as short message, wechat and Emails, informs preconfigured data base administrator in time；
Based on the big affairs and hot spot affairs monitoring system constructed in Fig. 1, a kind of diagnosis Oracle in the embodiment of the present invention
The method implementation process of the big affairs of database and hot spot affairs specifically comprises the following steps, sees Fig. 2.
Step 201：Application module mark and database Transaction Identifier are configured, transaction threshold is set；Specially：Pass through monitoring
The configuration module 102 of system can uniquely indicate the mark of application program, i.e. application module mark for each application assigned
Know, is defined as Module；The mark of the affairs, i.e. Transaction Identifier, definition can be uniquely identified for the distribution of each db transaction
For big_session_time；Big transaction threshold and hot spot transaction threshold are set simultaneously, are defined as hot_session_num；
Step 202：Start sampling thread, the screening thread in the affairs monitoring module 103 of monitoring system, and control mould
Block 104 and alarm module 105, monitoring system start to capture and screen affairs operation information；
Step 203：Each application program in operating status is passed into database connection pool module 101 in application system
Respective application module mark Module is passed, application module is associated with corresponding database thing by database connection pool module 101
Business, i.e. application module mark Module are corresponded to be identified in db transaction, and the Transaction Identifier is denoted as XID, and the present invention is real
It applies and takes affairs ID as Transaction Identifier in example, application program is completed to obtain from database connection pool module 101 and database
Connection；
Particularly, by establishing the continuous of application layer and database layer, application program module is executing specific database
Before SQL statement, the Oracle storing process with associated application module id can be called automatically；
Step 204：Sampling thread in the affairs monitoring module 103 of monitoring system is according to the customized period, from V $
The relevant information of affairs in operating status is obtained in SESSION and V $ TRANSACTION view；Between adjacent double sampling
Interval_time is denoted as every the phase；It is every execute the sampling of transaction information, current point in time is recorded, successively executes that " affairs are deposited
Storage-affairs judgement-affairs operation information update ", is detailed in Fig. 3, specially：
Step 204-1：In embodiments of the present invention, configuration interval_time is 500 milliseconds, samples thread every 500
Millisecond executes the acquisition of a transaction information, sampling time point current_time is recorded, from V SESSION and V
Collected affairs are recorded into affairs capture list according to affairs ID number in TRANSACTION view, which is denoted as
Capture_List；
In the affairs capture list Capture_List record sampling thread every time it is collected be currently running in thing
Business, the transaction information of record include：
(1) Transaction Identifier XID：That is db transaction ID；
(2) transaction start time Start_Date：For the affairs captured, when by taking transaction start time and sampling
Between difference, obtain affairs runing time Count_seesion_time；
(3) session start time Logon_Time；
(4) associated application module identifies Module；
(5) name Action is acted；
(6) the client-side information Client_Info of application system；
(7) transaction address identifies Taddr：For being associated with the record of V $ transaction in V $ session；
(8) session address identifies Ses_Addr：For being associated with the record of V $ session in V $ transaction；
Particularly, affairs capture list is the interim table generated in sampling process, to big affairs and hot spot affairs diagnosis knot
Shu Hou, affairs capture list empty；
In the sampling process of the embodiment of the present invention, sampling thread captures two affairs being in operating status：
3.12.62278 and 3.13.38005；
Step 204-2：It traverses affairs and captures list Capture_List, according to what is traversed in current Capture_List
Affairs ID, the record that the affairs are inquired in big affairs tracking table whether there is；
The relevant information of a certain affairs operation is recorded in the big affairs tracking table, including Transaction Identifier XID, affairs have been transported
Row time cumulation Count_session_time, affairs operating status Status, application program associated with the affairs
Module and other can be used for describing the information etc. of affairs operation conditions；
Step 204-3：If the record of Current transaction is not present in big affairs tracking table, a record, Gount_ are increased newly
Session_time=current_time-Start_Date, Status are " in operation ", " Running " are denoted as, from database
The mark of application program module associated with the affairs is obtained in connection pool module；If in big affairs tracking table, there are current things
The record of business updates Count_session_time value according to following formula：
Count_session_time=current_time-Start_Date
Certain in the embodiment of the present invention once sampling before big transaction list it is as shown in table 2, affairs " 3.12.62278 " with " answer
It is associated with program UserClient.Order.Create ", 6000 milliseconds are run, transaction status is in operation；Affairs
" 3.13.38005 " there is no in big affairs tracking table；
Table 2：Big affairs tracking table before certain primary sampling
After transaction information sampling of experience, big affairs tracking table is as shown in table 3, as can be seen from the table, affairs
" 3.12.62278 ", got from database connection pool it is associated with application program " UserClient.Order.Create ", should
The Count_session_time of affairs is updated to 6500, Status Running；Newly-increased affairs " 3.13.38005 ", from number
Get that the affairs are associated with " application program UserClient.History.List ", and the affairs are twice according to library connection pool
It brings into operation in the interval of neighbouring sample, the Count_session_time of affairs is 300, Status Running；
Table 3：Big affairs tracking table after sampling
Step 204-4：Inquiring and extracting all operating statuses in big affairs tracking table is that the transaction journal of " Running " enters
In table Last_Running_list；
Step 204-5：Every transaction journal in Last_Running_list is traversed, the affairs mark for traversing affairs is extracted
Know and application module identifies, inquires and whether there is in table Capture_List according to Transaction Identifier and application module mark；
Step 204-6：If the affairs traversed in table Last_Running_list are not present in table Capture_List,
Illustrate that the affairs are over execution, updating transaction status of the affairs in big affairs tracking table is " end of run ", is denoted as
" End ", monitoring system stop the monitoring and diagnosis to the affairs；
According to examples detailed above, have in the table Last_Running_list of the embodiment of the present invention affairs " 3.13.37982 ",
" 3.13.37997 ", " 3.12.62278 " and " 3.13.38005 ", the thing through traversal queries, in table Last_Running_list
Business " 3.13.37982 " and affairs " 3.13.37997 " are not present in table Capture_List, according to table Last_Running_
" XID " and " Module " in list finds this two transaction journals in big affairs tracking table, updates transaction status and is
" End ", monitoring system stop application modules UserClient.Message.Send and
The monitoring of UserClient.Inquiry.Receive, see the table below；
The updated big affairs tracking table table of table 4
Step 204-7：Module, inquiry hot spot affairs tracking are identified according to the application module recorded in Capture_List
Whether the record of the application module is had in table；
The information of the frequency of related affairs operation is recorded in the hot spot affairs tracking table, including is answered with affairs to associated
The accumulative frequency is executed with module Module, affairs；Such as following table institute in hot spot affairs tracking table before being sampled in the embodiment of the present invention
Show；Wherein
Table 5：Hot spot affairs tracking table before certain primary sampling
Step 204-8：If the application module mark of inquiry is not present in hot spot affairs tracking table, it is inserted into new record, thing
Business executes accumulative frequency Count_session_num and is set as 1；If the application module mark of inquiry is present in hot spot affairs tracking table
In, the affairs updated according to the following formula execute accumulative frequency Count_session_num；
Count_session_num+1 before Count_session_unm=updates
Table 6：Updated hot spot affairs tracking table
Step 205：The screening thread of affairs monitoring module 103 starts work, and traversal updates the big affairs tracking after statistics
Table 4 and hot spot affairs tracking table 6 judge the thing traversed based on big transaction threshold and hot spot transaction threshold that step 201 is set
Whether business reaches threshold value standard, specifically includes：
(1) in the table of the embodiment of the present invention 4, affairs " 3.13.37982 " associated application program is
" UserClient.Message.Send ", affairs " 3.13.37997 " associated application program are
" UserClient.Message.Send ", according to the threshold value standard of table 1, the runing time of affairs " 3.13.37982 " is 1700,
Greater than standard value 1000；The runing time of affairs " 3.13.37997 " is " 2000 ", is greater than standard value 600, thus, affairs
" 3.13.37982 " and " 3.13.37997 " is big affairs；The operation of affairs " 3.12.62278 " and affairs " 3.13.38005 "
Time is respectively 6500 and 300, and according to the threshold value standard of table 1, the two affairs are not big affairs；
According to the mark for the big affairs having determined that, control module 104 extracts affairs from big affairs tracking table
The information of " 3.13.37982 " and " 3.13.37997 ", including 1. affairs corresponding application module mark, 2. affairs runing time,
And the 3. corresponding big affairs level threshold value of the affairs, such as table 7；
Table 7 obtains the relevant information of big affairs
| Big Transaction name | The application module source of big affairs | Affairs runing time | Threshold value standard |
| 3.13.37982 | UserClient.Message.Send | 1700 | 1000 |
| 3.13.37997 | UserClient.Inquiry.Receive | 2000 | 600 |
(2) in the hot spot affairs tracking table of the embodiment of the present invention, according to the threshold value standard of table 1, application program
" UserClient.Message.Send " is executed 127 times, is less than standard value 5000；Application program
" UserClient.Inquiry.Receive " executes 360088, is greater than standard value 10000；Application program
The operation frequency of UserClient.Order.Create and UserClient.History.List is less than standard value 80000；Root
According to the transaction journal in Capture_List, affairs associated with application program " UserClient.Inquiry.Receive "
It is " 3.13.37997 ", thus the affairs are hot spot affairs；The associated affairs of other application module are not hot spot affairs；
According to Transaction Identifier and the application module mark having determined that as hot spot affairs, control module 104 is tracked from big affairs
The information of affairs " 3.13.37997 " is extracted in table, including 1. affairs corresponding application module mark, 2. the affairs operation frequency, with
And the 3. corresponding hot spot affairs level threshold value big-seesion-num of the affairs, as shown in table 8；
The relevant information of the acquisition hot spot affairs of table 8
| Hot spot Transaction name | The application module source of hot spot affairs | Affairs runing time | Threshold value standard |
| 3.13.37997 | UserClient.Inquiry.Receive | 360088 | 10000 |
Step 206：The starting alarm thread of alarm module 105, the big affairs and hot spot thing got according to control module 104
Business relevant information works out big affairs and hot spot warning message, and passes through mail and wechat dual mode notification database administrator
Member, such as Fig. 4 and Fig. 5；
Step 207：The transaction information that alarm module 105 is got according to control module 104 summarizes a certain specific time model
Big affairs and hot spot transaction information in enclosing, through data processing, formation shows that something terrible happens with visual pattern and is engaged in and hot spot affairs
The overall picture of operation and detailed statistical report form, including：
(1) it clusters：Classified according to affairs runing time to the big affairs identified, analysis belongs to different affairs operations
The big transactions of time grade；It runs the frequency according to affairs to classify to the big affairs identified, analysis, which belongs to, does not work together
The hot spot transactions ratio of business operation frequency grade
(2) the big affairs relational graph of application module-：For the big affairs that each application program module is associated with, major issue is drawn
Business distribution proportion figure；
(3) application module-hot spot transactional relationship figure：For the hot spot affairs that each application program module management is arrived, draw
Hot spot affairs distribution proportion figure；
(4) big affairs trend chart is drawn：As desired, the big affairs paid close attention to are extracted to be pressed according to runing time
Variation tendency is drawn according to the period (when, day, the moon etc.)；
(5) hot spot affairs variation tendency is drawn：As desired, the hot spot affairs paid close attention to are extracted, according to operation the frequency,
Variation tendency is drawn according to the period (when, day, the moon etc.)；
Those of ordinary skills in the art should understand that：The above is only a specific embodiment of the present invention, and
It is not used in the limitation present invention, all within the spirits and principles of the present invention, any modification, equivalent substitution, improvement and etc. done,
It should be included within protection scope of the present invention.
Claims (7)
1. a kind of method for diagnosing oracle database big affairs and hot spot affairs, which is characterized in that answered in oracle database
With in system operation, by by systematic difference program and database business associates, associated application layer and database layer, and
The runing time and the operation frequency for being equipped with the monitor mode monitoring affairs of automation are based on for the affairs for reaching threshold value standard
Established affairs are associated with application program module, and precise positioning starts the application program of big affairs and hot spot affairs, diagnosis
The big affairs and hot spot affairs specific steps of oracle database application system operational process include：
Step 1：Application module mark and oracle database Transaction Identifier are configured, transaction threshold is set；Specially each is answered
The mark of application program module can be uniquely indicated with program module distribution, i.e. application module identifies；For each db transaction
Distribution can uniquely identify the mark of the affairs, i.e. Transaction Identifier；Big transaction threshold is set according to affairs practical operating experiences simultaneously
And hot spot transaction threshold；
Step 2：The worker thread or process on log-on data library application system backstage；Worker thread or process include：Sample thread
Or process, screening thread or process, alarm thread or process；
Sampling thread/the process, screening thread/process and alarm thread/process, each thread or process can be integrated into tool
The functional module of standby identity function, all functional modules form Diagnosis Monitoring System with the database connection pool set in step 3,
The Diagnosis Monitoring System of the formation can be disposed independently of outside database, and regular visit database obtains monitoring information；
For the Diagnosis Monitoring System energy separate configurations of the formation in disposing outside database, system can regularly access database,
Monitoring information is obtained, real-time diagnosis is implemented；
Step 3：Proprietary database connection pool module is initialized, the connection of application layer and database layer is established：Work as application program
When operation, the db transaction got from database is associated with application program by database connection pool, i.e. application module identifies
It corresponds and is identified in relevant db transaction, application program passes through application module to database transmitting application module mark
Mark is associated with corresponding db transaction, and database connection is obtained from proprietary database connection pool, establishes application program
With contacting for db transaction, guarantee application program module before executing specific SQL statement, band associated application mould can be called automatically
The Oracle storing process of block identification；
Step 4：Affairs sampling：Sampling thread cycle Transaction Identifier is obtained from the view of oracle database application system
Affairs time-consuming information, when sampling each time, record sampling time point, store the essential information in relation to collected affairs,
Including Transaction Identifier, affairs operating status, transaction start time, associated application module, execution movement relevant information；
In all relevant information deposit affairs capture lists for getting affairs；
Primary sampling terminates, and each transaction journal in traversal affairs capture list is identified according to Transaction Identifier and application module,
Record is searched in big affairs tracking table and hot spot affairs tracking table, and does corresponding data processing；Specific processing step is as follows：
Step 4-1：According to Transaction Identifier, if currently in affairs capture list the affairs that traverse in big affairs tracking table
In the presence of then updating the affairs runing time in big affairs tracking table；If the affairs currently traversed in affairs capture list exist
It is not present in big affairs tracking table, is inserted into a record about the affairs, newly add affairs runing time, affairs operating status note
For " in operation "；
The update and the affairs runing time newly added are the difference at present sample time point and transaction start time；
Step 4-2：In big affairs tracking table inquire, extract transaction status be " in operation " transaction journal, it is centrally stored this
A little transaction journals enter in interim table, and every record in the traversal interim table obtains application module mark and Transaction Identifier, root
According to Transaction Identifier and the application module mark obtained from interim table, the affairs traversed described in inquiry are in affairs capture list
It whether there is；
If it exists, without any processing；If it does not exist, illustrate that the affairs have currently been finished, executing terminates to the affairs
Monitoring, update transaction status of the Transaction Identifier of the affairs in big affairs tracking table be " end of run "；
Wait traverse all transaction journals in interim table, interim table is emptied；
Step 4-3：Application module mark in list is captured according to affairs, if the application module being currently running can be in hot spot thing
It is inquired in business tracking table, updates the execution frequency of affairs corresponding to the application module in hot spot affairs tracking table, the update
Affairs afterwards execute the affairs before the frequency=update and execute the frequency+1；If the application program being currently running hot spot affairs with
In track table inquiry less than, then be inserted into new record, be arranged affairs corresponding to the application module the execution frequency be 1；
Above-mentioned update or insertion operation are only performed once to the same transaction guarantee；
Step 5：Screen big affairs and hot spot affairs, the application module of positioning starting affairs operation；Screen the big affairs of thread traverses
Tracking table and hot spot affairs tracking table, for（1）All transaction journals of big affairs tracking table；（2）Institute in hot spot affairs tracking table
There is transaction journal to be screened, according to big transaction threshold and hot spot transaction threshold that step 1 is set, judges that the affairs traversed are
It is no to reach threshold value standard, for the affairs reached on standard, execute following steps：
Step 5-1：In big affairs tracking table, the affairs traversed meet：Affairs runing time>Big transaction threshold standard, from
Following information is extracted in big affairs tracking table：
（1）Transaction Identifier；
（2）It is identified with the associated application module of affairs；
（3）Affairs runing time；
（4）Big affairs level threshold value；
Step 5-2：In hot spot affairs tracking table, the affairs traversed meet：Affairs run the frequency>Hot spot transaction threshold mark
Standard extracts the relevant information of big affairs from hot spot affairs tracking table and big affairs tracking table, includes：
（1）Transaction Identifier
（2）It is identified with the associated application module of affairs；
（3）Affairs run the frequency；
（4）Hot spot affairs level threshold value；
Step 6：Starting alarm thread by raw alarm information, meet the db transaction information and corresponding application of threshold value standard
Module information combination association, forms the alarm content for being easy to be read and understood, and use immediate communication tool and Email
Communication modes, the big affairs that will be seen that in time and hot spot transaction report give corresponding data base administrator.
2. diagnosing the method for oracle database big affairs and hot spot affairs according to claim 1, which is characterized in that step
7：Alarm thread summarizes big affairs and hot spot transaction information in a certain particular time range, through data processing, is formed with visual
The overall picture and detailed statistical report form that change form, which shows that something terrible happens, is engaged in the operation of hot spot affairs, including：
（1）Cluster：Classified according to affairs runing time to the big affairs identified, analysis belongs to different affairs runing times
The big transactions of grade；It runs the frequency according to affairs to classify to the big affairs identified, analysis belongs to different affairs fortune
The hot spot transactions ratio of line frequency time grade；
（2）The big affairs relational graph of application module-：For the big affairs that each application program module is associated with, big affairs are drawn
Distribution proportion figure；
（3）Application module-hot spot transactional relationship figure：For the hot spot affairs that each application program module management is arrived, heat is drawn
Point affairs distribution proportion figure；
（4）Draw big affairs trend chart：As desired, the big affairs paid close attention to are extracted, according to runing time, according to when
Between section draw variation tendency；
（5）Draw hot spot affairs variation tendency：As desired, the hot spot affairs paid close attention to are extracted, according to operation the frequency, according to
Period draws variation tendency.
3. diagnosing the method for oracle database big affairs and hot spot affairs according to claim 1, which is characterized in that
The monitoring system includes：Database connection pool module, configuration module, affairs monitoring module, control module, alarm mould
Block；
Database connection pool module db transaction for identification constructs the company between systematic difference module and database
It connects, is managed collectively CPU, database, the broadband resource expended by connection；Application module is obtained from proprietary database connection pool
Data connection is taken, it is automatic to call oracle database storing process before executing SQL, and application module mark is transmitted to database
Know；The configuration module：Standard value for given threshold；
Affairs monitoring module, control module, alarm module include to sampling thread/process, screening thread/process and alarming line
The control of journey/process becomes functional module to each thread or process sets.
4. the method for diagnosis oracle database big affairs and hot spot affairs according to claim 3, which is characterized in that institute
The Diagnosis Monitoring System energy separate configurations to be formed are stated in disposing outside database, system can regularly access database, obtain prison
Information is controlled, real-time diagnosis is implemented.
5. the method for diagnosis oracle database big affairs and hot spot affairs according to claim 3, which is characterized in that big
Transaction threshold is using db transaction runing time in system operation as standard；Hot spot transaction threshold is then with application program
Each affairs operation frequency is standard involved in module；
Threshold value configuration mode point：Unified configuration, to the uniform threshold of all big affairs settings, then when detecting oracle database
In have affairs SQL execute the time be more than preset value when, regardless of execute the affairs SQL which application module belonged to, be determined
For big affairs.
6. the method for diagnosis oracle database big affairs and hot spot affairs according to claim 3, which is characterized in that big
Transaction threshold is using db transaction runing time in system operation as standard；Hot spot transaction threshold is then with application program
Each affairs operation frequency is standard involved in module；
Threshold value configuration mode is to customize different threshold values according to the requirement of different application module；For different application modules, respectively
Different threshold values is set；When the corresponding affairs of only each application module reach the big transaction threshold of specified application module, the affairs
Big affairs can be just judged as.
7. the method for diagnosis oracle database big affairs and hot spot affairs according to claim 6, which is characterized in that
Different threshold values is respectively set in UserClient.Message.Send and UserClient.Inquiry.Receive module：Mould
The big transaction threshold of block UserClient.Inquiry.Receive is set as 600 milliseconds, then when module id in v session
When reaching 900 milliseconds for the affairs time-consuming of UserClient.Message. Receive, then big affairs are judged as.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610551752.6A CN106201826B (en) | 2016-07-13 | 2016-07-13 | A method of the big affairs of diagnosis oracle database and hot spot affairs |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610551752.6A CN106201826B (en) | 2016-07-13 | 2016-07-13 | A method of the big affairs of diagnosis oracle database and hot spot affairs |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106201826A CN106201826A (en) | 2016-12-07 |
| CN106201826B true CN106201826B (en) | 2018-11-20 |
Family
ID=57477561
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610551752.6A Active CN106201826B (en) | 2016-07-13 | 2016-07-13 | A method of the big affairs of diagnosis oracle database and hot spot affairs |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106201826B (en) |
Families Citing this family (18)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| TWI739794B (en) * | 2017-01-23 | 2021-09-21 | 香港商阿里巴巴集團服務有限公司 | Data monitoring method and device |
| CN106934031B (en) * | 2017-03-14 | 2020-03-13 | 中国银行股份有限公司 | Method and device for monitoring and processing hotspot records in real-time processing system |
| CN108647128A (en) * | 2018-05-17 | 2018-10-12 | 重庆市通信建设有限公司 | Concurrent step sorting technique, device and electronic equipment |
| CN109508285B (en) * | 2018-07-31 | 2021-07-27 | 上海新炬网络信息技术股份有限公司 | Method for quickly positioning fault code through Oracle database and Weblogic middleware |
| CN109086149A (en) * | 2018-08-15 | 2018-12-25 | 国云科技股份有限公司 | Method for analyzing calling hot spot of micro-service interface |
| CN111400085B (en) * | 2020-02-18 | 2025-09-02 | 中国平安人寿保险股份有限公司 | Method, device, computer equipment and storage medium for handling transaction rollback exception |
| CN113868071A (en) * | 2020-06-30 | 2021-12-31 | 北京科益虹源光电技术有限公司 | Control method and device for environmental monitoring and alarming of excimer laser |
| CN114116658B (en) * | 2020-08-26 | 2025-09-23 | 白腊梅 | A transaction process presentation method and presentation device for a database |
| CN111988217B (en) | 2020-08-31 | 2022-09-23 | Oppo广东移动通信有限公司 | Data interaction method, device, electronic device and storage medium |
| CN112069202B (en) * | 2020-09-09 | 2024-11-29 | 上海携程商务有限公司 | SQL performance analysis method, system, equipment and medium based on tracking technology |
| CN112818049B (en) * | 2021-01-28 | 2024-04-16 | 中国人寿保险股份有限公司上海数据中心 | Information system performance full-link analysis system and method thereof |
| CN113010495B (en) * | 2021-03-19 | 2023-01-06 | 北京三快在线科技有限公司 | Database optimization method and device |
| CN113590633A (en) * | 2021-08-11 | 2021-11-02 | 中国建设银行股份有限公司 | Method and device for eliminating database read-write hot spots, storage medium and equipment |
| CN114461659B (en) * | 2022-02-28 | 2025-06-24 | 中国工商银行股份有限公司 | Killing method, device, computer equipment and storage medium |
| CN115017010A (en) * | 2022-06-15 | 2022-09-06 | 中国银行股份有限公司 | Method for determining active load of application module in bank system and related device |
| CN115114374B (en) * | 2022-06-27 | 2023-03-31 | 腾讯科技（深圳）有限公司 | Transaction execution method and device, computing equipment and storage medium |
| CN115422164A (en) * | 2022-09-14 | 2022-12-02 | 中国建设银行股份有限公司 | Large affair management method and device |
| CN117252309B (en) * | 2023-11-15 | 2024-02-13 | 青岛海信信息科技股份有限公司 | Automatic timing execution method for office business process |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7895247B2 (en) * | 2003-10-29 | 2011-02-22 | Oracle International Corporation | Tracking space usage in a database |
| US7403954B2 (en) * | 2005-09-30 | 2008-07-22 | Sap Ag | Systems and methods for repeatable database performance testing |
| JP2009110439A (en) * | 2007-10-31 | 2009-05-21 | Nec Corp | Database access system, database access method and program |
| CN103795811B (en) * | 2014-03-06 | 2015-05-06 | 焦点科技股份有限公司 | Information storage and data statistical management method based on meta data storage |
| CN105446827B (en) * | 2014-08-08 | 2018-12-14 | 阿里巴巴集团控股有限公司 | Date storage method and equipment when a kind of database failure |
-
2016
- 2016-07-13 CN CN201610551752.6A patent/CN106201826B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN106201826A (en) | 2016-12-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106201826B (en) | A method of the big affairs of diagnosis oracle database and hot spot affairs | |
| CN110493348B (en) | Intelligent monitoring alarm system based on Internet of things | |
| US11956335B1 (en) | Automated mapping of multi-tier applications in a distributed system | |
| US10841365B2 (en) | Mapping application dependencies in a computer network | |
| CN104699759B (en) | A kind of data base automatic operation and maintenance method | |
| CN107528870B (en) | A kind of collecting method and its equipment | |
| CN101741615A (en) | Server-based alarm filtering system and method | |
| CN106371986A (en) | Log treatment operation and maintenance monitoring system | |
| CN102567531B (en) | General method for monitoring status of light database | |
| CN101982957A (en) | Application method for well site real-time data and field video information release | |
| CN104574219A (en) | System and method for monitoring and early warning of operation conditions of power grid service information system | |
| CN110347663A (en) | Dynamic environment monitoring method and system based on Complex event processing engine | |
| CN102801548B (en) | A kind of method of intelligent early-warning, device and information system | |
| CN107844320A (en) | State's net software version information management system and implementation method | |
| CN101854305B (en) | Flow collection system and method, device | |
| CN106202550A (en) | A kind of cloud management platform of sewing device digital control system | |
| CN110287079A (en) | A cluster automatic monitoring system and method | |
| CN103684900A (en) | Business polling method and system | |
| CN110086682A (en) | Service link call relation view and failure root based on TCP are because of localization method | |
| CN202150114U (en) | Oracle monitoring system | |
| CN119831574A (en) | Prometaus-based traffic facility monitoring and intelligent operation and maintenance management method and system | |
| CN118677759A (en) | Communication network fault positioning system and method based on big data analysis | |
| CN110119594A (en) | SAGD well complex alarm modeling method and system | |
| CN110377478B (en) | Agent-based host asset management system | |
| CN117205540A (en) | Game monitoring method, device, equipment and storage medium |
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 |