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

ORA-08103: object no longer exists

June 28, 2025 Dinesh Bandelkar 2 Comments

Problem Statement Disclaimer: You’re about to dive into our most detailed and complex diagnostic yet. Buckle up and read through…

Continue Reading

Posted in: Troubleshooting Filed under: database-administration

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 8 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

Post navigation

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

Loading Comments...