Problem Statement The Application team reported performance slowness and observed intermittent transaction declines. They confirmed that the slowness was due…
Problem Statement The Core Banking Database has undergone a 19c upgrade. Following the upgrade, the application has experienced severe intermittent…
Problem Statement The application team has reported a recurring transaction timeout occurring every Thursday at 9:00 PM. This issue persists for…
Problem Statement The database upgraded to Oracle version 19c. However, on a regular working day evening, the application team noticed…
Problem Statement The application team has informed us that they encountered difficulties initiating a transactional SMSALERT job. In initial examination,…
Problem Statement Database had been migrated to new setup. Post migration, as business load increased “latch free” events started surfacing…
Problem Statement Application team informed us about the regular EOD jobs not progressing as expected. Diagnosis Application team was executing…
Problem Statement Production database was hosted on a 6 Node RAC setup and used for PeopleSoft application. Dataguard configured with LOCAL…
Problem statement Database is recently upgraded to 12.1.0.2 version. After few days, database started terminating with ORA-04031 error consistently. Excerpts…
Problem Statement On EXADATA machine, after initiating archivelogs backup in the database, application started facing connectivity issues. Even from local server connection…