Re: What does [local=NO] mean for oracle process?

From: Ban Spam <ban-spam_at_operamail.com>
Date: Tue, 09 Oct 2001 01:33:52 GMT
Message-ID: <Xns9134BCD8B4714SunnySD@24.0.3.73>

"jameswan" <jameswan_at_email.msn.com> wrote in news:#adxGpEUBHA.1588_at_cpimsnntpa03:

> When I check the oracle server process on unix with ps -ef | grep
> oracle, I saw lots of oracle[instance_name] with [LOCAL=NO], could any
> expert tell me what this means, and why there are many processes of the
> same thing?
>
> Thanks.
> -James W.
>
>
>

Those are remote client processes which have connect to your Oracle (DB) server. On my production box I typically have 1000 - 1400 at any point in time. Received on Mon Oct 08 2001 - 20:33:52 CDT