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!!! 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 […]
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 […]
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 […]
Dear Readers, Yesterday one of my friend pinged with the requirement of generating muliple AWR reports for every 1 hour using single command. This particular database has SNAP_INTERVAL set to every 15 minutes. He had already referred one of my old post given below, which helps us generating muliple AWR […]
Adityanath's Oracle Blog 