Re: Does IPC help performance?

On Thu, 22 Jul 1999 22:17:14 +0800, River <wychan_at_vol.net> wrote:

>Some questions about ipc:
>
>1. What is the bad effect after removing ipc from listener?
>
>2. When select * from v$system_event, at "rdbms ipc message",
> the value of TOTAL_WAITS and TOTAL_TIMEOUTS
> are nearly same and high, is it a problem?
>
>3. Do internal process or background process use ipc if available?
>
>Configuration:
>Oracle 7.1.6 NCR Unix 512MB RAM
>
>Thank for any advice,
>River
>wychan_at_vol.net

1. You won't be able to connect as a 'local' user anymore, so you won't be able to stop the database, unless you set remote_os_authent = true and the other usual measures.
2. When I was working on Unix sites, my number of waits for RDBMS IPC messages was always high. Research showed it shouldn't be a problem. However, I'm a bit anxious about it too 3 background processes are ALWAYS using IPC.

Hth,

Sybrand Bakker, Oracle DBA Received on Thu Jul 22 1999 - 12:27:54 CDT