CN109815081A - The long range acquisition method and collection device of database performance - Google Patents
The long range acquisition method and collection device of database performance Download PDFInfo
- Publication number
- CN109815081A CN109815081A CN201811536899.3A CN201811536899A CN109815081A CN 109815081 A CN109815081 A CN 109815081A CN 201811536899 A CN201811536899 A CN 201811536899A CN 109815081 A CN109815081 A CN 109815081A
- Authority
- CN
- China
- Prior art keywords
- database
- information
- user
- performance
- remote server
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 39
- 230000004044 response Effects 0.000 claims abstract description 4
- 238000003860 storage Methods 0.000 claims description 21
- 238000004590 computer program Methods 0.000 claims description 9
- 238000011835 investigation Methods 0.000 abstract description 3
- 230000006870 function Effects 0.000 description 11
- 230000000875 corresponding effect Effects 0.000 description 7
- 238000012545 processing Methods 0.000 description 4
- 230000005540 biological transmission Effects 0.000 description 3
- 238000010586 diagram Methods 0.000 description 3
- 238000012544 monitoring process Methods 0.000 description 3
- 230000003068 static effect Effects 0.000 description 2
- 230000002159 abnormal effect Effects 0.000 description 1
- 230000033228 biological regulation Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 230000002596 correlated effect Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000014759 maintenance of location Effects 0.000 description 1
- 238000012806 monitoring device Methods 0.000 description 1
- 230000003442 weekly effect Effects 0.000 description 1
Landscapes
- Storage Device Security (AREA)
Abstract
The present invention provides the long range acquisition method and its collection device of a kind of database performance, it the described method comprises the following steps: being requested in response to the database login of user, the data base administration authority information of user is obtained, the data base administration authority information is used to characterize the scope that the user obtains database information；The database information acquisition instruction that user issues is received, judges database information that user to be obtained whether within the administration authority of the user；If so, the intelligent terminal obtains the database information according to the database information acquisition instruction from remote server；The database information that will acquire is presented to the user.The present invention is able to respond in user instruction and real-time collecting data report relevant to database operating status, is conducive to database administrator active inquiry operating status as needed, convenient for investigation failure in time.
Description
Technical field
The present invention relates to computer O&M technical field more particularly to a kind of long range acquisition methods of database performance, dress
It sets, computer equipment and storage medium.
Background technique
Database Systems are made of computer soft and hardware resource, it realize in an organized way, dynamically storage it is a large amount of related
Join data, the access of convenient multi-purpose family.There was only database monitoring software in the industry at present, the warning information more than threshold values is pushed into number
According to the mobile terminal (being pushed by short message or wechat) of library manager (Database Administrator, abbreviation DBA), DBA
Only passively receive information, it but can not active collection information at any time according to actual needs.In addition existing database monitoring software
Function is relatively simple, only provides the performance data of database itself, can not provide the performance data of relevant computer system, when
When alerting, administrator be difficult to differentiate the alarm failure be derived from actually database be also derived from it is associated with database operation
Other computer software and hardware devices.
Summary of the invention
The object of the present invention is to provide long range acquisition method, apparatus, computer equipment and the storages of a kind of database performance
Medium, it is of the existing technology for solving the problems, such as.
To achieve the above object, the present invention provides a kind of long range acquisition method of database performance, comprising the following steps:
The database login request for responding user obtains the data base administration authority information of user, the administration authority letter
Cease the scope that database information is obtained for characterizing the user；
The database information acquisition instruction that user issues is received, judges database information that user to be obtained whether described
Within the administration authority of user；
Believe if so, the intelligent terminal obtains database according to the database information acquisition instruction from remote server
Breath；
The database information that will acquire is presented to the user.
Further, the database information acquisition instruction for receiving user and issuing, judges whether user has database
At least one the permission of acquisition of information, include the following steps:
The database performance acquisition instruction that user issues is received, judges whether user there is database performance to obtain permission；
The system performance acquisition instruction that user issues is received, judges whether user there is system performance to obtain permission；
The performance of middle piece acquisition instruction that user issues is received, judges whether user there is performance of middle piece to obtain permission；
The application performance acquisition instruction that user issues is received, judges whether user there is application performance to obtain permission.
Further, described that information is obtained from remote server according to acquisition of information instruction, include the following steps
At least one:
According to database performance acquisition instruction, obtained by calling the database interface on remote server described long-range
Database performance data on server；
According to system performance acquisition instruction, the remote service is obtained by calling the system interface on remote server
System performance information on device；
According to performance of middle piece acquisition instruction, obtained by calling the middleware interface on remote server described long-range
Performance of middle piece data on server；
According to application performance acquisition instruction, the remote service is obtained by calling the application interface on remote server
Application performance data on device.
Further, further includes: periodically or irregularly from the remote server obtain in following warning information to
It is one of few:
Database warning information, system alarm information, middleware warning information and apply warning information.
Further, the database performance includes AWR report, TOP SQL, listening state, User Status and table space
One or more of utilization rate index；
The system performance includes cpu busy percentage, thread exchange quantity, I/O operation waiting time, free memory value, net
The data packet number of network transmission, network conflict quantity, one or more of I/O number of requests index；
The performance of middle piece includes middleware log；
The application performance includes application log.
To achieve the above object, the present invention also proposes a kind of remote collection devices of database performance, comprising:
User management module is adapted to respond to the database login request of user, obtains the data base administration permission of user
Information, the data base administration authority information are used to characterize the scope that the user obtains database information；
Permission judgment module judges what user to be obtained suitable for receiving the database information acquisition instruction of user's sending
Whether database information is within the administration authority of the user；
Data obtaining module, suitable for obtaining database from remote server according to the database information acquisition instruction
Information；
Module is presented, the database information suitable for will acquire is presented to the user.
Further, the information that the data obtaining module is obtained from remote server include database performance information,
System performance information, performance of middle piece information and application performance information.
Further, further include alarm module, be suitable for periodically or irregularly obtaining from the remote server following
At least one of warning information:
Database warning information, system alarm information, middleware warning information and apply warning information.
To achieve the above object, it the present invention also provides a kind of computer equipment, including memory, processor and is stored in
On memory and the computer program that can run on a processor, the processor are realized above-mentioned when executing the computer program
The step of method.
To achieve the above object, the present invention also provides computer readable storage mediums, are stored thereon with computer program, institute
State the step of above method is realized when computer program is executed by processor.
Long range acquisition method, apparatus, computer equipment and the storage medium of database performance provided by the invention, can ring
Should in user instruction and real-time collecting data report relevant to database operating status, be conducive to database administrator according to need
Active inquiry operating status is wanted, convenient for investigation failure in time.The present invention can safeguard multiple numbers by the way that rights management is arranged simultaneously
According to library system, multinomial business can be carried out simultaneously, improve the working efficiency of data base administration.The present invention can not only provide number simultaneously
According to library performance data, system performance information, performance of middle piece data and application performance data can be also provided simultaneously, are conducive to data
Library manager's all-sidedly and accurately analyzing failure cause, eliminates potential risk in advance, ensures the stable operation of Database Systems.
Detailed description of the invention
Fig. 1 is the flow chart of the long range acquisition embodiment of the method one of database performance of the present invention；
Fig. 2 is the program module schematic diagram of the remote collection devices embodiment one of database performance of the present invention；
Fig. 3 is the hardware structural diagram of the remote collection devices embodiment one of database performance of the present invention；
Fig. 4 is the flow chart of the long range acquisition embodiment of the method two of database performance of the present invention；
Fig. 5 is the program module schematic diagram of the remote collection devices embodiment two of database performance of the present invention.
Specific embodiment
In order to make the objectives, technical solutions, and advantages of the present invention clearer, with reference to the accompanying drawings and embodiments, right
The present invention is further elaborated.It should be appreciated that described herein, specific examples are only used to explain the present invention, not
For limiting the present invention.Based on the embodiments of the present invention, those of ordinary skill in the art are not before making creative work
Every other embodiment obtained is put, shall fall within the protection scope of the present invention.
Long range acquisition method, apparatus, computer equipment and the storage medium of database performance provided by the invention, are suitable for
Computer O&M technical field provides a kind of long range acquisition method and device thereof for the running state data of Database Systems.This
Invention is able to respond in user instruction and real-time collecting data report relevant to database operating status, is conducive to data depositary management
Reason person's active inquiry operating status as needed, convenient for investigation failure in time.The present invention can be simultaneously by setting rights management
It safeguards multiple Database Systems, multinomial business can be carried out simultaneously, improve the working efficiency of data base administration.While the present invention is not only
It is capable of providing database performance data, system performance information, performance of middle piece data and application performance data can be also provided simultaneously,
Be conducive to database administrator all-sidedly and accurately analyzing failure cause, eliminate potential risk in advance, ensures the steady of Database Systems
Fixed operation.
Embodiment one
Referring to Fig. 1, in a kind of long range acquisition method of the present embodiment, comprising the following steps:
S1: intelligent terminal responds the logging request of user, obtains the administration authority information of user, the administration authority information
The scope of information is obtained for characterizing the user.
Above-mentioned intelligent terminal, which can be, is equipped with smart phone, tablet computer or other intelligence that database performance obtains app
It can electronic product.User inputs username and password in the app and logs in, and different users is allocating in advance not from the background
Same permission.After the present invention receives above-mentioned logging request order, the administration authority of the user can be obtained from rights database
Information obtains the scope of information for characterizing the user, such as which operation is specifically allowed to execute.In the present embodiment, management
Permission may include system permission and object permission: system permission refers to completion special operation or special at one in systems
The permission of special events is completed on the object of type；Object permission refers in specified object (table, view, sequence, a mistake
Journey, function or packet) on complete a special events permission.For example, user A has the permission for creating session in systems, use
Family B has the permission for creating table in systems.In addition permission can also be set up according to content.For example, certain software company sets up
First business department and the second business department, the related data of the first business department are stored in first database, the second business
The related data of department is stored in the second database.Permission then can be set are as follows: the database administrator of the first business department
First database can be written and read, but the permission without accessing the second database；The database of second business department
Administrator can be written and read the second database, but the permission without accessing first database.
S2: receiving the acquisition of information instruction that user issues, judge information that user to be obtained whether the user pipe
It manages within permission.
User can be according to the corresponding information of authority acquiring after logging on the app of smart phone.It can be obtained in the present invention
Information include but is not limited to: database performance information, system performance information, performance of middle piece information and process performance information.
Wherein database performance information includes one of AWR report, TOP SQL, listening state, User Status and table space utilization rate
Or several indexs；System performance information include cpu busy percentage, thread exchange quantity, the I/O operation waiting time, free memory value,
One or more of the data packet number of network transmission, network conflict quantity, I/O number of requests index；Performance of middle piece packet
Include middleware log；Application performance includes application log.
After receiving the acquisition of information instruction of user's sending, it is necessary first to judge whether the user has according to permission and obtain
Take the permission of relevant information.For example, user A has the permission for obtaining database performance information, but without obtaining system performance
The permission of information, performance of middle piece information and process performance information.When user A, which is issued, obtains database performance information command,
Judge that database information is included within the permission of user A, therefore the work of next step can be carried out.And when user A sending obtains
When taking performance of middle piece information command, judge that performance of middle piece information does not refer to this within the extent of competence of user A, therefore not
Order is responded.
S3: if so, the intelligent terminal obtains information according to acquisition of information instruction from remote server.
When this step on the basis of confirming that user has corresponding authority, taken according to the instruction of the acquisition of information of user from long-range
Business device obtains corresponding information.
For example, when user issues database performance acquisition instruction, intelligent terminal according to the database performance acquisition instruction,
The database performance data on remote server is obtained by calling the database interface on remote server；
When user issues system performance acquisition instruction, intelligent terminal is remote by calling according to system performance acquisition instruction
System interface on journey server obtains the system performance information on remote server；
When user issues performance of middle piece acquisition instruction, intelligent terminal passes through tune according to performance of middle piece acquisition instruction
The performance of middle piece data on remote server are obtained with the middleware interface on remote server；
When user issues application performance acquisition instruction, intelligent terminal is remote by calling according to application performance acquisition instruction
Application interface on journey server obtains the application performance data on remote server.
S4: the information that will acquire is presented to the user.
The information got in the present invention is form of data report, such as AWR report, table space utilization rate etc. mostly.
The information can be sent directly to check in the related app of smart phone for user, non-report type letter biggish for data volume
Breath can also be presented to the user in such a way that connection jumps and check for its click.In addition to can also be sent for the sake of convenient
Other receiving ends specified to user, such as client is sent to by modes such as wechat, short message or mailboxes.
Please continue to refer to Fig. 2, the long-range acquisition device for showing a kind of database performance remotely obtains in the present embodiment
Device 10 is taken to may include or be divided into one or more program modules, one or more program module is stored in storage
In medium, and as performed by one or more processors, to complete the present invention, and above-mentioned Dynamic and Multi dimensional monitoring method can be realized.
The so-called program module of the present invention is the series of computation machine program instruction section for referring to complete specific function, more than program itself
It is suitable for describing implementation procedure of the long-range acquisition device 10 in storage medium.Each journey of the present embodiment will specifically be introduced by being described below
The function of sequence module:
User management module 11 is suitable for the logging request of intelligent terminal response user, obtains the administration authority of user
Information；
Permission judgment module 12 judges user's information to be obtained suitable for receiving the acquisition of information instruction of user's sending
Whether within the administration authority of the user；
Data obtaining module 13 is suitable for the intelligent terminal and is instructed from remote server according to the acquisition of information
Obtain information；
Module 14 is presented, the information suitable for will acquire is presented to the user.
Further, the information that the data obtaining module 13 is obtained from remote server includes database performance letter
Breath, system performance information, performance of middle piece information and application performance information.
Wherein above- mentioned information acquisition module 13 includes:
Database performance obtains module, is suitable for the intelligent terminal according to database performance acquisition instruction, passes through tune
The database performance data on the remote server is obtained with the database interface on remote server；
System performance obtains module, is suitable for the intelligent terminal according to system performance acquisition instruction, by calling far
System interface on journey server obtains the system performance information on the remote server；
Performance of middle piece obtains module, is suitable for the intelligent terminal according to performance of middle piece acquisition instruction, passes through tune
The performance of middle piece data on the remote server are obtained with the middleware interface on remote server；
Application performance obtains module, is suitable for the intelligent terminal according to application performance acquisition instruction, by calling far
Application interface on journey server obtains the application performance data on the remote server.
The present embodiment also provides a kind of computer equipment, can such as execute the smart phone, tablet computer, notebook of program
Computer, desktop computer, rack-mount server, blade server, tower server or Cabinet-type server are (including independent
Server cluster composed by server or multiple servers) etc..The computer equipment 20 of the present embodiment includes at least but not
It is limited to: memory 21, the processor 22 of connection can be in communication with each other by system bus, as shown in Figure 3.It is pointed out that Fig. 3
The computer equipment 20 with component 21-22 is illustrated only, it should be understood that being not required for implementing all groups shown
Part, the implementation that can be substituted is more or less component.
In the present embodiment, memory 21 (i.e. readable storage medium storing program for executing) includes flash memory, hard disk, multimedia card, card-type memory
(for example, SD or DX memory etc.), random access storage device (RAM), static random-access memory (SRAM), read-only memory
(ROM), electrically erasable programmable read-only memory (EEPROM), programmable read only memory (PROM), magnetic storage, magnetic
Disk, CD etc..In some embodiments, memory 21 can be the internal storage unit of computer equipment 20, such as the calculating
The hard disk or memory of machine equipment 20.In further embodiments, memory 21 is also possible to the external storage of computer equipment 20
The plug-in type hard disk being equipped in equipment, such as the computer equipment 20, intelligent memory card (Smart Media Card, SMC), peace
Digital (Secure Digital, SD) card, flash card (Flash Card) etc..Certainly, memory 21 can also both include meter
The internal storage unit for calculating machine equipment 20 also includes its External memory equipment.In the present embodiment, memory 21 is commonly used in storage
Be installed on the operating system and types of applications software of computer equipment 20, for example, embodiment one long-range acquisition device 10 program
Code etc..In addition, memory 21 can be also used for temporarily storing the Various types of data that has exported or will export.
Processor 22 can be in some embodiments central processing unit (Central Processing Unit, CPU),
Controller, microcontroller, microprocessor or other data processing chips.The processor 22 is commonly used in control computer equipment
20 overall operation.In the present embodiment, program code or processing data of the processor 22 for being stored in run memory 21,
Such as long-range acquisition device 10 is run, to realize the Dynamic and Multi dimensional monitoring method of embodiment one.
The present embodiment also provides a kind of computer readable storage medium, such as flash memory, hard disk, multimedia card, card-type memory
(for example, SD or DX memory etc.), random access storage device (RAM), static random-access memory (SRAM), read-only memory
(ROM), electrically erasable programmable read-only memory (EEPROM), programmable read only memory (PROM), magnetic storage, magnetic
Disk, CD, server, App are stored thereon with computer program, phase are realized when program is executed by processor using store etc.
Answer function.The computer readable storage medium of the present embodiment is for storing long-range acquisition device 10, realization when being executed by processor
The Dynamic and Multi dimensional monitoring method of embodiment one.
Embodiment two
Referring to Fig. 4, the long-range acquisition methods of the present embodiment are based on embodiment one, comprising the following steps:
S1: intelligent terminal responds the logging request of user, obtains the administration authority information of user.
Above-mentioned intelligent terminal, which can be, is equipped with smart phone, tablet computer or other intelligence that database performance obtains app
It can electronic product.User inputs username and password in the app and logs in, and different users is allocating in advance not from the background
Same permission.After the present invention receives above-mentioned logging request order, the administration authority of the user can be obtained from rights database
Information obtains the scope of information for characterizing the user, such as which operation is specifically allowed to execute.In the present embodiment, management
Permission may include system permission and object permission: system permission refers to completion special operation or special at one in systems
The permission of special events is completed on the object of type；Object permission refers in specified object (table, view, sequence, a mistake
Journey, function or packet) on complete a special events permission.For example, user A has the permission for creating session in systems, use
Family B has the permission for creating table in systems.In addition permission can also be set up according to content.For example, certain software company sets up
First business department and the second business department, the related data of the first business department are stored in first database, the second business
The related data of department is stored in the second database.Permission then can be set are as follows: the database administrator of the first business department
First database can be written and read, but the permission without accessing the second database；The database of second business department
Administrator can be written and read the second database, but the permission without accessing first database.
S2: receiving the acquisition of information instruction that user issues, judge information that user to be obtained whether the user pipe
It manages within permission.
User can be according to the corresponding information of authority acquiring after logging on the app of smart phone.It can be obtained in the present invention
Information include but is not limited to: database performance information, system performance information, performance of middle piece information and process performance information.
Wherein database performance information includes one of AWR report, TOP SQL, listening state, User Status and table space utilization rate
Or several indexs；System performance information include cpu busy percentage, thread exchange quantity, the I/O operation waiting time, free memory value,
One or more of the data packet number of network transmission, network conflict quantity, I/O number of requests index；Performance of middle piece packet
Include middleware log；Application performance includes application log.
After receiving the acquisition of information instruction of user's sending, it is necessary first to judge whether the user has according to permission and obtain
Take the permission of relevant information.For example, user A has the permission for obtaining database performance information, but without obtaining system performance
The permission of information, performance of middle piece information and process performance information.When user A, which is issued, obtains database performance information command,
Judge that database information is included within the permission of user A, therefore the work of next step can be carried out.And when user A sending obtains
When taking performance of middle piece information command, judge that performance of middle piece information does not refer to this within the extent of competence of user A, therefore not
Order is responded.
S3: if so, the intelligent terminal obtains information according to acquisition of information instruction from remote server.
When this step on the basis of confirming that user has corresponding authority, taken according to the instruction of the acquisition of information of user from long-range
Business device obtains corresponding information.
For example, when user issues database performance acquisition instruction, intelligent terminal according to the database performance acquisition instruction,
The database performance data on remote server is obtained by calling the database interface on remote server；
When user issues system performance acquisition instruction, intelligent terminal is remote by calling according to system performance acquisition instruction
System interface on journey server obtains the system performance information on remote server；
When user issues performance of middle piece acquisition instruction, intelligent terminal passes through tune according to performance of middle piece acquisition instruction
The performance of middle piece data on remote server are obtained with the middleware interface on remote server；
When user issues application performance acquisition instruction, intelligent terminal is remote by calling according to application performance acquisition instruction
Application interface on journey server obtains the application performance data on remote server.
S4: at least one of following warning information periodically or irregularly is obtained from the remote server:
Database warning information, system alarm information, middleware warning information and apply warning information.
Increase the function of sending a warning message in the present embodiment, including database warning information, system alarm information, in
Between part warning information and apply warning information, when any one of above content parameter alarm threshold, can send corresponding
Warning information, while subsidiary correlated performance data report.
Above-mentioned warning information sends not according to user instruction, but is sent according to preset condition, for example, not when
It is sent immediately to user when detecting abnormal parameters, or regulation is sent weekly once, is monthly sent primary etc..
Warning information in this step is also selectively to be sent according to client rights.Such as user A only has data
The permission of library performance, without the permission of system performance, performance of middle piece and application performance, then under the condition that the preset conditions are met
Only database warning information can be sent to user A, system alarm information, middleware warning information and application will not be sent to user
Warning information.In another example user B has the permission of database performance, system performance and performance of middle piece, do not have application performance
Permission database warning information can be sent to user B, system alarm information and middleware are accused then when meeting preset condition
Alert information, without to user's B sending application warning information.
S5: the information that will acquire is presented to the user.
The information got in the present invention is form of data report, such as AWR report, table space utilization rate etc. mostly.
The information can be sent directly to check in the related app of smart phone for user.In addition to can also be sent for the sake of convenient
Other receiving ends specified to user, such as client is sent to by modes such as wechat, short message or mailboxes.
Please continue to refer to Fig. 5, the Dynamic and Multi dimensional monitoring device 30 of the present embodiment is based on embodiment one, to realize reality
Apply the long-range acquisition methods of example two comprising each program module function:
User management module 31 is suitable for the logging request of intelligent terminal response user, obtains the administration authority of user
Information；
Permission judgment module 32 judges user's information to be obtained suitable for receiving the acquisition of information instruction of user's sending
Whether within the administration authority of the user；
Data obtaining module 33 is suitable for the intelligent terminal and is instructed from remote server according to the acquisition of information
Obtain information；
Module 34 is presented, the information suitable for will acquire is presented to the user.
Alarm module 35, suitable for it is regular or irregularly from the remote server obtain following warning information to
It is one of few:
Database warning information, system alarm information, middleware warning information and apply warning information.
Wherein above- mentioned information acquisition module 33 includes:
Database performance obtains module, is suitable for the intelligent terminal according to database performance acquisition instruction, passes through tune
The database performance data on the remote server is obtained with the database interface on remote server；
System performance obtains module, is suitable for the intelligent terminal according to system performance acquisition instruction, by calling far
System interface on journey server obtains the system performance information on the remote server；
Performance of middle piece obtains module, is suitable for the intelligent terminal according to performance of middle piece acquisition instruction, passes through tune
The performance of middle piece data on the remote server are obtained with the middleware interface on remote server；
Application performance obtains module, is suitable for the intelligent terminal according to application performance acquisition instruction, by calling far
Application interface on journey server obtains the application performance data on the remote server.
The serial number of the above embodiments of the invention is only for description, does not represent the advantages or disadvantages of the embodiments.
Any process or the method description described in other ways in flow chart or herein is construed as, and expression includes
It is one or more for realizing specific logical function or process the step of executable instruction code module, segment or portion
Point, and the range of the preferred embodiment of the present invention includes other realization, wherein can not press shown or discussed suitable
Sequence, including according to related function by it is basic simultaneously in the way of or in the opposite order, Lai Zhihang function, this should be of the invention
Embodiment person of ordinary skill in the field understood.
Those skilled in the art are appreciated that all or part of step for realizing that above-described embodiment method carries
It suddenly is that relevant hardware can be instructed to complete by program, the program can store in a kind of computer-readable medium
In, which when being executed, includes the steps that one or a combination set of embodiment of the method.
In the description of this specification, reference term " one embodiment ", " some embodiments ", " example ", " specifically show
The description of example " or " some examples " etc. means particular features, structures, materials, or characteristics described in conjunction with this embodiment or example
It is included at least one embodiment or example of the invention.In the present specification, schematic expression of the above terms are different
Surely identical embodiment or example is referred to.Moreover, particular features, structures, materials, or characteristics described can be any
It can be combined in any suitable manner in one or more embodiment or examples.
Through the above description of the embodiments, those skilled in the art can be understood that above-described embodiment side
Method can be realized by means of software and necessary general hardware platform, naturally it is also possible to by hardware, but in many cases
The former is more preferably embodiment.
The above is only a preferred embodiment of the present invention, is not intended to limit the scope of the invention, all to utilize this hair
Equivalent structure or equivalent flow shift made by bright specification and accompanying drawing content is applied directly or indirectly in other relevant skills
Art field, is included within the scope of the present invention.
Claims (10)
1. a kind of long range acquisition method of database performance, which comprises the following steps:
In response to the database login request of user, the data base administration authority information of user, the data base administration power are obtained
Limit information is used to characterize the scope that the user obtains database information；
The database information acquisition instruction that user issues is received, judges database information that user to be obtained whether in the user
Administration authority within；
Believe if so, the intelligent terminal obtains the database according to the database information acquisition instruction from remote server
Breath；
The database information that will acquire is presented to the user.
2. long range acquisition method according to claim 1, which is characterized in that the database information for receiving user and issuing
At least one acquisition instruction judges the permission whether user there is database information to obtain, include the following steps:
The database performance acquisition instruction that user issues is received, judges whether user there is database performance to obtain permission；
The system performance acquisition instruction that user issues is received, judges whether user there is system performance to obtain permission；
The performance of middle piece acquisition instruction that user issues is received, judges whether user there is performance of middle piece to obtain permission；
The application performance acquisition instruction that user issues is received, judges whether user there is application performance to obtain permission.
3. long range acquisition method according to claim 1, which is characterized in that described to be referred to according to database information acquisition
At least one order obtains information from remote server, include the following steps:
According to database performance acquisition instruction, the remote service is obtained by calling the database interface on remote server
Database performance data on device；
According to system performance acquisition instruction, obtained on the remote server by calling the system interface on remote server
System performance information；
According to performance of middle piece acquisition instruction, the remote service is obtained by calling the middleware interface on remote server
Performance of middle piece data on device；
According to application performance acquisition instruction, obtained on the remote server by calling the application interface on remote server
Application performance data.
4. long range acquisition method according to any one of claim 1-3, which is characterized in that further include: periodically or not
Periodically at least one of following warning information is obtained from the remote server:
Database warning information, system alarm information, middleware warning information and apply warning information.
5. long range acquisition method according to claim 2 or 3, it is characterised in that:
The database performance includes one of AWR report, TOP SQL, listening state, User Status and table space utilization rate
Or several indexs；
The system performance includes cpu busy percentage, thread exchange quantity, I/O operation waiting time, free memory value, network biography
One or more of defeated data packet number, network conflict quantity, I/O number of requests index；
The performance of middle piece includes middleware log；
The application performance includes application log.
6. a kind of remote collection devices of database performance characterized by comprising
User management module is adapted to respond to the database login request of user, obtains the data base administration authority information of user,
The administration authority information is used to characterize the scope that the user obtains database information；
Permission judgment module judges user's data to be obtained suitable for receiving the database information acquisition instruction of user's sending
Whether library information is within the data base administration permission of the user；
Data obtaining module is suitable for obtaining database letter from remote server according to the database information acquisition instruction
Breath；
Module is presented, the database information suitable for will acquire is presented to the user.
7. remote collection devices according to claim 6, which is characterized in that the database information obtains module from long-range
The database information obtained on server includes database performance information, system performance information, performance of middle piece information and application
Performance information.
8. remote collection devices according to claim 6, which is characterized in that further include alarm module, be suitable for periodically or
Person irregularly obtains at least one of following warning information from the remote server:
Database warning information, system alarm information, middleware warning information and apply warning information.
9. a kind of computer equipment, can run on a memory and on a processor including memory, processor and storage
Computer program, the processor realize the step of any one of claim 1 to 5 the method when executing the computer program
Suddenly.
10. a kind of computer readable storage medium, is stored thereon with computer program, it is characterised in that: the computer program
The step of any one of claim 1 to 5 the method is realized when being executed by processor.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811536899.3A CN109815081A (en) | 2018-12-14 | 2018-12-14 | The long range acquisition method and collection device of database performance |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811536899.3A CN109815081A (en) | 2018-12-14 | 2018-12-14 | The long range acquisition method and collection device of database performance |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109815081A true CN109815081A (en) | 2019-05-28 |
Family
ID=66601755
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811536899.3A Pending CN109815081A (en) | 2018-12-14 | 2018-12-14 | The long range acquisition method and collection device of database performance |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109815081A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111130987A (en) * | 2019-11-01 | 2020-05-08 | 平安科技（深圳）有限公司 | Automatic acquisition method and device for AWR report, electronic equipment and storage medium |
| CN113221177A (en) * | 2021-05-28 | 2021-08-06 | 中国工商银行股份有限公司 | Data access method, device and system in distributed system |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1536458A (en) * | 2003-04-11 | 2004-10-13 | ������ͨ�Ƽ��������ι�˾ | System and method for managing remote computer access host |
| US20050060581A1 (en) * | 2003-09-16 | 2005-03-17 | Chebolu Anil Kumar | Remote administration of computer access settings |
| JP2010244270A (en) * | 2009-04-06 | 2010-10-28 | Nec System Technologies Ltd | Data management system, terminal computer, management computer, data management method and program thereof |
| CN103310161A (en) * | 2012-03-14 | 2013-09-18 | 北京海泰方圆科技有限公司 | Protection method and system for database system |
| CN105407078A (en) * | 2015-10-20 | 2016-03-16 | 国网四川省电力公司信息通信公司 | Data transmission method and data transmission system in electric power communication system |
| US20170139802A1 (en) * | 2014-07-03 | 2017-05-18 | Realeyes Oü | Method of collecting and processing computer user data during interaction with web-based content |
| CN107895123A (en) * | 2017-11-13 | 2018-04-10 | 医渡云（北京）技术有限公司 | Data access authority control method and device, method for managing user right |
| CN109543372A (en) * | 2018-10-26 | 2019-03-29 | 深圳壹账通智能科技有限公司 | Service authority data processing method, device, computer equipment and storage medium |
| CN109741802A (en) * | 2019-01-04 | 2019-05-10 | 深圳壹账通智能科技有限公司 | Data managing method, device, computer equipment and storage medium |
-
2018
- 2018-12-14 CN CN201811536899.3A patent/CN109815081A/en active Pending
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1536458A (en) * | 2003-04-11 | 2004-10-13 | ������ͨ�Ƽ��������ι�˾ | System and method for managing remote computer access host |
| US20050060581A1 (en) * | 2003-09-16 | 2005-03-17 | Chebolu Anil Kumar | Remote administration of computer access settings |
| JP2010244270A (en) * | 2009-04-06 | 2010-10-28 | Nec System Technologies Ltd | Data management system, terminal computer, management computer, data management method and program thereof |
| CN103310161A (en) * | 2012-03-14 | 2013-09-18 | 北京海泰方圆科技有限公司 | Protection method and system for database system |
| US20170139802A1 (en) * | 2014-07-03 | 2017-05-18 | Realeyes Oü | Method of collecting and processing computer user data during interaction with web-based content |
| CN105407078A (en) * | 2015-10-20 | 2016-03-16 | 国网四川省电力公司信息通信公司 | Data transmission method and data transmission system in electric power communication system |
| CN107895123A (en) * | 2017-11-13 | 2018-04-10 | 医渡云（北京）技术有限公司 | Data access authority control method and device, method for managing user right |
| CN109543372A (en) * | 2018-10-26 | 2019-03-29 | 深圳壹账通智能科技有限公司 | Service authority data processing method, device, computer equipment and storage medium |
| CN109741802A (en) * | 2019-01-04 | 2019-05-10 | 深圳壹账通智能科技有限公司 | Data managing method, device, computer equipment and storage medium |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111130987A (en) * | 2019-11-01 | 2020-05-08 | 平安科技（深圳）有限公司 | Automatic acquisition method and device for AWR report, electronic equipment and storage medium |
| CN113221177A (en) * | 2021-05-28 | 2021-08-06 | 中国工商银行股份有限公司 | Data access method, device and system in distributed system |
| CN113221177B (en) * | 2021-05-28 | 2025-06-17 | 中国工商银行股份有限公司 | Data access method, device and system in distributed system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9165036B2 (en) | Streaming transaction notifications | |
| CN110851278A (en) | Distribution network automation master station mobile application service management method and system based on micro-service architecture | |
| CN108390933B (en) | Message distribution method, device, server and storage medium | |
| CN115277566B (en) | Load balancing method and device for data access, computer equipment and medium | |
| CN104636678B (en) | The method and system of management and control is carried out under a kind of cloud computing environment to terminal device | |
| CN111813573B (en) | Communication method of management platform and robot software and related equipment thereof | |
| CN112511580B (en) | Message pushing method, device, storage medium and equipment | |
| CN107729213B (en) | Background task monitoring method and device | |
| CN109189749A (en) | File synchronisation method and terminal device | |
| WO2020224100A1 (en) | Blockchain configuration file processing apparatus, system, and method, and storage medium | |
| CN109298937A (en) | File parsing method and network device | |
| WO2022245291A2 (en) | Method and apparatus for managing resources, computer device and storage medium | |
| CN103457802A (en) | Information transmission system and method | |
| CN113220342A (en) | Centralized configuration method and device, electronic equipment and storage medium | |
| CN114338684A (en) | Energy management system and method | |
| CN110333916A (en) | Request message processing method, device, computer system and readable storage medium storing program for executing | |
| CN109815081A (en) | The long range acquisition method and collection device of database performance | |
| CN109257256A (en) | Apparatus monitoring method, device, computer equipment and storage medium | |
| CA3136021A1 (en) | Log storage method and device and computer system | |
| CN107682222A (en) | A kind of information monitoring method, apparatus and system | |
| CN105228139B (en) | A call processing method, device and device based on an intelligent device | |
| CN108830441B (en) | Resource query method and device | |
| CN114844763B (en) | Data processing method and device, electronic equipment and storage medium | |
| CN106161592A (en) | A kind of method and device realizing that remote command performs | |
| CN115913912B (en) | Method and device for intercepting message and generating service link diagram |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20190528 |
|
| WD01 | Invention patent application deemed withdrawn after publication |