Friday 26 February 2016

RDBMS IPC Message


Possible Causes:

It is typical of Oracle Database background processes to wait for more work.

For example, (LGWR,DBWr,LMS0) will wait for more work until another (foreground or background ) process request LGWR to do a log flush. In UNIX platforms, wait mechanism is implemented as a sleep on a specific semaphore associated with that process. This wait time is accounted towards database wait events ‘rdbms ipc message’. Also note that, semaphore based waits are used in other wait scenarios too, not just ‘rdbms ipc message’ waits.

No comments: