Hello Nenad,
=> So if I've understood correctly, you're suggesting that the MMAN might
have waited on a semaphore held by some other process?
=> But then why ORA-04031 flood, in the first place? According to the system
dump there was plenty of free memory to fulfill the request, at least at some
point. The scenario of not being able to find consecutive 40 bytes seems
rather unlikely.
Noveljic Nenad <nenad.noveljic@xxxxxxxxxxxx> hat am 25. Juli 2019 um 15:39--
geschrieben:
Hello Stefan,
"have you checked the involved semaphore(s) for/with OS PID 26758?
=> Unfortunately, the information about the semaphores wasn't collected.
Unluckily, it was a one-off problem so it's quite unlikely that we'll ever
get a second chance to capture this information.
"Was it running on the default time-out or was there also another PID
involved (ipcs -si)?"
=> So if I've understood correctly, you're suggesting that the MMAN might
have waited on a semaphore held by some other process?
" so the wait only happens after session ran into ORA-4031."
=> But then why ORA-04031 flood, in the first place? According to the system
dump there was plenty of free memory to fulfill the request, at least at some
point. The scenario of not being able to find consecutive 40 bytes seems
rather unlikely.
Best regards,
Nenad
https://nenadnoveljic.com/blog/