Re: LOCAL=NO process

From: Ben Ryan <benryan_at_my-deja.com>
Date: Thu, 16 Sep 1999 00:08:49 GMT
Message-ID: <7rpce9$9s3$1@nnrp1.deja.com>

In article <7rogvi$n62$1_at_sloth.swcp.com>, Ed Lufker <elufker_at_inago.swcp.com> wrote:
> Hi All:
>
> What are these LOCAL=NO processes, and how do they get their sizes. I
have
> about 36 of them on my Solaris box and they are about 43M each.
>
> Thanks
> Eddie Lufker

Assuming you are not in a MTS environment, and that you refering to process like

ps -fuoracle

 oracle  7194     1  0 10:58:46 ?         0:43 oracleRB_DEV (LOCAL=NO)
 oracle  6747     1  0 09:24:51 ?         0:19 oracleRB_DEV (LOCAL=NO)
 oracle  7238     1  0 11:04:00 ?         0:31 oracleRB_DEV (LOCAL=NO)

where in my case RB_DEV is the Oracle SID.

Then these are what Oracle calls "server processes". For each session that connects to the database a dedicated "server" process is created. The LOCAL=NO bit is because the client is not running on the same computer. (In my case the clients are Windows PCs).

43Mb sounds large. Mine are nearer the 8Mb mark on average.

What version of the Oracle DB are you on? On HP there was a memory leak on 7.3.4.1.0, which kept blowing the 64Mb Unix process size limit. Problem was fixed when I moved to 7.3.4.4.

Ben

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Sep 15 1999 - 19:08:49 CDT