Databases are the soul and brain of business. As the core IT business module, there is no doubt about the importance of databases. After the management database is deployed in the early stage of the system, during the continuous operation of the system, you must always pay attention to the potential impact and possible risks of the system itself and the environment on the operation, and promptly handle the risks.
Generally, we divide database Oracle O & M management into two types: reactive and forward-looking. Although reactive monitoring can accurately diagnose the O & M fault, it can solve the problem smoothly, but the problem has already occurred, even if the DBA can identify the cause and solve the problem in the shortest time, however, after all, it has had some adverse effects on users and is far from meeting the expectations of excellent DBAs. Therefore, DBAs are more looking forward to prospective monitoring. They hope to find out the manifestations and causes of all faults, and take effective measures to prevent the final occurrence of these faults before they occur.
There will be some signs before a database failure occurs. It is necessary for the database administrator to understand these signs and continue monitoring, in order to investigate and respond to common database performance and management problems before, during, or after the problem occurs, eliminate these problems in the bud to prevent problems from occurring before, and prevent problems from expanding.
Oracle Database designers have been working in this direction. For example, in database Versions later than 10 Gb, an automatic workload repository is available to help DBAs collect abnormal data during database operation. With the help of the data, the database administrator can solve the problem before the O & M fault occurs.
Faced with the ever-expanding market environment and increasingly complex market demands, enterprises urgently need an active and dynamic it o & M management solution to avoid risks and ensure IT and business consistency. The new torch network will provide enterprises with O & M services based on best practices, unique, industry-proven, and standardized, to help them actively prevent and predict potential problems and resolve them before their business is affected, quickly achieve proactive it o & M management.