CN106126403B - Oracle database failure analysis methods and device - Google Patents
Oracle database failure analysis methods and device Download PDFInfo
- Publication number
- CN106126403B CN106126403B CN201610430344.5A CN201610430344A CN106126403B CN 106126403 B CN106126403 B CN 106126403B CN 201610430344 A CN201610430344 A CN 201610430344A CN 106126403 B CN106126403 B CN 106126403B
- Authority
- CN
- China
- Prior art keywords
- display screen
- session
- terminal display
- database
- marked
- 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/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
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Computing Systems (AREA)
- Quality & Reliability (AREA)
- General Physics & Mathematics (AREA)
- Evolutionary Biology (AREA)
- Probability & Statistics with Applications (AREA)
- Computer Hardware Design (AREA)
- Bioinformatics & Computational Biology (AREA)
- Bioinformatics & Cheminformatics (AREA)
- Life Sciences & Earth Sciences (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Debugging And Monitoring (AREA)
Abstract
The present invention relates to a kind of oracle database failure analysis methods and device, this method to include：Each current sessions are obtained in the database in the execution duration of currently performed SQL statement and the SQL statement and are shown on terminal display screen, are marked to executing SQL statement of the duration beyond preset duration；It obtains the session for waiting for resource in the database and is shown on the terminal display screen, to waiting for the session of same asset to be marked if judging that the session number of same asset is waited for exceed predetermined number；It obtains the utilization rate of each table space and is shown on the terminal display screen, table space of the utilization rate beyond the first preset value is marked.The present invention is marked for being likely to occur abnormal SQL statement, session, table space etc., failure is analyzed convenient for staff, enable staff's quick positioning question, improve troubleshooting efficiency, the real-time of handling failure is improved, is reduced because being unable to the economic loss etc. of client caused by timely processing failure.
Description
Technical field
The present invention relates to database technical fields, more particularly, to a kind of oracle database failure analysis methods and dress
It sets.
Background technology
Database refer to it is that long-term preservation is organized in the storage device of computer and according to certain model, can be with
By various users or the set of the data of Application share.Effect increasingly significant of the database in routine work and production is related
Database technology also grown rapidly.In numerous database products, Oracle series datas library is perfect by its
Performance is widely used in the every field such as enterprise's office, Web Hosting.Oracle database is also applied to various operating systems
Platform.
In order to comprehensively, concentrate, actively and effectively manage and optimize enterprise IT infrastructure, large enterprise backstage all
There are one the IT data centers (hereinafter referred to as data center) of support business event operating, and data center is the brain of enterprise, right
The information system management of enterprise ensures that the smooth operation of business event and service play an important role.Data center is with business
Update and increase and increase database server, also can be and then more and more with the increase failure of server.
Currently, oracle database is widely used in many enterprises and industry, qualification of the user to oracle
Irregular, when performance issue occurs in system, and application program slowly waits some FAQs, engineer does not know specific original
Cause, analysis of also having no way of doing it；May also more cumbersome problem be led to due to manual maloperation.If operation system requires place in real time
When managing relatively high, quick positioning question, problem analysis just becomes the short slab of data center；Once failure may result in
The economic loss of client, political impact.
Invention content
For disadvantages described above, a kind of oracle database failure analysis methods of present invention offer and device are convenient for work people
Member's analysis failure, enables staff's quick positioning question, improves troubleshooting efficiency.
In a first aspect, oracle database failure analysis methods provided by the invention include：
Each current sessions are obtained in the database in the execution of currently performed SQL statement and the SQL statement
It grows and is shown on terminal display screen, be marked to executing SQL statement of the duration beyond preset duration；
It obtains the session for waiting for resource in the database and is shown on the terminal display screen, if judging to wait for identical
The session number of resource is then marked the session for waiting for same asset beyond predetermined number；
It obtains the utilization rate of each table space and is shown on the terminal display screen, the first preset value is exceeded to utilization rate
Table space be marked；
It obtains the session and/or SQL statement in interim table space and is shown on terminal display screen, it is described interim to occupying
The size of table space is more than that the session of the second preset value and/or SQL statement are marked
It obtains the session in revocation table space and is shown on terminal display screen, it is super to occupying the revocation table space size
The session for going out third preset value is marked.
Optionally, the method further includes：
Process and its occupied memory size of the size of committed memory beyond preset value are obtained, and is shown in the end
It holds on display screen.
Optionally, the method further includes：
It obtains the waiting lock in the database and waits for the thread of lock obstruction by described, and be shown in the terminal and show
On screen.
Optionally, the method further includes：
According to the historical record of active session within a preset period of time, the change curve of active session number is drawn, according to
The change curve judges whether database exception occurs；And/or
It obtains current SQL sentence executive plan in memory and generates the binding variable being passed to when the executive plan
Value, and be shown on the terminal display screen.
Optionally, the method further includes：
The performance analysis report of database is obtained, and is shown on the terminal display screen；And
It obtains and is gone through described in the history executive plan and generation of the SQL statement stored in the performance analysis report of the database
The binding variable value being passed to when history executive plan, and be shown on the terminal display screen.
Second aspect, oracle database fail analysis device provided by the invention include：
First processing module, for obtaining in the database each current sessions in currently performed SQL statement and institute
It states the execution duration of SQL statement and is shown on terminal display screen, to executing SQL statement of the duration beyond preset duration into rower
Note；
Second processing module, for obtaining the session of waiting resource in the database and being shown in the terminal display screen
On, to waiting for the session of same asset to be marked if judging that the session number of same asset is waited for exceed predetermined number；
Third processing module, utilization rate for obtaining each table space is simultaneously shown in the terminal display screen, to making
It is marked with table space of the rate beyond the first preset value；
Fourth processing module, for obtaining session in interim table space and/or SQL statement and being shown in terminal display screen
On, the size to occupying the interim table space is more than that the session of the second preset value and/or SQL statement are marked
5th processing module, for obtaining the session in revocation table space and being shown in terminal display screen, to occupying institute
Session of the revocation table space size beyond third preset value is stated to be marked.
Optionally, which further includes：
6th processing module is big for obtaining process and its occupied memory of the size of committed memory beyond preset value
It is small, and be shown on the terminal display screen.
Optionally, which further includes：
7th processing module, the thread for obtaining the waiting lock in the database and being blocked by the waiting lock, and
It is shown on the terminal display screen.
Optionally, which further includes：
8th processing module draws active session for the historical record according to active session within a preset period of time
Several change curves judges whether database exception occurs according to the change curve；
9th processing module, when for obtaining current SQL sentence executive plan in memory and generate the executive plan
The binding variable value being passed to, and be shown on the terminal display screen.
Optional, which further includes：
Tenth processing module, the performance analysis report for obtaining database, and be shown on the terminal display screen；And
11st processing module, the history of the SQL statement stored in the performance analysis report for obtaining the database
The binding variable value being passed to when executive plan and the generation history executive plan, and be shown on the terminal display screen.
In oracle database failure analysis methods and device provided by the invention, exceed preset duration to executing duration
SQL statement is marked, if wait for the session number of same asset beyond predetermined number if to wait for the session of same asset into
Line flag is marked table space of the utilization rate beyond the first preset value, is more than to the size for occupying the interim table space
The session of second preset value and/or SQL statement are marked and exceed third preset value to occupying the revocation table space size
Session be marked, therefore be marked for being likely to occur abnormal SQL statement, session, table space etc., be convenient for work people
Member's analysis failure, enables staff's quick positioning question, improves troubleshooting efficiency, improve the real-time of handling failure,
It reduces because being unable to the economic loss etc. of client caused by timely processing failure.
Description of the drawings
By reference to attached drawing can be more clearly understood the present invention characteristic information and advantage, attached drawing be schematically without
It is interpreted as carrying out any restrictions to the present invention, in the accompanying drawings：
Fig. 1 shows the flow diagram according to oracle database failure analysis methods in one embodiment of the invention.
Specific implementation mode
To better understand the objects, features and advantages of the present invention, below in conjunction with the accompanying drawings and specific real
Mode is applied the present invention is further described in detail.It should be noted that in the absence of conflict, the implementation of the application
Feature in example and embodiment can be combined with each other.
Many details are elaborated in the following description to facilitate a thorough understanding of the present invention, still, the present invention may be used also
To be implemented different from other modes described here using other, therefore, protection scope of the present invention is not by described below
Specific embodiment limitation.
The present invention provides a kind of oracle database failure analysis methods, as shown in Figure 1, this method includes：
S101, obtain database in each current sessions the execution duration of currently performed SQL statement and SQL statement simultaneously
It is shown on terminal display screen, is marked to executing SQL statement of the duration beyond preset duration；
Wherein, SQL statement refers to using structured query language (Structured Query Language, abbreviation SQL)
The sentence write.
If it will be appreciated that the execution overlong time of SQL statement, it is abnormal to illustrate that the implementation procedure of SQL statement occurs, so
It is marked.
S102, it obtains the session for waiting for resource in database and is shown on terminal display screen, if judging to wait for identical money
The session number in source is then marked the session for waiting for same asset beyond predetermined number；
Under normal conditions, it is fewer to wait for the session number of the time of a certain resource, such as less than 10.However,
If waiting for the session number of the time of a certain resource relatively more, such as 51, illustrate that session start is accumulated, database occurs different
Often.
S103, the utilization rate for obtaining each table space are simultaneously shown on terminal display screen, default beyond first to utilization rate
The table space of value is marked；
It will be appreciated that including at least a table space in database, table space is stored for storing multiple tables in table
There is database object.When the utilization rate of table space exceeds certain value, the normal work of database can be influenced.
In practical application, work people can also be convenient for there are the table spaces of automatic growth data file to show
Member checks whether table space extends automatically.
S104, the session in the interim table space of acquisition and/or SQL statement are simultaneously shown on terminal display screen, are faced occupancy
When table space size be more than that the session of the second preset value and/or SQL statement are marked；
It will be appreciated that due to being frequently necessary to some interim disk spaces, these spaces when oracle database works
It is mainly used as carrying used in sort algorithm when inquiry, just be released immediately after being finished, the information to being recorded in disk region no longer makes
With, therefore it is interim table space.
It will be appreciated that if the occupied space of some session or SQL statement in interim table space is excessive, illustrate the session
Or the execution of SQL statement goes wrong, therefore be marked here.
S105, it obtains the session in revocation table space and is shown on terminal display screen, table space size is cancelled to occupying
Session beyond third preset value is marked.
It will be appreciated that revocation table space, that is, undo table spaces, can distribute undo sections automatically in undo table spaces, these
Undo sections are used for preserving the undo information in affairs, that is, to preserve data by the value before changing.
It will be appreciated that if the occupied space of some session or SQL statement in cancelling table space is excessive, illustrate the session
Or the execution of SQL statement goes wrong, therefore be marked here.
It will be appreciated that there is no sequencing between above-mentioned each step.
In database failure analysis method provided by the invention, carried out to executing SQL statement of the duration beyond preset duration
Label is marked, to making the session of waiting same asset if waiting for the session number of same asset to exceed predetermined number
Be marked with table space of the rate beyond the first preset value, be more than to the size for occupying interim table space the second preset value session
And/or SQL statement is marked and is marked to occupying session of the revocation table space size beyond third preset value, thus it is right
It is marked in being likely to occur abnormal SQL statement, session, table space etc., analyzes failure convenient for staff, make staff
Can quick positioning question, improve troubleshooting efficiency, improve the real-time of handling failure, reduce because be unable to timely processing therefore
The economic loss etc. of client caused by barrier.
In the specific implementation, method provided by the invention can also include：
Process and its occupied memory size of the size of committed memory beyond preset value are obtained, and it is aobvious to be shown in terminal
In display screen.
If the memory that a certain process occupies is excessive, it may be possible to because the execution of the process goes wrong, therefore here will
It shows on a display screen, is observed convenient for staff.
In the specific implementation, method provided by the invention can also include：
It obtains the waiting lock in database and is waited for the thread of lock obstruction, and be shown on terminal display screen.
Here, lock and the thread display being blocked will be waited on a display screen, searched problem convenient for staff.
In the specific implementation, method provided by the invention can also include：
According to the historical record of active session within a preset period of time, the change curve of active session number is drawn, according to
Change curve judges whether database exception occurs.
Under normal conditions, the number of active session will not be excessively high, such as 50, if often at 20 hereinafter, therefore from change
Change and see that the number of active session continues to increase and is more than preset quantity in curve, exception occurs in database of descriptions, and process starts
Accumulation.
Here, by drawing the change curve of active session number, whether database may determine that by change curve
There is exception, in order to find failure in time, failure is positioned in time.
In the specific implementation, method provided by the invention can also include：
It obtains current SQL sentence executive plan in memory and generates the binding variable being passed to when the executive plan
Value, and be shown on terminal display screen.
Here, executive plan and binding variable value when generating the executive plan are shown, is looked into convenient for staff
It sees.
In the specific implementation, method provided by the invention can also include：
The performance analysis report of database is obtained, and is shown on terminal display screen；And
It obtains the history executive plan of the SQL statement stored in the performance analysis report of database and generates history and execute meter
The binding variable value being passed to when drawing, and be shown on terminal display screen.
Wherein, performance analysis report, that is, AWR reports.
Here, performance analysis report is shown, the working performance of database is understood convenient for staff.Meanwhile also
The history executive plan stored in report and binding variable value when generating the history executive plan are shown, work is convenient for
Personnel check.
In the specific implementation, SQL statement can also be read and in the execution time of each hour in past, logic in CPU/IO
The time showing of equal links comes out, and is checked convenient for staff.
In the specific implementation, the ranking for the program for most consuming interim table space can also be found, most consumption revocation
The program of table space most consumes the program of memory.
Based on identical inventive concept, the present invention also provides a kind of oracle database fail analysis device, the device packets
It includes：
First processing module, for obtaining in database each current sessions in currently performed SQL statement and SQL statement
Execution duration and be shown on terminal display screen, be marked beyond the SQL statement of preset duration to executing duration；
Second processing module, for obtaining the session of waiting resource in database and being shown in terminal display screen, if sentencing
The disconnected session number for waiting for same asset is then marked the session for waiting for same asset beyond predetermined number；
Third processing module, utilization rate for obtaining each table space is simultaneously shown in terminal display screen, to utilization rate
Table space beyond the first preset value is marked；
Fourth processing module, for obtaining session in interim table space and/or SQL statement and being shown in terminal display screen
On, the size to occupying interim table space is more than that the session of the second preset value and/or SQL statement are marked；
5th processing module removes occupancy for obtaining the session in revocation table space and being shown in terminal display screen
Session of the pin table space size beyond third preset value is marked.
Optionally, which further includes：
6th processing module is big for obtaining process and its occupied memory of the size of committed memory beyond preset value
It is small, and be shown on terminal display screen.
Optionally, which further includes：
7th processing module for obtaining the waiting lock in database and being waited for the thread of lock obstruction, and is shown in end
It holds on display screen.
Optionally, which further includes：
8th processing module draws active session for the historical record according to active session within a preset period of time
Several change curves judges whether database exception occurs according to change curve；
9th processing module, when for obtaining current SQL sentence executive plan in memory and generate the executive plan
The binding variable value being passed to, and be shown on terminal display screen.
Optionally, which further includes：
Tenth processing module, the performance analysis report for obtaining database, and be shown on terminal display screen；And
The history of 11st processing module, the SQL statement stored in the performance analysis report for obtaining database executes
The binding variable value being passed to when plan and generation history executive plan, and be shown on terminal display screen.
Oracle database fail analysis device provided by the invention is the function of oracle database failure analysis methods
Structure module, technique effect having the same, details are not described herein.
It will be appreciated that the presupposed informations such as preset value, predetermined number, preset duration in modules can rule of thumb be set
It sets.
In the specific implementation, button corresponding with modules can be set in display screen, some is pressed when the user clicks
When button, the corresponding module of the button executes corresponding action, to which staff can see after execution acts on a display screen
Display as a result, so that failure is analyzed and be positioned.
It will be appreciated that oracle database fail analysis device provided by the invention can be a software module, just
In the tool for carrying out accident analysis.C/S structures may be used in the tool, and a database can be created on the server of database
User, the user have inquiry data dictionary permission, directly run, need not be installed at the ends PC convenient for software, have user
Just, quick advantage.
Although the embodiments of the invention are described in conjunction with the attached drawings, but those skilled in the art can not depart from this hair
Various modifications and variations are made in the case of bright spirit and scope, such modifications and variations are each fallen within by appended claims
Within limited range.
Claims (8)
1. a kind of oracle database failure analysis methods, which is characterized in that including：
Obtain in the database each current sessions the execution duration of currently performed SQL statement and the SQL statement simultaneously
It is shown on terminal display screen, is marked to executing SQL statement of the duration beyond preset duration；
It obtains the session for waiting for resource in the database and is shown on the terminal display screen, if judging to wait for same asset
Session number beyond predetermined number then to wait for same asset session be marked；
It obtains the utilization rate of each table space and is shown on the terminal display screen, the table of the first preset value is exceeded to utilization rate
Space is marked；
It obtains the session and/or SQL statement in interim table space and is shown on terminal display screen, it is empty to occupying the interim table
Between size be more than that the session of the second preset value and/or SQL statement are marked；
It obtains the session in revocation table space and is shown on terminal display screen, exceed the to occupying the revocation table space size
The session of three preset values is marked；
According to the historical record of active session within a preset period of time, the change curve of active session number is drawn, according to described
Change curve judges whether database exception occurs；
It obtains current SQL sentence executive plan in memory and generates the binding variable value being passed to when the executive plan, and
It is shown on the terminal display screen.
2. according to the method described in claim 1, it is characterized in that, further including：
Process and its occupied memory size of the size of committed memory beyond preset value are obtained, and it is aobvious to be shown in the terminal
In display screen.
3. according to the method described in claim 1, it is characterized in that, further including：
It obtains the waiting lock in the database and waits for the thread of lock obstruction by described, and be shown in the terminal display screen
On.
4. according to the method described in claim 1, it is characterized in that, further including：
The performance analysis report of database is obtained, and is shown on the terminal display screen；And
It obtains the history executive plan of the SQL statement stored in the performance analysis report of the database and generates the history and hold
The binding variable value being passed to when row plan, and be shown on the terminal display screen.
5. a kind of oracle database fail analysis device, which is characterized in that including：
First processing module, for obtaining in the database each current sessions in currently performed SQL statement and the SQL
The execution duration of sentence is simultaneously shown on terminal display screen, is marked to executing SQL statement of the duration beyond preset duration；
Second processing module, for obtaining the session of waiting resource in the database and being shown in the terminal display screen,
To waiting for the session of same asset to be marked if judging that the session number of same asset is waited for exceed predetermined number；
Third processing module, utilization rate for obtaining each table space is simultaneously shown in the terminal display screen, to utilization rate
Table space beyond the first preset value is marked；
Fourth processing module, for obtaining session in interim table space and/or SQL statement and being shown in terminal display screen,
Size to occupying the interim table space is more than that the session of the second preset value and/or SQL statement are marked；
5th processing module, for obtaining the session in revocation table space and being shown in terminal display screen, to being removed described in occupancy
Session of the pin table space size beyond third preset value is marked；
8th processing module draws active session number for the historical record according to active session within a preset period of time
Change curve judges whether database exception occurs according to the change curve；
9th processing module, for obtaining current SQL sentence executive plan in memory and while generating the executive plan is passed
The binding variable value entered, and be shown on the terminal display screen.
6. device according to claim 5, which is characterized in that further include：
6th processing module, for obtaining process and its occupied memory size of the size of committed memory beyond preset value,
And it is shown on the terminal display screen.
7. device according to claim 5, which is characterized in that further include：
7th processing module, the thread for obtaining the waiting lock in the database and being blocked by the waiting lock, and show
On the terminal display screen.
8. device according to claim 5, which is characterized in that further include：
Tenth processing module, the performance analysis report for obtaining database, and be shown on the terminal display screen；And
The history of 11st processing module, the SQL statement stored in the performance analysis report for obtaining the database executes
Plan and generate the binding variable value being passed to when the history executive plan, and is shown on the terminal display screen.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610430344.5A CN106126403B (en) | 2016-06-16 | 2016-06-16 | Oracle database failure analysis methods and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610430344.5A CN106126403B (en) | 2016-06-16 | 2016-06-16 | Oracle database failure analysis methods and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106126403A CN106126403A (en) | 2016-11-16 |
| CN106126403B true CN106126403B (en) | 2018-10-12 |
Family
ID=57469924
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610430344.5A Active CN106126403B (en) | 2016-06-16 | 2016-06-16 | Oracle database failure analysis methods and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106126403B (en) |
Families Citing this family (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108280097B (en) * | 2017-01-06 | 2022-09-09 | 阿里云计算有限公司 | Fault processing method and device for database system |
| CN107609028B (en) * | 2017-08-09 | 2021-10-15 | 山东中创软件商用中间件股份有限公司 | Method and device for determining low-efficiency SQL statement |
| CN110178121B (en) * | 2017-09-06 | 2023-04-21 | 富璟科技（深圳）有限公司 | Database detection method and terminal thereof |
| CN108399246B (en) * | 2018-03-01 | 2021-07-27 | 金蝶软件（中国）有限公司 | Target data positioning method and related device |
| CN108549691B (en) * | 2018-04-13 | 2021-09-17 | 郑州云海信息技术有限公司 | Database session tracking and analyzing method and device |
| CN109492015A (en) * | 2018-10-31 | 2019-03-19 | 武汉达梦数据库有限公司 | The method and apparatus of acquisition and show activity session complete information in real time |
| CN109299132B (en) * | 2018-11-29 | 2021-08-06 | 中国人民财产保险股份有限公司 | SQL data processing method and system and electronic equipment |
| CN110413616B (en) * | 2019-07-15 | 2022-04-22 | 苏州浪潮智能科技有限公司 | Backup method and device for database undo table space |
| CN111897802B (en) * | 2020-08-10 | 2023-08-04 | 中国工商银行股份有限公司 | Database container fault positioning method and system |
Family Cites Families (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8903801B2 (en) * | 2007-09-14 | 2014-12-02 | Oracle International Corporation | Fully automated SQL tuning |
| US8015454B1 (en) * | 2008-06-02 | 2011-09-06 | Quest Software, Inc. | Computer systems and methods for predictive performance management of data transactions |
| CN101989283B (en) * | 2009-08-04 | 2014-06-11 | 中兴通讯股份有限公司 | Monitoring method and device of performance of database |
| CN103678630A (en) * | 2013-12-19 | 2014-03-26 | 北京用友政务软件有限公司 | Database monitoring method and system |
| CN104301413B (en) * | 2014-10-17 | 2018-02-16 | 国云科技股份有限公司 | A kind of Oracle distributions method for real-time monitoring of facing cloud database |
| CN104462612A (en) * | 2015-01-05 | 2015-03-25 | 浪潮(北京)电子信息产业有限公司 | Method and device for monitoring database information |
-
2016
- 2016-06-16 CN CN201610430344.5A patent/CN106126403B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN106126403A (en) | 2016-11-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106126403B (en) | Oracle database failure analysis methods and device | |
| CN106776855B (en) | Processing method for reading Kafka data based on Spark Streaming | |
| US8156421B2 (en) | Analysis of database performance reports for graphical presentation of summary results | |
| US8954971B2 (en) | Data collecting method, data collecting apparatus and network management device | |
| WO2021204013A1 (en) | Intelligent dispatching method, apparatus and device, and storage medium | |
| CN113468159A (en) | Data application full-link management and control method and system | |
| CN111881221B (en) | Method, device and equipment for customer portrayal in logistics service | |
| CN108491254A (en) | A kind of dispatching method and device of data warehouse | |
| CN113641739B (en) | Spark-based intelligent data conversion method | |
| CN112199394A (en) | Alarm information push method, system, intelligent terminal and storage medium | |
| CN102521712A (en) | Process instance data processing method and device | |
| CN109684082A (en) | The data cleaning method and system of rule-based algorithm | |
| CN110727508A (en) | Task scheduling system and scheduling method | |
| CN111400011A (en) | Real-time task scheduling method, system, equipment and readable storage medium | |
| CN108255661A (en) | A kind of method and system for realizing Hadoop cluster monitorings | |
| CN113934782A (en) | A data ETL system based on DAG model and using method | |
| CN111756778A (en) | Server disk cleaning script pushing method and device and storage medium | |
| US20180032567A1 (en) | Method and device for processing data blocks in a distributed database | |
| CN118585321A (en) | Resource scheduling method and device for business execution, and electronic device | |
| US20160026735A1 (en) | Method and system for managing data in a manufacturing execution system | |
| US11657063B2 (en) | Behavioral analytics in information technology infrasturcture incident management systems | |
| CN114942916B (en) | Real-time data warehouse design method, device, equipment and storage medium based on Doris | |
| CN117149578A (en) | Task progress monitoring method and related device | |
| Perrochon et al. | Event mining with event processing networks | |
| US12105721B2 (en) | Enterprise resource planning system, server and supervision method of SQL queries in such a system or server |
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 |