Re: MTS v$session

2003-08-01 Thread Rachel Carmichael
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

2003-08-01 Thread Nuala Cullen
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

2003-08-01 Thread Wiegand, Kurt
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

2003-08-01 Thread Wiegand, Kurt
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

2003-08-01 Thread Rachel Carmichael
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

2003-08-01 Thread Goulet, Dick
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