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.

others