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 […]
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 […]
Adityanath's Oracle Blog 