An error occurred from Oracle DB—what should I do?
Explaining the error investigation flow based on on-site experience, from alert logs to AWR!
This article summarizes the investigation of errors that cannot be avoided when operating Oracle DB, based on actual experiences in the field. When an error occurs, the first step is to check the alert logs. There are DB alert logs, ASM alert logs, and CRS alert logs. Next, we check the trace logs and incident logs. Using the example of ORA-04031, we introduce the basic methods for checking three key items in AWR. Additionally, we touch on the verification of Memory Dynamic Components and SQL ordered by Elapsed Time. Furthermore, we explain information that is useful for failure investigation, such as ASH (Active Session History) and TFA (Trace File Analyzer). *For more detailed content of the blog, please refer to the related links. For further inquiries, feel free to contact us.
basic information
*You can view the detailed content of the blog through the related links. For more information, please feel free to contact us.*
Price range
Delivery Time
Applications/Examples of results
*You can view the detailed content of the blog through the related links. For more information, please feel free to contact us.*
Distributors
CNS Corporation is a company engaged in system engineering services. A high-level group of engineers provides services in areas such as big data, cloud, AI, finance, retail, infrastructure development, and system development. In addition to engineering services, we offer consulting focused on realizing our clients' management strategies and business transformations, as well as services centered on business operations and system operations, creating new value that advances society.
