Re: Does IPC help performance?

Background processes are always using ipc, but the values of ipc in v$dispatcher are all zero, is it a problem?

I have removed ipc from listener.ora and I can use sqldba to shutdown database and all pro*c programs run on server without problems.

Will the background processes use Beq if ipc isn't available?

Thank for any advice,
River
wychan_at_vol.net

Sybrand Bakker wrote:
>
> 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 - 18:40:01 CDT