RE: wield session and process number???
Date: Fri, 21 Aug 2009 14:56:51 -0400
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
[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"
> 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.