okay that sounds a lot like the connection got broken (PC turned off,
sqlnet expire time, which I see you've set, etc) badly
being a "newbie" is the perfect time to ask. You can sound totally
innocent ("I was just wondering how you have things set up here")
--- "Wiegand, Kurt" <[EMAIL PROTECTED]> wrote:
> 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-----
> Sent: Friday, August 01, 2003 11:34 AM
> To: Multiple recipients of list ORACLE-L
>
>
> 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).
>
__________________________________
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).
