Re: Does IPC help performance?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 23 Jul 1999 10:07:01 +0100
Message-ID: <932721154.171.3.nnrp-13.9e984b29@news.demon.co.uk>

Quick SQL to see which (background) processes regularly use 'rdbms ipc message':

select

        s.sid,
        p.name,
        e.total_waits
from
        v$session s,
        v$bgprocess p,
        v$session_event e
where
        s.paddr = p.paddr

and e.sid = s.sid
and e.event = 'rdbms ipc message'
;

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

akolk - gelrevision.nl wrote in message <37982F09.B6E4C2EF_at_gelrevision.nl>...
>The 'rdbms ipc message' is the idle event that some of the background
>processs will wait on. The IPC here is not the same IPC that we see or use
>on UNIX. The message that is waited on will be placed in the SGA by the
>foreground and then the foreground will post the background process . When
>the background process wakes up, it will check its message area in the SGA
>to see what message is there. Based on that message and the type of
>process, it will perform some action.
>
>Only the action based background processes will wait on 'rdbms ipc
>message'. pmon and smon are not action based and wait on their own idle
>event (pmon timer, smon timer). So you could say that rdbms ipc message is
>similar to pmon timer and smon timer.
Received on Fri Jul 23 1999 - 04:07:01 CDT