Re: MTS v$session

From: Rachel Carmichael <wisernet100_at_yahoo.com>
Date: Fri, 01 Aug 2003 07:34:25 -0800
Message-ID: <F001.005C83F6.20030801073425@fatcity.com>

did you look at the status column in v$session for the ones that don't match?

IIRC, there can be a status of "SNIPED" where the session is not actually connected but has not been cleaned up.

curiosity -- why is a user looking at v$session? --- "Wiegand, Kurt" <Kurt.Wiegand_at_CWUSA.COM> wrote:
> I've got an 8.1.7.4.0 instance running under Solaris 2.8.
>
> I've never worked with MTS before, but got a call from a user telling
> me that there
> were about 700 rows in v$session but they only had about 130 sessions
> open.
> The user believes that when the session is ended, v$session doesn't
> (or doesn't always)
> get cleaned up. Does anyone have any insight into this? Thanks.
>
> I checked v$process and had about 89 rows, which matched exactly to
> the 89 unix processes that I had on the box.
>
> I looked at paddr in v$session and saw that there were just over 100
> rows pointing to each of the 6 dispatchers.
> The other rows each had their own dedicated process.
>
> I checked v$dispatcher and saw the 100+ values in the OWNED column,
> but also saw values between 300 - 450 in
> the CREATED column.
>
> I really don't know whether the application ends it's connections
> gracefully or nongracefully.
>
> Kurt Wiegand Cable & Wireless Communications 703 292-2115
>
>

---

Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Aug 01 2003 - 10:34:25 CDT