CN106126403A - Oracle database failure analysis methods and device - Google Patents
Oracle database failure analysis methods and device Download PDFInfo
- Publication number
- CN106126403A CN106126403A CN201610430344.5A CN201610430344A CN106126403A CN 106126403 A CN106126403 A CN 106126403A CN 201610430344 A CN201610430344 A CN 201610430344A CN 106126403 A CN106126403 A CN 106126403A
- Authority
- CN
- China
- Prior art keywords
- display screen
- session
- terminal display
- marked
- sql statement
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000004458 analytical method Methods 0.000 title claims abstract description 34
- 238000000034 method Methods 0.000 claims abstract description 27
- 230000008859 change Effects 0.000 claims description 15
- 230000008569 process Effects 0.000 claims description 11
- 230000002159 abnormal effect Effects 0.000 abstract description 6
- 238000013024 troubleshooting Methods 0.000 abstract description 4
- 230000008901 benefit Effects 0.000 description 3
- 230000000875 corresponding effect Effects 0.000 description 3
- 230000000694 effects Effects 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000009471 action Effects 0.000 description 1
- 230000006399 behavior Effects 0.000 description 1
- 210000004556 brain Anatomy 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 238000002372 labelling Methods 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012163 sequencing technique Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/34—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
- G06F11/3452—Performance evaluation by statistical analysis
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR 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)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Computing Systems (AREA)
- Quality & Reliability (AREA)
- General Physics & Mathematics (AREA)
- Life Sciences & Earth Sciences (AREA)
- Mathematical Physics (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
The present invention relates to a kind of oracle database failure analysis methods and device, the method includes: obtains each current sessions in described data base and at the current SQL statement performed and the execution duration of described SQL statement and shows on terminal display screen, is marked performing the duration SQL statement beyond preset duration；Obtaining and wait the session of resource in described data base and show on described terminal display screen, if judging, the session number waiting same asset is marked beyond predetermined number, the session to waiting same asset；Obtain the utilization rate of each table space and show on described terminal display screen, utilization rate is marked beyond the table space of the first preset value.The present invention is marked for being likely to occur abnormal SQL statement, session, table space etc., it is easy to staff and analyzes fault, enable staff's quick positioning question, improve troubleshooting efficiency, improve the real-time of handling failure, reduce because can not handling failure and the economic loss etc. of client that causes in time.
Description
Technical field
The present invention relates to database technical field, especially relate to a kind of oracle database failure analysis methods and dress
Put.
Background technology
Data base refers to that be saved in for a long time in the storage device of computer and organize according to certain model, permissible
By various users or the set of the data of Application share.Data base's effect increasingly significant in routine work and production is relevant
Database technology also obtain fast development.In the middle of numerous database products, Oracle series data storehouse is perfect by it
Performance is widely used in the every field such as enterprise's office, Web Hosting.Oracle database is also applied to various operating system
Platform.
For comprehensive, concentration, active and the IT infrastructure effectively managing and optimizing enterprise, on large enterprise backstage all
Having an IT data center (hereinafter referred to as data center) supporting business event operating, data center is the brain of enterprise, right
The information system management of enterprise, ensures that the smooth and easy operation of business event and service have important effect.Data center is along with business
Renewal and increase and increase database server, along with the increase fault of server also can be the most more and more.
At present, oracle database is widely used in a lot of enterprises and industry, and user is to the proficiency level of oracle also
Uneven, when performance issue occurs in system, when application program slowly waits some FAQs, engineer does not knows the most former
Cause, analysis of also having no way of doing it；Possibly also owing to manual maloperation causes more loaded down with trivial details problem.If operation system requires place in real time
The when of managing higher, quick positioning question, problem analysis just becomes the short slab of data center；Once break down and may result in
The economic loss of client, political fallout.
Summary of the invention
For disadvantages described above, the present invention provides a kind of oracle database failure analysis methods and device, it is simple to work people
Member analyzes fault, enables staff's quick positioning question, improves troubleshooting efficiency.
First aspect, the oracle database failure analysis methods that the present invention provides includes:
Obtain each current sessions in described data base when the execution of the current SQL statement performed and described SQL statement
Grow and show on terminal display screen, being marked performing the duration SQL statement beyond preset duration；
Obtaining and wait the session of resource in described data base and show on described terminal display screen, if judging, wait is identical
The session number of resource exceeds the predetermined number session then to waiting same asset and is marked；
Obtain the utilization rate of each table space and show on described terminal display screen, to utilization rate beyond the first preset value
Table space be marked；
Obtain the session in interim table space and/or SQL statement and show on terminal display screen, to take described temporarily
The size of table space is marked more than session and/or the SQL statement of the second preset value
Obtain and cancel the session in table space and show on terminal display screen, surpass cancelling table space size described in taking
The session going out the 3rd preset value is marked.
Optionally, described method also includes:
The size obtaining committed memory exceeds the process of preset value and shared memory size thereof, and shows at described end
On end display screen.
Optionally, described method also includes:
Obtain waiting lock and being locked, by described wait, the thread blocked in described data base, and show at described terminal demonstration
On screen.
Optionally, described method also includes:
According to the historical record of active session in preset time period, draw the change curve of active session number, according to
Described change curve judges whether data base exception occurs；And/or
Obtain current SQL sentence implement plan in internal memory and generate binding variable incoming during this implement plan
Value, and show on described terminal display screen.
Optionally, described method also includes:
Obtain the performance analysis report of data base, and show on described terminal display screen；And
Obtain in the performance analysis report of described data base the history implement plan of the SQL statement of storage and go through described in generating
Binding variable value incoming during history implement plan, and show on described terminal display screen.
Second aspect, the oracle database fail analysis device that the present invention provides includes:
First processing module, for obtaining each current sessions in described data base in the current SQL statement performed and institute
State the execution duration of SQL statement and show on terminal display screen, marking performing the duration SQL statement beyond preset duration
Note；
Second processing module, waits the session of resource for obtaining and shows at described terminal display screen in described data base
On, if judging, the session number waiting same asset is marked beyond predetermined number, the session to waiting same asset；
3rd processing module, for obtaining the utilization rate of each table space and showing at described terminal display screen, to making
It is marked beyond the table space of the first preset value by rate；
Fourth processing module, for obtaining the session in interim table space and/or SQL statement and showing at terminal display screen
On, the size taking described interim table space is marked more than session and/or the SQL statement of the second preset value
5th processing module, cancels the session in table space for obtaining and shows at terminal display screen, to taking
State and cancel table space size and be marked beyond the session of the 3rd preset value.
Optionally, this device also includes:
6th processing module is big beyond process and the shared internal memory thereof of preset value for obtaining the size of committed memory
Little, and show on described terminal display screen.
Optionally, this device also includes:
7th processing module, for obtaining waiting lock and being locked, by described wait, the thread blocked in described data base, and
Display is on described terminal display screen.
Optionally, this device also includes:
8th processing module, for according to the historical record of active session in preset time period, draws active session
According to described change curve, the change curve of number, judges whether data base exception occurs；
9th processing module, in time obtaining current SQL sentence implement plan in internal memory and generate this implement plan
Incoming binding variable value, and show on described terminal display screen.
Optional, this device also includes:
Tenth processing module, for obtaining the performance analysis report of data base, and shows on described terminal display screen；And
11st processing module, the history of the SQL statement of storage in the performance analysis report obtaining described data base
Implement plan and generate binding variable value incoming during described history implement plan, and show on described terminal display screen.
In the oracle database failure analysis methods of present invention offer and device, to performing duration beyond preset duration
Enter beyond predetermined number, the session to waiting same asset if SQL statement is marked the session number waiting same asset
Line flag, utilization rate is marked beyond the table space of the first preset value, exceedes the size taking described interim table space
The session of the second preset value and/or SQL statement are marked and cancel table space size beyond the 3rd preset value described in taking
Session be marked, be therefore marked for being likely to occur abnormal SQL statement, session, table space etc., it is simple to work people
Member analyzes fault, enables staff's quick positioning question, improves troubleshooting efficiency, improves the real-time of handling failure,
Reduce because can not handling failure and the economic loss etc. of client that causes in time.
Accompanying drawing explanation
By inventive feature information and advantage can be more clearly understood from reference to accompanying drawing, accompanying drawing be schematic and not
It is interpreted as the present invention is carried out any restriction, in the accompanying drawings:
Fig. 1 shows according to the schematic flow sheet of oracle database failure analysis methods in one embodiment of the invention.
Detailed description of the invention
In order to be more clearly understood that the above-mentioned purpose of the present invention, feature and advantage, real with concrete below in conjunction with the accompanying drawings
The present invention is further described in detail by mode of executing.It should be noted that in the case of not conflicting, the enforcement of the application
Feature in example and embodiment can be mutually combined.
Elaborate a lot of detail in the following description so that fully understanding the present invention, but, the present invention also may be used
Implementing to use other to be different from other modes described here, therefore, protection scope of the present invention is not by described below
The restriction of specific embodiment.
The present invention provides a kind of oracle database failure analysis methods, as it is shown in figure 1, the method includes:
S101, obtain each current sessions in data base the current SQL statement performed and SQL statement execution duration also
Display, on terminal display screen, is marked performing the duration SQL statement beyond preset duration；
Wherein, SQL statement refers to use SQL (Structured Query Language is called for short SQL)
The statement write.
If it will be appreciated that the execution overlong time of SQL statement, illustrating that the execution process of SQL statement occurs abnormal, so
It is marked.
S102, acquisition data base wait the session of resource and show on terminal display screen, if judging to wait identical money
The session number in source exceeds the predetermined number session then to waiting same asset and is marked；
Under normal circumstances, wait that the session number of the time of a certain resource is fewer, such as less than 10.But,
If waiting, the session number of the time of a certain resource is the most, such as 51, illustrates that session start is piled up, and data base occurs different
Often.
S103, obtain the utilization rate of each table space and show on terminal display screen, utilization rate is preset beyond first
The table space of value is marked；
It will be appreciated that at least include a table space in data base, table space is used for storing multiple table, and stores in table
There is database object.When the utilization rate of table space is beyond certain value, the normal work of data base can be affected.
When reality is applied, it is also possible to the table space that there is automatic growth data file is shown, it is simple to work people
Member checks that table space extends the most automatically.
S104, the session obtained in interim table space and/or SQL statement also show on terminal display screen, face taking
Time table space size be marked more than session and/or the SQL statement of the second preset value；
It will be appreciated that owing to it is frequently necessary to some interim disk spaces, these spaces when oracle database works
With used by sort algorithm when being mainly used as inquiring about, discharge the most immediately after being finished, the record information in disk region is no longer made
With, therefore it is interim table space.
If it will be appreciated that certain session or SQL statement taking up room in interim table space is excessive, this session being described
Or the execution of SQL statement goes wrong, therefore it is marked here.
S105, acquisition are cancelled the session in table space and show on terminal display screen, cancel table space size to taking
Session beyond the 3rd preset value is marked.
It will be appreciated that cancel table space i.e. undo table space, can automatically distribute undo section in undo table space, these
Undo section is used for preserving the undo information in affairs, namely preserves data value before being modified.
If it will be appreciated that certain session or SQL statement taking up room in cancelling table space is excessive, this session being described
Or the execution of SQL statement goes wrong, therefore it is marked here.
It will be appreciated that there is no sequencing between each step above-mentioned.
In the database failure analysis method that the present invention provides, carry out performing the duration SQL statement beyond preset duration
If the session number that labelling waits same asset is marked, to making beyond predetermined number, the session to waiting same asset
It is marked, to the size session more than the second preset value taking interim table space beyond the table space of the first preset value by rate
And/or SQL statement is marked and cancel table space size be marked beyond the session of the 3rd preset value taking, the most right
It is marked in being likely to occur abnormal SQL statement, session, table space etc., it is simple to staff analyzes fault, makes staff
Can quick positioning question, improve troubleshooting efficiency, improve handling failure real-time, reduce because can not process in time therefore
The economic loss etc. of the client hindered and cause.
In the specific implementation, the method that the present invention provides can also include:
The size obtaining committed memory exceeds the process of preset value and shared memory size thereof, and shows in terminal aobvious
In display screen.
If the internal memory that a certain process takies is excessive, it is possible to the execution being because this process goes wrong, the most here will
Its display is on a display screen, it is simple to staff observes.
In the specific implementation, the method that the present invention provides can also include:
Obtain waiting lock and being locked, by waiting, the thread blocked in data base, and show on terminal display screen.
Here, lock and blocked thread display will be waited on a display screen, it is simple to staff searches problem.
In the specific implementation, the method that the present invention provides can also include:
According to the historical record of active session in preset time period, draw the change curve of active session number, according to
Change curve judges whether data base exception occurs.
Under normal circumstances, the number of active session will not be too high, such as 50, often below 20, if therefore from change
Changing and see in curve that the number of active session continues to increase and exceed predetermined number, database of descriptions occurs abnormal, and process starts
Pile up.
Here, by drawing the change curve of active session number, whether may determine that data base by change curve
Occur abnormal, in order to find fault in time, in time fault is positioned.
In the specific implementation, the method that the present invention provides can also include:
Obtain current SQL sentence implement plan in internal memory and generate binding variable incoming during this implement plan
Value, and show on terminal display screen.
Here, the binding variable value by implement plan and when generating this implement plan shows, it is simple to staff looks into
See.
In the specific implementation, the method that the present invention provides can also include:
Obtain the performance analysis report of data base, and show on terminal display screen；And
The history implement plan and the generation history that obtain the SQL statement of storage in the performance analysis report of data base perform meter
Binding variable value incoming when drawing, and show on terminal display screen.
Wherein, performance analysis report i.e. AWR report.
Here, performance analysis report is shown, it is simple to staff understands the service behaviour of data base.Meanwhile, also
Report will be shown the history implement plan that store and binding variable value when generating this history implement plan, it is simple to work
Personnel check.
In the specific implementation, also SQL statement can be read and at CPU/IO in execution time, the logic in each hour of past
Deng links time showing out, it is simple to staff checks.
In the specific implementation, it is also possible to find the ranking of the program consuming most interim table space, consume most and cancel
The program of table space, consumes most the program of internal memory.
Based on identical inventive concept, the present invention also provides for a kind of oracle database fail analysis device, this device bag
Include:
First processing module, for obtaining each current sessions in data base in the current SQL statement performed and SQL statement
Execution duration and show on terminal display screen, be marked beyond the SQL statement of preset duration performing duration；
Second processing module, waits the session of resource and shows at terminal display screen for obtaining, if sentencing in data base
The disconnected session number waiting same asset exceeds the predetermined number session then to waiting same asset and is marked；
3rd processing module, for obtaining the utilization rate of each table space and showing at terminal display screen, to utilization rate
Table space beyond the first preset value is marked；
Fourth processing module, for obtaining the session in interim table space and/or SQL statement and showing at terminal display screen
On, the size taking interim table space is marked more than session and/or the SQL statement of the second preset value；
5th processing module, cancels the session in table space for obtaining and shows at terminal display screen, removing taking
Pin table space size is marked beyond the session of the 3rd preset value.
Optionally, this device also includes:
6th processing module is big beyond process and the shared internal memory thereof of preset value for obtaining the size of committed memory
Little, and show on terminal display screen.
Optionally, this device also includes:
7th processing module, for obtaining waiting lock and being locked, by waiting, the thread blocked in data base, and shows at end
On end display screen.
Optionally, this device also includes:
8th processing module, for according to the historical record of active session in preset time period, draws active session
According to change curve, the change curve of number, judges whether data base exception occurs；
9th processing module, in time obtaining current SQL sentence implement plan in internal memory and generate this implement plan
Incoming binding variable value, and show on terminal display screen.
Optionally, this device also includes:
Tenth processing module, for obtaining the performance analysis report of data base, and shows on terminal display screen；And
11st processing module, in the performance analysis report obtaining data base, the history of the SQL statement of storage performs
Binding variable value incoming when plan and generation history implement plan, and show on terminal display screen.
The function that oracle database fail analysis device is oracle database failure analysis methods that the present invention provides
Structure module, has identical technique effect, does not repeats them here.
It will be appreciated that the presupposed information such as preset value in modules, predetermined number, preset duration can rule of thumb set
Put.
In the specific implementation, the button corresponding with modules can be set in display screen, press when user clicks on certain
During button, module corresponding to this button performs corresponding action, thus staff is it can be seen that after execution action on a display screen
Display result, thus fault is analyzed and positions.
It will be appreciated that the oracle database fail analysis device that the present invention provides can be a software module, just
In the instrument carrying out accident analysis.This instrument can use C/S structure, can create a data base on the server of data base
User, this user has inquiry data dictionary authority, it is simple to software directly runs at PC end, it is not necessary to installs, has user
Just, advantage efficiently.
Although being described in conjunction with the accompanying embodiments of the present invention, but those skilled in the art can be without departing from this
Making various modifications and variations in the case of bright spirit and scope, such amendment and modification each fall within by claims
Within limited range.
Claims (10)
1. an oracle database failure analysis methods, it is characterised in that including:
Obtain each current sessions in described data base the current SQL statement performed and described SQL statement execution duration also
Display, on terminal display screen, is marked performing the duration SQL statement beyond preset duration；
Obtain and described data base waits the session of resource and shows on described terminal display screen, if judging to wait same asset
Session number beyond predetermined number then to wait same asset session be marked；
Obtain the utilization rate of each table space and show on described terminal display screen, utilization rate is exceeded the table of the first preset value
Space is marked；
Obtain the session in interim table space and/or SQL statement and show on terminal display screen, empty to taking described interim table
Between size be marked more than session and/or the SQL statement of the second preset value；
Obtain and cancel the session in table space and show on terminal display screen, to cancelling table space size described in taking beyond the
The session of three preset values is marked.
Method the most according to claim 1, it is characterised in that also include:
The size obtaining committed memory exceeds the process of preset value and shared memory size thereof, and shows in described terminal aobvious
In display screen.
Method the most according to claim 1, it is characterised in that also include:
Obtain waiting lock and being locked, by described wait, the thread blocked in described data base, and show at described terminal display screen
On.
Method the most according to claim 1, it is characterised in that also include:
According to the historical record of active session in preset time period, draw the change curve of active session number, according to described
Change curve judges whether data base exception occurs；And/or
Obtain current SQL sentence implement plan in internal memory and generate binding variable value incoming during this implement plan, and
Display is on described terminal display screen.
Method the most according to claim 1, it is characterised in that also include:
Obtain the performance analysis report of data base, and show on described terminal display screen；And
Obtain in the performance analysis report of described data base the history implement plan of the SQL statement of storage and generate described history and hold
Binding variable value incoming during row plan, and show on described terminal display screen.
6. an oracle database fail analysis device, it is characterised in that including:
First processing module, for obtaining each current sessions in described data base at the current SQL statement performed and described SQL
The execution duration of statement also shows on terminal display screen, is marked performing the duration SQL statement beyond preset duration；
Second processing module, waits the session of resource for obtaining and shows at described terminal display screen in described data base,
If judging, the session number waiting same asset is marked beyond predetermined number, the session to waiting same asset；
3rd processing module, for obtaining the utilization rate of each table space and showing at described terminal display screen, to utilization rate
Table space beyond the first preset value is marked；
Fourth processing module, for obtaining the session in interim table space and/or SQL statement and showing at terminal display screen,
The size taking described interim table space is marked more than session and/or the SQL statement of the second preset value；
5th processing module, cancels the session in table space for obtaining and shows at terminal display screen, removing described in taking
Pin table space size is marked beyond the session of the 3rd preset value.
Device the most according to claim 6, it is characterised in that also include:
6th processing module, exceeds the process of preset value and shared memory size thereof for obtaining the size of committed memory,
And show on described terminal display screen.
Device the most according to claim 6, it is characterised in that also include:
7th processing module, for obtaining waiting lock and being locked, by described wait, the thread blocked in described data base, and shows
On described terminal display screen.
Device the most according to claim 6, it is characterised in that also include:
8th processing module, for according to the historical record of active session in preset time period, drawing active session number
According to described change curve, change curve, judges whether data base exception occurs；
9th processing module, is passed in time obtaining current SQL sentence implement plan in internal memory and generate this implement plan
The binding variable value entered, and show on described terminal display screen.
Device the most according to claim 6, it is characterised in that also include:
Tenth processing module, for obtaining the performance analysis report of data base, and shows on described terminal display screen；And
11st processing module, in the performance analysis report obtaining described data base, the history of the SQL statement of storage performs
Plan and generate binding variable value incoming during described history implement plan, and showing on described 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 true CN106126403A (en) | 2016-11-16 |
| CN106126403B 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) |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107609028A (en) * | 2017-08-09 | 2018-01-19 | 山东中创软件商用中间件股份有限公司 | A kind of determination method and device of inefficient SQL statement |
| CN108280097A (en) * | 2017-01-06 | 2018-07-13 | 阿里巴巴集团控股有限公司 | A kind of fault handling method and device of Database Systems |
| CN108399246A (en) * | 2018-03-01 | 2018-08-14 | 金蝶软件（中国）有限公司 | A kind of localization method and relevant apparatus of target data |
| CN108549691A (en) * | 2018-04-13 | 2018-09-18 | 郑州云海信息技术有限公司 | A kind of tracking of database session and analysis method and its device |
| CN109299132A (en) * | 2018-11-29 | 2019-02-01 | 中国人民财产保险股份有限公司 | SQL data processing method, system and electronic equipment |
| CN109492015A (en) * | 2018-10-31 | 2019-03-19 | 武汉达梦数据库有限公司 | The method and apparatus of acquisition and show activity session complete information in real time |
| CN110178121A (en) * | 2017-09-06 | 2019-08-27 | 富璟科技（深圳）有限公司 | A kind of detection method and its terminal of database |
| CN110413616A (en) * | 2019-07-15 | 2019-11-05 | 苏州浪潮智能科技有限公司 | Backup method and device for database undo table space |
| CN111897802A (en) * | 2020-08-10 | 2020-11-06 | 中国工商银行股份有限公司 | Database container fault positioning method and system |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101989283A (en) * | 2009-08-04 | 2011-03-23 | 中兴通讯股份有限公司 | Monitoring method and device of performance of database |
| CN103678630A (en) * | 2013-12-19 | 2014-03-26 | 北京用友政务软件有限公司 | Database monitoring method and system |
| US8887009B1 (en) * | 2008-06-02 | 2014-11-11 | Dell Software Inc. | Computer systems and methods for predictive performance management of data transactions |
| CN104301413A (en) * | 2014-10-17 | 2015-01-21 | 国云科技股份有限公司 | Oracle distributed real-time monitoring method orienting cloud databases |
| US20150081669A1 (en) * | 2007-09-14 | 2015-03-19 | Oracle International Corporation | Fully automated sql tuning |
| 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
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20150081669A1 (en) * | 2007-09-14 | 2015-03-19 | Oracle International Corporation | Fully automated sql tuning |
| US8887009B1 (en) * | 2008-06-02 | 2014-11-11 | Dell Software Inc. | Computer systems and methods for predictive performance management of data transactions |
| CN101989283A (en) * | 2009-08-04 | 2011-03-23 | 中兴通讯股份有限公司 | Monitoring method and device of performance of database |
| CN103678630A (en) * | 2013-12-19 | 2014-03-26 | 北京用友政务软件有限公司 | Database monitoring method and system |
| CN104301413A (en) * | 2014-10-17 | 2015-01-21 | 国云科技股份有限公司 | Oracle distributed real-time monitoring method orienting cloud databases |
| CN104462612A (en) * | 2015-01-05 | 2015-03-25 | 浪潮(北京)电子信息产业有限公司 | Method and device for monitoring database information |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108280097A (en) * | 2017-01-06 | 2018-07-13 | 阿里巴巴集团控股有限公司 | A kind of fault handling method and device of Database Systems |
| CN107609028A (en) * | 2017-08-09 | 2018-01-19 | 山东中创软件商用中间件股份有限公司 | A kind of determination method and device of inefficient SQL statement |
| CN110178121A (en) * | 2017-09-06 | 2019-08-27 | 富璟科技（深圳）有限公司 | A kind of detection method and its terminal of database |
| CN108399246A (en) * | 2018-03-01 | 2018-08-14 | 金蝶软件（中国）有限公司 | A kind of localization method and relevant apparatus of target data |
| CN108549691A (en) * | 2018-04-13 | 2018-09-18 | 郑州云海信息技术有限公司 | A kind of tracking of database session and analysis method and its device |
| CN109492015A (en) * | 2018-10-31 | 2019-03-19 | 武汉达梦数据库有限公司 | The method and apparatus of acquisition and show activity session complete information in real time |
| CN109299132A (en) * | 2018-11-29 | 2019-02-01 | 中国人民财产保险股份有限公司 | SQL data processing method, system and electronic equipment |
| CN109299132B (en) * | 2018-11-29 | 2021-08-06 | 中国人民财产保险股份有限公司 | SQL data processing method and system and electronic equipment |
| CN110413616A (en) * | 2019-07-15 | 2019-11-05 | 苏州浪潮智能科技有限公司 | Backup method and device for database undo table space |
| CN110413616B (en) * | 2019-07-15 | 2022-04-22 | 苏州浪潮智能科技有限公司 | A backup method and device for database undo tablespace |
| CN111897802A (en) * | 2020-08-10 | 2020-11-06 | 中国工商银行股份有限公司 | Database container fault positioning method and system |
| CN111897802B (en) * | 2020-08-10 | 2023-08-04 | 中国工商银行股份有限公司 | Database container fault positioning method and system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106126403B (en) | 2018-10-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106126403A (en) | Oracle database failure analysis methods and device | |
| CN109634728B (en) | Job scheduling method and device, terminal equipment and readable storage medium | |
| WO2021204013A1 (en) | Intelligent dispatching method, apparatus and device, and storage medium | |
| CN111400011B (en) | Real-time task scheduling method, system, equipment and readable storage medium | |
| CN111984390A (en) | Task scheduling method, device, equipment and storage medium | |
| CN101017546A (en) | Method and device for categorical data batch processing | |
| CN111274052A (en) | Data distribution method, server, and computer-readable storage medium | |
| CN112162980A (en) | Data quality control method and system, storage medium and electronic equipment | |
| CN101093454A (en) | Method and device for executing SQL script file in distributed system | |
| CN112579578A (en) | Metadata-based data quality management method, device and system and server | |
| CN110262975A (en) | Test data management method, device, equipment and computer readable storage medium | |
| CN106384283A (en) | Internet plus based service bus structure and service bus system | |
| CN101673374A (en) | Bill processing method and device | |
| CN110941422B (en) | Code automatic generation method, code generator and readable storage medium | |
| US20100106749A1 (en) | Reorganizing table-based data objects | |
| CN111415129A (en) | Workflow platform and terminal equipment with same | |
| CN107153679B (en) | Extraction statistical method and system for semi-structured big data | |
| CN113051279A (en) | Data message storage method, storage device, electronic equipment and storage medium | |
| CN106843822B (en) | Execution code generation method and equipment | |
| CN115617767B (en) | Management system and management method for shortening the synchronization time of information system ledger data | |
| CN110928663A (en) | Cross-platform multithreading monitoring method and device | |
| CN102314631A (en) | Event processing device of manufacturing execution system | |
| CN108363671A (en) | A kind of method, terminal device and the storage medium of interface switching | |
| CN114996081A (en) | Batch job progress monitoring method and device, electronic equipment and storage medium | |
| CN106055322A (en) | Flow scheduling method and device |
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 |