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 […]
As the clock strikes midnight, may you find new reasons to smile and new reasons to love. Wishing you a New Year filled with joy, laughter, and endless possibilities. May 2024 be your best year yet! Photo by Jill Wellington: https://www.pexels.com/photo/happy-new-year-text-3334355/
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. As you already aware, object statistics play a very important role in optimizer in choosing optimal execution plan for any query. In this post, I will be focussing on commands that we use with respect to in stats gathering. This post can be […]
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 […]
Adityanath's Oracle Blog 