Oracle Performance Insights A Blog By Kamlesh Ambre

  🔔 Exciting News! 🔔 I'm thrilled to share that Oracle has just made a groundbreaking announcement that will surely benefit all technology professionals and cloud enthusiasts! Oracle has officially announced that they are offering FREE certifications for Oracle Cloud Infrastructure (OCI)! This is a game-changer in the world of cloud certifications. As the demand for cloud skills continues to skyrocket, Oracle has taken a bold step to empower individuals to enhance their expertise and stay ahead in the rapidly evolving technology landscape. By offering free OCI certifications, Oracle has opened up incredible opportunities for professionals to upskill, broaden their knowledge, and showcase their proficiency in Oracle Cloud Infrastructure. This move not only demonstrates Oracle's commitment to fostering a skilled and empowered cloud community but also reflects their dedication to supporting professionals on their career journeys. Obtaining an OCI certification will not only vali...

Introduction: In a complex Oracle Real Application Clusters (RAC) environment, unexpected issues can arise, leading to system instability and performance degradation. In this blog post, we will delve into a specific incident involving a CPU spike and resource hang that occurred during the execution of a high parallelism SQL job. We will analyze the root causes and explore potential solutions to mitigate such problems in the future. The Incident: On a particular day between 2:00 PM and 6:30 PM IST, an SQL job with a Degree of Parallelism (DoP) set to 200 was initiated on Node#3 around 2:12 PM IST. Soon after, the CPU Idle% dropped to single digits, reaching as low as 1% at 3:10 PM IST. This performance degradation led to Node#6 being evicted following a dirty detach reconfiguration. During the incident, it was observed that the shutdown process remained hung for an extended period, and the system was only restarted at 4:44 PM as per the Syslog. The Cluster Ready Services (CRS) stack cam...