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’ll be discussing one of Oracle’s standout features—a powerful tool for testing real-time performance without necessarily involving application teams. DRAWBACKS OF USING TRADITIONAL PERFORMANCE TESTING ADVANTAGES OF USING ORACLE REAL APPLICATION TESTING (RAT) LICENSING ORACLE REAL APPLICATION TESTING (RAT) OVERVIEW Utilizing Oracle […]
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. I am writing this post to share you sample shell script code which will help to remove all files under particular folder in quick time. This requirement normally comes when, we have to remove huge number of old files under folders which have […]
Dear Readers, Trust you are doing well. As mentioned in last post, In this post, I will be focussing on commands that we use with respect to in dictionary/fixed object stats gathering. This post can be considered as a one stop reference for dictionary & fixed object statistics gathering stuff. […]
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 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 […]
Adityanath's Oracle Blog 