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 […]
Dear Readers, Trust you are doing well & safe!!! In this post we are going to discuss about weird issue I faced for a user account in Active Data Guard (ADG) environment. A user was receiving “ORA-28000: the account is locked” while connecting to ADG environment from SQL Developer. When […]
Dear Readers, Recently one of my clients facing weird issue, wherein some of application jobs were timing out. He raised a incident with us to check everything is fine from DB end. After checking active database sessions, I found some of update queries were having wait event “enq: TM – […]
Dear Readers, Recently while working with one of my clients, I came across a requirement of creating graphical representation of DB growth in last few months. Ofcourse this is possible using excel graphs, I thought of achieving this using python programming. So I am writing this post on creating graphical […]
Adityanath's Oracle Blog 