No, they are not "SNIPED"; I've worked with those before.
They are in fact all "INACTIVE". I suspect they are waiting on the
client for their next messages. As for your 2nd question:
I've got 7 users with the DBA role on this database! Why?
I'm too new here to ask. I view them as users/support personnel.
Kurt
-----Original Message-----
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 01, 2003 11:34 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: MTS v$session
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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
