CN116414802A - Database state monitoring method and device, electronic equipment and storage medium - Google Patents
Database state monitoring method and device, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN116414802A CN116414802A CN202310019538.6A CN202310019538A CN116414802A CN 116414802 A CN116414802 A CN 116414802A CN 202310019538 A CN202310019538 A CN 202310019538A CN 116414802 A CN116414802 A CN 116414802A
- Authority
- CN
- China
- Prior art keywords
- information
- database
- server
- inspection report
- asm
- 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 34
- 238000012544 monitoring process Methods 0.000 title claims abstract description 29
- 238000007689 inspection Methods 0.000 claims abstract description 57
- 238000004590 computer program Methods 0.000 claims description 7
- 238000006243 chemical reaction Methods 0.000 claims description 4
- 238000012806 monitoring device Methods 0.000 claims description 2
- 238000004519 manufacturing process Methods 0.000 abstract description 7
- 230000000007 visual effect Effects 0.000 abstract description 4
- 238000012545 processing Methods 0.000 description 13
- 238000004891 communication Methods 0.000 description 10
- 238000007726 management method Methods 0.000 description 7
- 238000005516 engineering process Methods 0.000 description 6
- 238000010586 diagram Methods 0.000 description 5
- 230000003287 optical effect Effects 0.000 description 4
- 230000005236 sound signal Effects 0.000 description 4
- 239000011159 matrix material Substances 0.000 description 3
- 230000001133 acceleration Effects 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 2
- 230000008859 change Effects 0.000 description 2
- 238000013500 data storage Methods 0.000 description 2
- 230000003993 interaction Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 241000282326 Felis catus Species 0.000 description 1
- 230000009471 action Effects 0.000 description 1
- 238000003491 array Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 238000003384 imaging method Methods 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
- 230000008569 process Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The disclosure provides a method, a device, electronic equipment and a storage medium for monitoring database states, and relates to the technical field of big data, wherein the method comprises the following steps: the method comprises the steps of collecting database information of a database, wherein the database information comprises state information of the database and server information of a server where the database is located, converting the database information into a database inspection report in a preset format, and then sending the database inspection report in the preset format, so that important production index information such as the state information of the database and server information of the server where the database is located can be collected and converted into a more visual database inspection report, and further, the workload of manual inspection can be effectively reduced and the monitoring efficiency of the data state can be effectively improved by sending the inspection report to a mailbox of an appointed person.
Description
Technical Field
The disclosure relates to the technical field of big data, and in particular relates to a method and a device for monitoring a database state, electronic equipment and a storage medium.
Background
The database is a warehouse for organizing, storing and managing data according to a data structure, and is widely applied to various industries along with development of big data technology, and the state of the database can be used for describing the operation performance and database resources of the database.
In the related art, generally, when an alarm occurs in a database, a worker queries historical state information of the database, and then monitors the state of the database based on the historical state information of the database.
In this way, the queried historical state information of the database cannot describe the real-time state of the database, and the database state monitoring operability is poor and the operation efficiency is low due to the fact that the state information of the database is more numerous.
Disclosure of Invention
The disclosure provides a method, a device, an electronic device and a storage medium for monitoring a database state, which aim to solve one of the technical problems in the related art at least to a certain extent.
An embodiment of a first aspect of the present disclosure provides a method for monitoring a database state, including: collecting database information of a database, wherein the database information comprises state information of the database and server information of a server where the database is located; converting the database information into a database inspection report in a preset format; and sending the database inspection report with the preset format.
An embodiment of a second aspect of the present disclosure provides a monitoring apparatus for a database status, including: the system comprises an acquisition module, a storage module and a storage module, wherein the acquisition module is used for acquiring database information of a database, wherein the database information comprises state information of the database and server information of a server where the database is located; the conversion module is used for converting the database information into a database inspection report in a preset format; and the sending module is used for sending the database inspection report with the preset format.
An embodiment of a third aspect of the present disclosure provides an electronic device, including: a processor; a memory for storing processor-executable instructions; wherein the processor is configured to execute instructions to implement a method of monitoring a database state.
An embodiment of a fourth aspect of the present disclosure proposes a computer-readable storage medium, which when executed by a processor of an electronic device, enables the electronic device to perform a method of monitoring a database state.
An embodiment of a fifth aspect of the present disclosure proposes a computer program product comprising a computer program, characterized in that the computer program is executed by a processor for monitoring a state of a database.
In this embodiment, by collecting database information of a database, where the database information includes status information of the database and server information of a server where the database is located, converting the database information into a database inspection report in a preset format, and then sending the database inspection report in the preset format, the status information of the database and important production index information such as server information of the server where the database is located can be collected, and converted into a more intuitive database inspection report, so that by sending the inspection report to a mailbox of a designated person, the workload of manual inspection can be effectively reduced, and the monitoring efficiency of the data status can be effectively improved. Furthermore, the technical problems of poor operability and low operation efficiency of database state monitoring in the prior art are solved.
Additional aspects and advantages of the disclosure will be set forth in part in the description which follows, and in part will be obvious from the description, or may be learned by practice of the disclosure.
Drawings
The foregoing and/or additional aspects and advantages of the present disclosure will become apparent and readily appreciated from the following description of the embodiments, taken in conjunction with the accompanying drawings, in which:
FIG. 1 is a flow diagram of a method of monitoring database status according to a first embodiment of the present disclosure;
FIG. 2 is a flow chart of a method of monitoring database status according to a second embodiment of the present disclosure;
FIG. 3 is a block diagram of a database state monitoring device according to the present disclosure;
fig. 4 illustrates a block diagram of an exemplary electronic device suitable for use in implementing embodiments of the present disclosure.
Detailed Description
Embodiments of the present disclosure are described in detail below, examples of which are illustrated in the accompanying drawings, wherein like or similar reference numerals refer to like or similar elements or elements having like or similar functions throughout. The embodiments described below by referring to the drawings are exemplary only for explaining the present disclosure and are not to be construed as limiting the present disclosure. On the contrary, the embodiments of the disclosure include all alternatives, modifications, and equivalents as may be included within the spirit and scope of the appended claims.
It should be noted that, the execution body of the method for monitoring a database state in this embodiment may be a device for monitoring a database state, where the device may be implemented in software and/or hardware, and the device may be configured in an electronic device, and the electronic device may include, but is not limited to, a terminal, a server, and so on.
It should be noted that, in the technical scheme of the present disclosure, the processes of acquiring, storing, using, processing, etc. of the data all conform to the relevant regulations of the national laws and regulations, and do not violate the popular regulations of the public order.
Fig. 1 is a flow chart of a method for monitoring a database state according to a first embodiment of the present disclosure, as shown in fig. 1, the method includes:
s101: and collecting database information of a database, wherein the database information comprises state information of the database and server information of a server where the database is located.
The database information comprises state information of a database and server information of a server where the database is located.
Wherein the status information of the database comprises: database configuration information, database performance information and database backup information, the server information including: server information where the database is located, cluster information where the real-time database is located, automated storage management (Automatic Storage Management, ASM) information.
That is, in the embodiment of the present disclosure, the collecting database information of the database may be collecting status information (for example, database configuration information, database performance information and database backup information) of the database, collecting server information (for example, server information of the server where the database is located, cluster information of the real-time database is located, and automatic storage management (Automatic Storage Management, ASM) information) of the server where the database is located), and using the collected plurality of information together as the database information of the database, and then triggering and executing a subsequent monitoring method of the database status by combining the database information.
In some embodiments, the collecting database information of the database may be that, during the use of the database, a log of the database is obtained, and analysis processing is performed on the obtained log of the database to obtain status information of the database in the analysis processing result, and server information of a server where the database is located is used as database information of the database, which is not limited.
S102: and converting the database information into a database inspection report in a preset format.
The database inspection report can be obtained by classifying and integrating various database information, and can more intuitively summarize and display the database information of the database, so that the state of the database can be grasped more clearly.
After collecting the database information of the database, the embodiment of the disclosure can convert the database information into a database inspection report with a preset format, wherein the preset format can be, for example, a matrix format, an EXCEL format and the like, and the embodiment is not limited to the above.
In some embodiments, the database information is converted into a database inspection report in a preset format, which may be that after the database information of the database is collected, the database information is integrated into a time matrix according to the time corresponding to the database information, and the time matrix obtained by the integration is used as the database inspection report, which is not limited.
Optionally, in some embodiments, the database information is converted into the database inspection report in the preset format, which may be generated by combining a txt2xls. Jar program with a preset EXCEL template, so that the generation effect of the database inspection report can be effectively improved, and the generated database inspection report in the EXCEL format can be displayed more intuitively.
S103: and sending a database inspection report in a preset format.
According to the embodiment of the disclosure, after the database information is converted into the database inspection report in the preset format, the database inspection report in the preset format can be sent to the appointed personnel, so that the related personnel can be conveniently informed of the database inspection report according to the database inspection report, and the database state can be effectively monitored based on the database inspection report.
In some embodiments, the sending of the database inspection report in the preset format may be pre-obtaining mailboxes or calls of a plurality of related staff, and after the database information is converted into the database inspection report in the preset format, sending the database inspection report to the appointed staff in a mail or a short message, so that the appointed staff can timely handle related production problems according to the database inspection report, and the workload of manually going to production inquiry can be effectively reduced.
In this embodiment, the database information is collected, where the database information includes the state information of the database and the server information of the server where the database is located, and the database information is converted into the database inspection report in a preset format, and then the database inspection report in the preset format is sent, so that the state information of the database and important production index information such as the server information of the server where the database is located can be collected, and converted into the more visual database inspection report, and therefore, the workload of manual inspection can be effectively reduced and the monitoring efficiency of the data state can be effectively improved by sending the inspection report to the mailbox of the appointed personnel.
Fig. 2 is a flow chart of a method for monitoring a database state according to a second embodiment of the present disclosure, as shown in fig. 2, the method includes:
s201: and calling Linux instructions to collect server information.
Wherein the server information includes: CPU usage, memory usage, IO latency information, disk usage information, and host configuration information.
That is, in the embodiment of the present disclosure, the related Linux instruction may be called to collect the CPU usage rate, the memory usage rate, the IO waiting information, the disk usage information, and the host configuration information, where the call relationship between the related Linux instruction and the server information may be as shown in table 1:
TABLE 1
| Server information | Linux instruction |
| CPU utilization and memory utilization | vmstat |
| IO waiting information | sar |
| Disk usage information | df-h |
| Host configuration information | cat/etc/hosts |
S202: and calling an Oracle instruction to collect ASM information.
Wherein the ASM information includes: ASM status information, disk group status information, storage space information available to the ASM, ASM disk list information, and ASM-corresponding physical disk information.
That is, in the embodiment of the present disclosure, related Oracle instructions may be called to collect ASM state information, disk group state information, storage space information available for ASM, ASM disk list information, and ASM corresponding physical disk information, where the calling relationship between the related Oracle instructions and the ASM information may be as shown in table 2:
TABLE 2
| ASM information | Oracle instruction |
| ASM status information | srvctl status asm |
| Disk group status information | srvctl status diskgroup-g DATA |
| Storage space information available to ASM | asmcmd-p lsdg |
| ASM disk list information | oracleasm listdisks |
| ASM corresponding to physical disk information | oracleasm querydisk |
S203: calling Oracle system view or instruction acquisition database configuration information.
Wherein the database configuration information includes: database version information, database patch history information, database SGA information, control file information, redox log file status information, redox log file location information, database archive log information, table space usage information, temporary table space usage information, data file information, auto extension information, and user default table space information.
That is, in the embodiment of the present disclosure, the method may be to collect the version information of the database, the patch history information of the database, the SGA information of the database, the control file information, the status information of the redox log file, the location information of the redox log file, the archive log information of the database, the usage information of the table space, the usage information of the temporary table space, the data file information, the automatic extension information and the default table space information of the user, and the calling relationship between the related view or instruction of the Oracle system and the configuration information of the database may be as shown in table 3:
TABLE 3 Table 3
S204: calling Oracle system view or instruction collection database performance information.
Wherein the database performance information comprises: failure job information, invalidation index information, invalidation object information, memory hit rate information, and previous 10 wait event information.
That is, in the embodiment of the present disclosure, the Oracle system view or instruction acquisition failure job information, the invalidation index information, the invalidation object information, the memory hit rate information, and the first 10 wait event information may be called, and the calling relationship between the related Oracle system view or instruction and the database performance information may be as shown in Table 4:
TABLE 4 Table 4
S205: and converting the database information into a database inspection report in a preset format.
S206: and sending a database inspection report in a preset format.
The descriptions of S205-S206 can be specifically referred to the above embodiments, and are not repeated here.
In the embodiment of the disclosure, the Linux instruction is called to collect server information, the Oracle instruction is called to collect ASM information, then the Oracle system view or the instruction is called to collect database configuration information, the Oracle system view or the instruction is called to collect database performance information, the database information is converted into a database inspection report in a preset format, and the database inspection report in the preset format is sent, so that state information of the database, important production index information such as server information of a server where the database is located and the like can be collected, and converted into a more visual database inspection report, and therefore, the workload of manual inspection can be effectively reduced and the monitoring efficiency of the data state can be effectively improved by sending the inspection report to a mailbox of a designated person.
Fig. 3 is a block diagram of a database state monitoring apparatus according to the present disclosure, and as shown in fig. 3, the database state monitoring apparatus 30 includes:
the collection module 301 is configured to collect database information of a database, where the database information includes status information of the database and server information of a server where the database is located;
the conversion module 302 is configured to convert the database information into a database inspection report in a preset format;
and the sending module 303 is used for sending the database inspection report with the preset format.
In some embodiments of the present disclosure, the state information of the database includes: database configuration information, database performance information and database backup information, the server information including: server information of the database, cluster information of the real-time database and automatic storage management ASM information.
In some embodiments of the present disclosure, the conversion module 302 is further configured to:
and (3) combining a preset EXCEL template through a txt2xls. Jar program to generate a database inspection report in the EXCEL format.
In some embodiments of the present disclosure, the acquisition module 301 is further configured to:
and calling a Linux instruction to acquire server information, wherein the server information comprises CPU (Central processing Unit) utilization rate, memory utilization rate, IO (input/output) waiting information, disk utilization condition information and host configuration information.
In some embodiments of the present disclosure, the acquisition module 301 is further configured to:
invoking an Oracle instruction to collect ASM information, wherein the ASM information comprises: ASM status information, disk group status information, storage space information available to the ASM, ASM disk list information, and ASM-corresponding physical disk information.
In some embodiments of the present disclosure, the acquisition module 301 is further configured to:
calling Oracle system view or instruction collection database configuration information, wherein the database configuration information comprises: database version information, database patch history information, database SGA information, control file information, redox log file status information, redox log file location information, database archive log information, table space usage information, temporary table space usage information, data file information, auto extension information, and user default table space information.
In some embodiments of the present disclosure, the acquisition module 301 is further configured to:
invoking Oracle system view or instruction to collect database performance information, wherein the database performance information comprises: failure job information, invalidation index information, invalidation object information, memory hit rate information, and previous 10 wait event information.
In this embodiment, the database information is collected, where the database information includes the state information of the database and the server information of the server where the database is located, and the database information is converted into the database inspection report in a preset format, and then the database inspection report in the preset format is sent, so that the state information of the database and important production index information such as the server information of the server where the database is located can be collected, and converted into the more visual database inspection report, and therefore, the workload of manual inspection can be effectively reduced and the monitoring efficiency of the data state can be effectively improved by sending the inspection report to the mailbox of the appointed personnel. Furthermore, the technical problems of poor operability and low operation efficiency of database state monitoring in the prior art are solved.
According to embodiments of the present disclosure, the present disclosure also provides an electronic device, a readable storage medium and a computer program product.
Fig. 4 is a block diagram of an electronic device, shown in accordance with the present disclosure. For example, electronic device 400 may be a mobile phone, computer, digital broadcast terminal, messaging device, game console, tablet device, medical device, exercise device, personal digital assistant, or the like.
Referring to fig. 4, an electronic device 400 may include one or more of the following components: a processing component 402, a memory 404, a power supply component 406, a multimedia component 408, an audio component 410, an input/output (I/O) interface 412, a sensor component 414, and a communication component 416.
The processing component 402 generally controls overall operation of the electronic device 400, such as operations associated with display, telephone calls, data communications, camera operations, and recording operations. The processing component 402 may include one or more processors 420 to execute instructions to perform all or part of the steps of the methods described above. Further, the processing component 402 can include one or more modules that facilitate interaction between the processing component 402 and other components. For example, the processing component 402 may include a multimedia module to facilitate interaction between the multimedia component 408 and the processing component 402.
The memory 404 is configured to store various types of data to support operations at the electronic device 400. Examples of such data include instructions for any application or method operating on electronic device 400, contact data, phonebook data, messages, pictures, videos, and the like. The memory 404 may be implemented by any type or combination of volatile or nonvolatile memory devices such as Static Random Access Memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic memory, flash memory, magnetic or optical disk.
The power supply component 406 provides power to the various components of the electronic device 400. The power components 406 may include a power management system, one or more power supplies, and other components associated with generating, managing, and distributing power for the electronic device 400.
The multimedia component 408 includes a touch-sensitive display screen between the electronic device 400 and the user that provides an output interface. In some embodiments, the touch display screen may include a Liquid Crystal Display (LCD) and a Touch Panel (TP). The touch panel includes one or more touch sensors to sense touches, swipes, and gestures on the touch panel. The touch sensor may sense not only the boundary of a touch or sliding action, but also the duration and pressure associated with the touch or sliding operation. In some embodiments, the multimedia component 408 includes a front camera and/or a rear camera. When the electronic device 400 is in an operational mode, such as a shooting mode or a video mode, the front-facing camera and/or the rear-facing camera may receive external multimedia data. Each front camera and rear camera may be a fixed optical lens system or have focal length and optical zoom capabilities.
The audio component 410 is configured to output and/or input audio signals. For example, the audio component 410 includes a Microphone (MIC) configured to receive external audio signals when the electronic device 400 is in an operational mode, such as a call mode, a recording mode, and a voice recognition mode. The received audio signals may be further stored in the memory 404 or transmitted via the communication component 416.
In some embodiments, audio component 410 further includes a speaker for outputting audio signals.
The I/O interface 412 provides an interface between the processing component 402 and peripheral interface modules, which may be a keyboard, click wheel, buttons, etc. These buttons may include, but are not limited to: homepage button, volume button, start button, and lock button.
The sensor assembly 414 includes one or more sensors for providing status assessment of various aspects of the electronic device 400. For example, the sensor assembly 414 may detect an on/off state of the electronic device 400, a relative positioning of the components, such as a display and keypad of the electronic device 400, the sensor assembly 414 may also detect a change in position of the electronic device 400 or a component of the electronic device 400, the presence or absence of a user's contact with the electronic device 400, an orientation or acceleration/deceleration of the electronic device 400, and a change in temperature of the electronic device 400. The sensor assembly 414 may include a proximity sensor configured to detect the presence of nearby objects in the absence of any physical contact. The sensor assembly 414 may also include a light sensor, such as a CMOS or CCD image sensor, for use in imaging applications. In some embodiments, the sensor assembly 414 may also include an acceleration sensor, a gyroscopic sensor, a magnetic sensor, a pressure sensor, or a temperature sensor.
The communication component 416 is configured to facilitate communication between the electronic device 400 and other devices, either wired or wireless. The electronic device 400 may access a wireless network based on a communication standard, such as WiFi,2G, or 3G, or a combination thereof. In one exemplary embodiment, the communication component 416 receives broadcast signals or broadcast-related information from an external broadcast management system via a broadcast channel. In one exemplary embodiment, the communication component 416 further includes a Near Field Communication (NFC) module to facilitate short range communications. For example, the NFC module may be implemented based on Radio Frequency Identification (RFID) technology, infrared data association (IrDA) technology, ultra Wideband (UWB) technology, bluetooth (BT) technology, and other technologies.
In an exemplary embodiment, the electronic device 400 may be implemented by one or more Application Specific Integrated Circuits (ASICs), digital Signal Processors (DSPs), digital Signal Processing Devices (DSPDs), programmable Logic Devices (PLDs), field Programmable Gate Arrays (FPGAs), controllers, microcontrollers, microprocessors, or other electronic elements for performing the above-described method of monitoring a database state.
In an exemplary embodiment, a computer-readable storage medium is also provided, such as memory 404, including instructions executable by processor 420 of electronic device 400 to perform the above-described method. Alternatively, the computer readable storage medium may be ROM, random Access Memory (RAM), CD-ROM, magnetic tape, floppy disk, optical data storage device, etc.
It is to be understood that the present disclosure is not limited to the precise arrangements and instrumentalities shown in the drawings, and that various modifications and changes may be effected without departing from the scope thereof. The scope of the present disclosure is limited only by the appended claims.
Claims (11)
1. A method for monitoring a database state, comprising:
collecting database information of a database, wherein the database information comprises state information of the database and server information of a server where the database is located;
converting the database information into a database inspection report in a preset format;
and sending the database inspection report with the preset format.
2. The method of claim 1, wherein the status information of the database comprises: database configuration information, database performance information and database backup information, the server information comprising: server information of the database, cluster information of the real-time database and automatic storage management ASM information.
3. The method of claim 1, wherein said converting said database information into a database patrol report in a pre-set format comprises:
and generating the database inspection report in the EXCEL format by combining a txt2xls.jar program with a preset EXCEL template.
4. The method as recited in claim 2, further comprising:
and calling a Linux instruction to acquire the server information, wherein the server information comprises: CPU usage, memory usage, IO latency information, disk usage information, and host configuration information.
5. The method as recited in claim 2, further comprising:
invoking an Oracle instruction to collect the ASM information, wherein the ASM information comprises: ASM status information, disk group status information, storage space information available to the ASM, ASM disk list information, and ASM-corresponding physical disk information.
6. The method as recited in claim 2, further comprising:
calling an Oracle system view or an instruction to collect the database configuration information, wherein the database configuration information comprises: database version information, database patch history information, database SGA information, control file information, redox log file status information, redox log file location information, database archive log information, table space usage information, temporary table space usage information, data file information, auto extension information, and user default table space information.
7. The method as recited in claim 2, further comprising:
calling an Oracle system view or an instruction to collect the database performance information, wherein the database performance information comprises: failure job information, invalidation index information, invalidation object information, memory hit rate information, and previous 10 wait event information.
8. A database state monitoring device, comprising:
the system comprises an acquisition module, a storage module and a storage module, wherein the acquisition module is used for acquiring database information of a database, wherein the database information comprises state information of the database and server information of a server where the database is located;
the conversion module is used for converting the database information into a database inspection report in a preset format;
and the sending module is used for sending the database inspection report with the preset format.
9. An electronic device, comprising:
a processor;
a memory for storing the processor-executable instructions;
wherein the processor is configured to execute the instructions to implement the method of any of claims 1-7.
10. A computer readable storage medium, which when executed by a processor of an electronic device, causes the electronic device to perform the method of any of claims 1-7.
11. A computer program product comprising a computer program, characterized in that the computer program, when executed by a processor, implements the method of any of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310019538.6A CN116414802A (en) | 2023-01-06 | 2023-01-06 | Database state monitoring method and device, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310019538.6A CN116414802A (en) | 2023-01-06 | 2023-01-06 | Database state monitoring method and device, electronic equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN116414802A true CN116414802A (en) | 2023-07-11 |
Family
ID=87053868
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310019538.6A Pending CN116414802A (en) | 2023-01-06 | 2023-01-06 | Database state monitoring method and device, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116414802A (en) |
-
2023
- 2023-01-06 CN CN202310019538.6A patent/CN116414802A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107919123B (en) | Multi-voice assistant control method, device and computer readable storage medium | |
| JP2016535366A (en) | Application badge adding method, application badge adding device, program, and recording medium | |
| CN111046040A (en) | Method and device for determining index, electronic equipment and storage medium | |
| CN112134987B (en) | Information processing method and device and electronic equipment | |
| CN110795314B (en) | Method and device for detecting slow node and computer readable storage medium | |
| CN116414802A (en) | Database state monitoring method and device, electronic equipment and storage medium | |
| CN110908814A (en) | Message processing method and device, electronic equipment and storage medium | |
| CN107562350B (en) | Method and device for reporting key event | |
| CN107368278B (en) | Information processing method and device | |
| CN115563156A (en) | Method, device and equipment for checking stream data information and storage medium | |
| CN106250131B (en) | Shortcut operation shielding method and device | |
| CN115509872A (en) | Client behavior data acquisition method and device | |
| CN112333233B (en) | Event information reporting method and device, electronic equipment and storage medium | |
| CN111898100A (en) | Code leakage tracing method and device and terminal equipment | |
| CN113468167B (en) | Database high water level recovery method and device and electronic equipment | |
| CN114710401B (en) | Abnormality positioning method and device | |
| CN108197001B (en) | Data statistical method and device and electronic equipment | |
| CN115114029A (en) | Abnormal file positioning method and device, electronic equipment and storage medium | |
| CN116996584A (en) | Task processing method, device and equipment | |
| CN116739087A (en) | Outgoing mail alarm method, device, equipment and storage medium | |
| CN118132543A (en) | Data processing method, device, terminal equipment and medium | |
| CN107544965B (en) | Method for optimizing size of static lexicon and electronic equipment | |
| CN115640319A (en) | Service data processing method and device, electronic equipment and storage medium | |
| CN117472931A (en) | Method, device, equipment and storage medium for calling database execution statement | |
| CN116756142A (en) | Data table acquisition method and device based on working data and electronic equipment |
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 |