CN202150114U - Oracle monitoring system - Google Patents
Oracle monitoring system Download PDFInfo
- Publication number
- CN202150114U CN202150114U CN 201120091837 CN201120091837U CN202150114U CN 202150114 U CN202150114 U CN 202150114U CN 201120091837 CN201120091837 CN 201120091837 CN 201120091837 U CN201120091837 U CN 201120091837U CN 202150114 U CN202150114 U CN 202150114U
- Authority
- CN
- China
- Prior art keywords
- oracle
- data
- monitoring
- server
- agent
- 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.)
- Expired - Fee Related
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Debugging And Monitoring (AREA)
- Multi Processors (AREA)
Abstract
The utility model discloses an Oracle monitoring system, comprising one or more monitoring Agents which are installed on a same physical server with an Oracle database directly visit Oracle internal table through shared memory to obtain Oracle operating data; one or more data collectors for receiving and managing the operating data collected by the monitoring Agents; and a monitoring server for expressing and analyzing the health state and operating index of Oracle in a concentrated way. The utility model overcomes the deficiency that the operating data by conventional method cannot be collected after installation of Oracle, and reduces the expenses on hardware to Oracle server in the monitoring operation and improves the monitoring real-time, and capability of analyzing, diagnosing and positioning operating malfunctions of Oracle.
Description
Technical field
The utility model relates to IT O&M field, particularly, and a kind of system to Oracle running state monitoring management under the Unix/Linux environment.
Background technology
Along with IT construction deepen continuously and perfect, the operation maintenance of computer software and hardware system becomes and becomes more and more important.Database is an infrastructure crucial in the infosystem; The health status of database plays crucial effects to guaranteeing the normal operation of operation system.In order to guarantee the normal operation of database, data base management system (DBMS) all can be collected the running status of self usually, and comes out with various interface openings such as tables of data, journal files; Obtaining these indexs is the prerequisite and the basis of analysis, judgment data storehouse ruuning situation; In the daily O&M, the technician need regularly check the index of correlation of database operation, and therefrom whether the analytical database operation is normal.If index occurs unusual, need check it, analyze, get rid of and break down or potential problem.Oracle uses database very widely at present, in infosystem, plays fundamental role; It is powerful, and assembly is numerous, and this also causes its architecture complicated, and operation maintenance is IT O&M those skilled in the art's a difficult problem always.Oracle database itself provides the internal performance data of its ruuning situation, and offers the technician with the mode of tables of data.The common way of industry is regularly to pass through these performance tables of SQL query at present, obtains the correlated performance index.At first; Owing to relate to multiple management objects such as instance, SGA, storage, session, lock, data file, table space, table in the oracle database; The index of correlation of these objects of acquisition that will be complete needs to carry out numerous SQL statements, and the execution of SQL statement; Relate to a plurality of steps such as setting up database connects, compiling SQL, extraction data, bigger to performance loss; And in a lot of operation systems, database itself is exactly very busy system, and the execution of this part monitoring SQL possibly cause database performance to reduce, and response speed is slack-off, possibly be unacceptable to some application.In addition, this mode prerequisite is that database normally moves; If the situation of hang-up takes place in database, can not be to client requests normal response, monitoring tools can not be connected to database, can't carry out the SQL query performance index.
Therefore,, and, oracle database also can obtain related data when hanging up, with the validity that improves Oracle monitoring O&M greatly if can reduce the performance cost of performance index inquiry.
The utility model content
The goal of the invention of the utility model is: the problem to above-mentioned existence, a kind of Oracle supervisory system is provided, and it is characterized in that comprise: one or more monitoring Agent devices are used to gather the Oracle service data; One or more data collectors are used to receive the also service data of management and monitoring Agent collection; Monitoring server, be used for concentrating represent, Analysis of Oracle health status and operating index.
Said monitoring Agent device is arranged on the station server, and this server is the server that monitored oracle database is arranged.
Said monitoring Agent device at a time only can be connected to a data gatherer.
The technical scheme that the utility model adopts is as shown in Figure 1.This device comprises three parts: monitoring Agent, and data collector and monitoring server, its job step is following:
1) monitoring Agent is installed on oracle server;
2) index that definition will be monitored in the Agent configuration file and the corresponding table of these indexs, and monitoring period, data collector address etc.;
3) Agent starts and reads configuration file;
4) Agent regularly obtains raw data through the mode of direct SGA internal storage access from database server
5) Agent sends the data to data collector
6) monitoring server is from the data collector loading data, and organizes, represents after it is handled
Monitoring Agent comprises the program and the relevant configuration file of a C language development.The SGA of monitoring Agent through direct memory access Oracle extracts data, thus when disposing Agent must with the Oracle instance of its monitoring at same physical server; If a plurality of oracle databases on the different server are arranged, then must all dispose an independently Agent on every station server.But an Agent can monitor a plurality of Oracle instances above the same station server.
The Agent principle of work is as shown in Figure 3.Agent and Oracle instance adopt the mode of shared drive to communicate.Agent at first will obtain the sign of Oracle shared region; Shared region the inside data are deposited by piece, and Agent need confirm the base address of SGA.Agent and shared region connect then, and in order to prevent Agent maloperation shared drive, Agent is made as read-only to the authority of shared region.The statistics of will moving Oracle leaves in a series of x$ tables, and these x$ forms can be through the shared drive visit.Visit these x$ tables, also need confirm the reference position of each form in SGA, the data length of each field and reference position.After related data was confirmed, Agent just can directly read the value of relevant field through this mechanism of shared drive, thereby obtained the relevant operation of Oracle statistics.
Agent obtains sending it to data collector after the related data, can be many to many annexations, as shown in Figure 2 between Agent and the data collector.Promptly an Agent can be connected to a plurality of data collectors; The individual data gatherer also can receive the data of a plurality of Agent simultaneously.The data of Agent only can send to specific data collector simultaneously, but when this data collector can't connect, Agent can search next alternative collector unit, up to finding available unit, can improve system reliability and extendability like this.
Data collector comprises the connection management module, be used to manage and Agent between data transmission, as accept the connection request of Agent; Read the data that Agent sends; The connection that cleaning is interrupted; Data memory module is used to realize the storage of O&M data; Data processing module is used for compression, merger, the removing of O&M data, deletes like the data above 1 year, and the data that exceed month are compressed.
Monitoring server comprises that system is provided with module, is used to design monitored Oracle relevant information, like IP address, port numbers, SID, usemame/password etc.; Performance management module; Be used to check monitored object dependencies ability index; As check the history graphs in the same day, a nearest week, month, and contrast the data trend of same management entity different time sections, contrast the different management objects data trend in the section etc. at one time.The Report Server Management module, to the Oracle operating index average, statistical study such as maximal value, minimum value, form Html, Word, form forms such as Excel; And report form template managed.
In sum; Owing to adopted technique scheme; The beneficial effect of the utility model is: the first, reduced hardware spending, as previously mentioned to monitored server; Owing to adopted direct memory access technology, no matter this method is aspect the calculating when obtaining data or the storage aspect expense of bringing for the Oracle instance almost can be ignored; And classic method is passed through SQL query; Will set up database before the inquiry connects; Server need be each client's distribution server process, and Oracle can carry out grammatical analysis, lexical analysis to statement when each SQL carried out, inspection grammer, table name, field name; A large amount of operations such as retrieve data then all can produce tangible performance loss to internal memory and CPU.The second, reliability is higher; Very big defective of method existence of carrying out SQL is exactly that it depends on the operate as normal of Oracle own; If Oracle can not respond the SQL query request, this method can't obtain data.And this method adopts shared drive mechanism, as long as the Oracle instance exists, even this instance has been hung up, still can obtain data.The 3rd, because shared drive visit execution efficient is very high, this method can provide very detailed monitoring.On the one hand, the index content of monitoring can be very extensive, and on the other hand, data acquisition at interval can be very little, thereby have better real-time property.
Description of drawings
The utility model will explain through example and with reference to the mode of accompanying drawing, wherein:
Fig. 1 is the structural representation of the utility model.
Fig. 2 is the multi-Agent of the utility model, the structural representation of multidata gatherer.
Fig. 3 is a monitoring Agent job step.
Embodiment
Below in conjunction with accompanying drawing, the utility model is done detailed explanation.
For the purpose, technical scheme and the advantage that make the utility model is clearer,, the utility model is further elaborated below in conjunction with accompanying drawing and embodiment.Should be appreciated that specific embodiment described herein only in order to explanation the utility model, and be not used in qualification the utility model.
Monitoring below in conjunction with Oracle 10g instance is done further explanation to this method.At first to the Agent program be installed on monitored oracle server, can be in configuration file after the installation self-defined table that will read and field.To read x$kvit table content is example.Visit shared drive, at first need know the sign of its shared drive; Order ipcs can check shared drive relevant information in the system, comprises shmid; In addition, also can obtain through oradebug ipc.Oracle leaves its shared drive base address in the x$ksmmem table in, can obtain the shared drive base address so carry out following inquiry
select?addr?from?x$ksmmem；
After obtaining shmid and confirming Oracle SGA base address, just can connect with shared region, as previously mentioned, the authority that only need read, its code sample is following:
(void*)sga＝(void*)shmat(shmid，(void*)sga_start，SHM_RDONLY)；
After the shared drive successful connection, Agent can read the data in wherein any zone.According to configuration file, Agent confirms the base address of each table, and the base address of each table is left among the addr of correspondence table.And the side-play amount of every row and width information can be carried out correlation inquiry to X$KQFTA and X$KQFCO and obtained.The KQFCOOFF field is deposited this field side-play amount first with row in the X$KQFCO form, and KQFCOSIZ deposits the size of this field.Therefore, the address arithmetic formula of each data is in the table:
Data address=table base address+line width * line number+fields offset amount
After obtaining the address, Agent can be corresponding desired value according to field type with the internal storage location data-switching regularly just, and sends to data collector through network.The big little-endian that should be noted that server during conversion is handled, and processor word size etc.The technician can transfer these data at monitoring server and analyze, diagnoses Oracle ruuning situation.
The utility model is main relevant with the instance number that will monitor to the requirement of server.In the present embodiment, data collector and display unit all adopt the perfectly sound R520 server of association (2CPU, 8G internal memory).
The above is merely the preferred embodiment of the utility model; Not in order to restriction the utility model; Any modification of being done within all spirit and principles at the utility model, be equal to replacement and improvement etc., all should be included within the protection domain of the utility model.
Claims (3)
1. an Oracle supervisory system is characterized in that, comprising: one or more monitoring Agent devices are used to gather the Oracle service data; One or more data collectors are used to receive the also service data of management and monitoring Agent collection; Monitoring server, be used for concentrating represent, Analysis of Oracle health status and operating index.
2. a kind of Oracle supervisory system according to claim 1 is characterized in that: said monitoring Agent device is arranged on the station server, and this server is the server that monitored oracle database is arranged.
3. a kind of Oracle supervisory system according to claim 1 is characterized in that: said monitoring Agent device at a time only can be connected to a data gatherer.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201120091837 CN202150114U (en) | 2011-03-31 | 2011-03-31 | Oracle monitoring system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201120091837 CN202150114U (en) | 2011-03-31 | 2011-03-31 | Oracle monitoring system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN202150114U true CN202150114U (en) | 2012-02-22 |
Family
ID=45591167
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 201120091837 Expired - Fee Related CN202150114U (en) | 2011-03-31 | 2011-03-31 | Oracle monitoring system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN202150114U (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103034679A (en) * | 2012-11-14 | 2013-04-10 | 上海百事通信息技术有限公司 | Monitoring system for java operational database |
| CN104820630A (en) * | 2015-05-22 | 2015-08-05 | 上海新炬网络信息技术有限公司 | System resource monitoring device based on business variable quantity |
| CN104991853A (en) * | 2015-07-22 | 2015-10-21 | 北京京东尚科信息技术有限公司 | Method and apparatus for outputting early warning information |
| CN105302657A (en) * | 2015-11-05 | 2016-02-03 | 网易宝有限公司 | Abnormal condition analysis method and apparatus |
| CN107193711A (en) * | 2017-05-26 | 2017-09-22 | 郑州云海信息技术有限公司 | A kind of statistical analysis technique of server diagnostic result |
-
2011
- 2011-03-31 CN CN 201120091837 patent/CN202150114U/en not_active Expired - Fee Related
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103034679A (en) * | 2012-11-14 | 2013-04-10 | 上海百事通信息技术有限公司 | Monitoring system for java operational database |
| CN104820630A (en) * | 2015-05-22 | 2015-08-05 | 上海新炬网络信息技术有限公司 | System resource monitoring device based on business variable quantity |
| CN104991853A (en) * | 2015-07-22 | 2015-10-21 | 北京京东尚科信息技术有限公司 | Method and apparatus for outputting early warning information |
| CN104991853B (en) * | 2015-07-22 | 2018-07-06 | 北京京东尚科信息技术有限公司 | A kind of method and apparatus for exporting warning information |
| CN105302657A (en) * | 2015-11-05 | 2016-02-03 | 网易宝有限公司 | Abnormal condition analysis method and apparatus |
| CN105302657B (en) * | 2015-11-05 | 2020-12-15 | 网易宝有限公司 | Abnormal condition analysis method and device |
| CN107193711A (en) * | 2017-05-26 | 2017-09-22 | 郑州云海信息技术有限公司 | A kind of statistical analysis technique of server diagnostic result |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107943668B (en) | Computer server cluster log monitoring method and monitor supervision platform | |
| CN100543683C (en) | The method and system that process is monitored | |
| CN100451989C (en) | Software testing system and testing method | |
| CN202150114U (en) | Oracle monitoring system | |
| CN107818431B (en) | Method and system for providing order track data | |
| US20080155350A1 (en) | Enabling tracing operations in clusters of servers | |
| CN111382023B (en) | Code fault positioning method, device, equipment and storage medium | |
| CN101454777A (en) | Method and system for ensuring consistency over time of data gathered by distinct software applications | |
| WO2020251839A1 (en) | Generating data structures representing relationships among entities of a high-scale network infrastructure | |
| CN111339175A (en) | Data processing method and device, electronic equipment and readable storage medium | |
| CN112559280B (en) | Data full-link monitoring method based on data center station | |
| CN105740142A (en) | Pressure test management system for SSR (Server Security Reinforcement) centralized management platform | |
| US20160085655A1 (en) | Monitoring system, monitoring device, and monitoring method | |
| CN103684900A (en) | Business polling method and system | |
| CN113067717A (en) | Network request log chain tracking method, full link call monitoring system and medium | |
| CN106843965A (en) | The system and installation method of a kind of automated installation of system testing tool | |
| CN113242157A (en) | Centralized data quality monitoring method under distributed processing environment | |
| CN112506969A (en) | BMC address query method, system, equipment and readable storage medium | |
| Maplesden et al. | Performance analysis using subsuming methods: An industrial case study | |
| KR101361243B1 (en) | Apparatus and Method for Tenant-aware Security Management in Multi-Tenancy system | |
| CN115840656A (en) | Automatic operation and maintenance method and system for application program based on fault self-healing | |
| CN114925042A (en) | Method for constructing metadata relation based on graphic database | |
| CN114357001A (en) | Multi-cluster data query method and device, monitoring platform and storage medium | |
| CN1251085C (en) | Method of monitoring machine group system operation procedure and monitoring management device | |
| CN112291085A (en) | Fault positioning method, device, equipment and medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| CP01 | Change in the name or title of a patent holder |
Address after: Two Lu Tian Hua high tech Zone of Chengdu City, Sichuan province 610041 No. 219 Tianfu Software Park C District 10 building 20 layer Patentee after: CHINAWISERV TECHNOLOGIES Inc. Address before: Two Lu Tian Hua high tech Zone of Chengdu City, Sichuan province 610041 No. 219 Tianfu Software Park C District 10 building 20 layer Patentee before: CHENGDU QINZHI DIGITAL TECHNOLOGY Co.,Ltd. |
|
| CP01 | Change in the name or title of a patent holder | ||
| CP03 | Change of name, title or address |
Address after: Two Lu Tian Hua high tech Zone of Chengdu City, Sichuan province 610041 No. 219 Tianfu Software Park C District 10 building 20 layer Patentee after: CHENGDU QINZHI DIGITAL TECHNOLOGY Co.,Ltd. Address before: 610041 Sichuan province Chengdu city Chengdu high tech Zone Tianyun Road No. 150 High Tech International Plaza D block, room 404 Patentee before: Chengdu Qinzhi Digital Technology Co.,Ltd. |
|
| CP03 | Change of name, title or address | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20120222 Termination date: 20190331 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |