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

Category: Database Memory

“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

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

ORA-04031: unable to allocate 352 bytes of shared memory (“shared pool”,”unknown object”,”sga heap(1,0)”,”krsdicle”)

May 24, 2018 Dinesh Bandelkar 3 Comments

Problem statement Database is recently upgraded to 12.1.0.2 version. After few days, database started terminating with ORA-04031 error consistently. Excerpts…

Continue Reading

Posted in: Database Memory Filed under: Performance
Copyright © 2018-2024 Dinesh Bandelkar
 

Loading Comments...