Hello Readers, Trust you are doing well. Today, I am going to discuss an interesting issue we encountered in one of our 4-node RAC production databases. We observed a session spike that lasted for a couple of minutes and then resolved itself automatically. As this incident only caused brief disruption […]
Dear Readers, Trust you are doing well. In my last post, I focused on RAT preprocessing. Now, let’s dive into the RAT replay process, which is executed on the pre-production or target system to simulate the captured workload. Once a workload is captured and preprocessed, it can be replayed multiple […]
Dear Readers, Trust you are doing well. In my last post, I foucssed on RAT capture process. In this post, I’ll delve into the process of preprocessing RAT workloads. This post will provide insights into key considerations, best practices, and essential MOS notes for RAT preprocessing. WHAT IS PREPROCESSING?: After […]
Dear Readers, Trust you are doing well. In my last post, I foucssed on overview of RAT testing process. In this post, I’ll delve into the process of capturing RAT workloads. This post will provide insights into key considerations, best practices, implementation strategies, and essential MOS notes for RAT capture. […]
Dear Readers, Trust you are doing well. Today I am going to write about interesting issue I faced recently on one of critical 3 node RAC DB, wherein one of DB instance crashed & while it was rejoining cluster another instance crashed. This situation created a lot of panic in […]
Dear Readers, Trust you are doing well!!! In this post, I will discussing about critical issue, I faced recently wherein RMAN compressed backup started taking significant time post changing compatible parameter from 12.1.0.2 to 19.0.0. Normally RMAN L0 compressed backup of DB size 70+ TB used to take approx 10 […]
Dear Readers, Trust you are doing well!!! In this post, I will discussing about an interesting issue I faced recently on one of the database setups, wherein we received incident about generic performance issue. This database was recently created for reporting purpose. Though no specific errors seen in database, application […]
Dear Readers, Trust you are doing well!!! In this post, I will discussing about an interesting issue I faced recently on newly installed 19c 4 node RAC cluster, wherein DB startup using command “srvctl startup database” was taking significant time. Each DB startup took around 15-20 minutes, sometimes more than […]
Dear Readers, Trust you are doing well, Today I am writing this post related to recent issue which we faced on one of the critical database post switchover to standby site. When I was checking AWR comparison reports to do some sanity checks, I found write IO statistics were increased […]
Dear Readers, Trust you are doing well, Today I am writing this post related to recent issue which I faced after DB upgrade to 19c. We saw sudden increase in waits for event “Enq: HW – contention” wherein HW stands for High Watermark not Hardware 😉 Lets start with some […]
Adityanath's Oracle Blog 