Skip to content
Debugging Oracle Performance
A blog by Dinesh Bandelkar
  • Home
  • Cloud
    • OCI
  • New Features
    • Oracle 23ai
    • Oracle 19c
    • Oracle 18c
  • Administration
    • RAC
  • Performance
    • Troubleshooting
    • Database Memory
    • DataGuard
    • RMAN
  • Exadata
    • Maintenance
  • About

Author: Dinesh Bandelkar

db file sequential read

December 12, 2024 Dinesh Bandelkar 1 Comment

Problem Statement Support team reported a performance issue affecting one of the critical application. According to their update, end users…

Continue Reading

Posted in: Oracle 19c Filed under: Performance

Disk file operations I/O

July 17, 2024 Dinesh Bandelkar 5 Comments

Problem Statement The Application team reported performance slowness and observed intermittent transaction declines. They confirmed that the slowness was due…

Continue Reading

Posted in: Oracle 19c Filed under: Performance

Oracle 23ai : True Cache

July 7, 2024 Dinesh Bandelkar 7 Comments

Unveiling Oracle True Cache True Cache is an in-memory, read-only cache that sits in front of an Oracle database. Similar…

Continue Reading

Posted in: Oracle 23ai Filed under: New Features

Oracle AI Vector Search : Demonstration

June 23, 2024 Dinesh Bandelkar 2 Comments

Oracle AI Vector Search is designed for Artificial Intelligence (AI) workloads and allows you to query data based on semantics,…

Continue Reading

Posted in: Oracle 23ai Filed under: New Features

Database Resident Connection Pooling (DRCP)

November 21, 2023 Dinesh Bandelkar 1 Comment

Problem Statement The Core Banking Database has undergone a 19c upgrade. Following the upgrade, the application has experienced severe intermittent…

Continue Reading

Posted in: Oracle 19c Filed under: Performance

ORA-00018: maximum number of sessions exceeded

November 2, 2023 Dinesh Bandelkar 3 Comments

Problem Statement The application team has reported a recurring transaction timeout occurring every Thursday at 9:00 PM. This issue persists for…

Continue Reading

Posted in: RMAN Filed under: Performance

“latch: shared pool”, “library cache: mutex X” & “library cache load lock”

October 21, 2023 Dinesh Bandelkar 3 Comments

Problem Statement The database upgraded to Oracle version 19c. However, on a regular working day evening, the application team noticed…

Continue Reading

Posted in: Database Memory Filed under: Performance

“ORA-23422”: Oracle Server could not generate an unused job number

October 15, 2023 Dinesh Bandelkar 8 Comments

Problem Statement The application team has informed us that they encountered difficulties initiating a transactional SMSALERT job. In initial examination,…

Continue Reading

Posted in: Troubleshooting Filed under: Performance

latch free waits on “FOB s.o list latch”

July 26, 2022 Dinesh Bandelkar 8 Comments

Problem Statement Database had been migrated to new setup. Post migration, as business load increased “latch free” events started surfacing…

Continue Reading

Posted in: Database Memory Filed under: Performance

CARDS Application EOD stuck with “library cache pin”

July 19, 2022 Dinesh Bandelkar 12 Comments

Problem Statement Application team informed us about the regular EOD jobs not progressing as expected. Diagnosis Application team was executing…

Continue Reading

Posted in: Database Memory Filed under: Performance

Post navigation

Page 1 of 2
1 2 Next →
Copyright © 2018-2024 Dinesh Bandelkar
 

Loading Comments...