Having raised the SR yet there is no conclusion. The operating system and the device controller provide database caches, which do not directly conflict with the database cache management. I started this snippet with the sleep on the semaphore, after which the process writes the wait event information about this. This started all of a sudden the daily batch job used to complete in Hrs initially. Oracle should do a better job of documenting their wait events.
nest...