Dear Readers, Trust you are doing well!!! In this post I will be providing you shell/bash script to create dynamic DDL script for all non-default Oracle schemas/users in Oracle DB. This is very helpful when we need to export/import multiple schemas from source to empty target database. Script has been […]
Dear Readers, Trust you are doing well!!! Today I am going to write about interesting feature being introduced in Oracle version 12.2 & widely used in 19c. Multi-Instance Redo Apply(MIRA) Basically Oracle has different ways to apply redo on standby site. SIRA: Single Instance Redo Apply ==> Wherein MRP runs […]
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 […]
Hello Readers, Trust you are doing well!!!! A day well spent @ #ocyatra2022 !!!!!! Thanks so much Sai Penumuru , All India Oracle Users Group (AIOUG) for organizing this wonderful event !!!! Awesome sessions by Sandesh Rao Mike Dietrich Connor McDonald Jim Grisanzio Mandar Modak Veeratteshwaran Sridhar Aishwarya Kala (she/her) […]
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 […]
Dear Readers, Trust you are doing well!! Today I am going to write about issue I recently faced during running TFA for collecting SRDC regarding the performance issue I was working on. These TFA files were requested by Oracle global support for investigation purpose. I used below command for collecting […]
Dear Readers, Trust you all are doing well. In this post I would be discussing about an issue, we observed during RAT replay test after upgrading our database on 19c. There was considerable increase in wait time for the event “latch: shared pool” post DB was upgraded to 19c, which […]
Finally received my first Oracle ACE program gift after waiting for almost a year 🙂 & I wear it with pride!!!! Thank you so much @oracleace & @jen_s_nicholson !!! @Oracle @AIOUG #oracledatabase #oracledba #oraclecloud #oracleace #oracledatabaseworld #thankyou #oracle
Dear Readers, Recently I was working on one of the projects wherein a requirement was to compare two DB schemas (Both structure and data) & synchronize it. Requirement was as follows: Current application version is 1.0. It is using schema S_APPS in Oracle database as a backend. New upgrade pack […]
Dear Readers, In this post, I am going to write about the issue I faced while patching GI HOME with July 2021 OJVM patch(32876380) post applying July 2021 GI RU patch(32904851). I had a requirement to apply patch 32900083 (GI RU & OJVM Combo July 2021) on GI HOME, which […]
Adityanath's Oracle Blog 