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