RE: wield session and process number???

You probably need to post partial result of the join with selected columns to give us something to look at.

Do you use shared_server, PQO, ...?

• Mark D Powell -- Phone (313) 592-5148

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dba1 mcc Sent: Friday, August 21, 2009 1:51 PM
To: oracle-l_at_freelists.org; BrandonAllen Subject: RE: wield session and process number???

NO. LINUX system still show 99:

ps -ef | grep DB01 | grep -v LOCAL|wc -l 99

• On Fri, 8/21/09, Allen, Brandon <Brandon.Allen_at_OneNeck.com> wrote:

> From: Allen, Brandon <Brandon.Allen_at_OneNeck.com>
> Subject: RE: wield session and process number???
> To: "dba1 mcc" <mccdba1_at_yahoo.com>, "oracle-l_at_freelists.org"
> <oracle-l_at_freelists.org>
> Date: Friday, August 21, 2009, 1:49 PM Did you try checking the status

> in v$session - maybe 66 of them are 'KILLED'?
>
>
>
> Privileged/Confidential Information may be contained in this message
> or attachments hereto. Please advise immediately if you or your
> employer do not consent to Internet email for messages of this kind.
> Opinions, conclusions and other information in this message that do
> not relate to the official business of this company shall be
> understood as neither given nor endorsed by it.
>
      

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l