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).
RE: MTS v$session
Title: MTS v$session Hi Kurt, Have you set the sqlnet.expire_time in the sqlnet.ora file? N. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Wiegand, KurtSent: 01 August 2003 16:19To: Multiple recipients of list ORACLE-LSubject: MTS v$session 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
RE: MTS v$session
Title: MTS v$session Yes; at least on the server side. # SQLNET.ORA Network Configuration File: /u01/app/oracle/product/817/network/admin/sqlnet.ora# Generated by Oracle configuration tools.#NAMES.DIRECTORY_PATH= (TNSNAMES)SQLNET.EXPIRE_TIME= 10 -Original Message-From: Nuala Cullen [mailto:[EMAIL PROTECTED]Sent: Friday, August 01, 2003 12:34 PMTo: Multiple recipients of list ORACLE-LSubject: RE: MTS v$session Hi Kurt, Have you set the sqlnet.expire_time in the sqlnet.ora file? N. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Wiegand, KurtSent: 01 August 2003 16:19To: Multiple recipients of list ORACLE-LSubject: MTS v$session 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
RE: MTS v$session
Title: RE: MTS v$session 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).
RE: MTS v$session
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).
RE: MTS v$session
Title: MTS v$session First question I would have is Why does a user have access to V$SESSIONS in the first place? Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Wiegand, Kurt [mailto:[EMAIL PROTECTED]Sent: Friday, August 01, 2003 11:19 AMTo: Multiple recipients of list ORACLE-LSubject: MTS v$session 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