Title: 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
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
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
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
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
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]
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