Jared,
If you look in V$process and V$session you'll see that there are only a
limited number of processes and that as you surmised the dispatcher points back
to the idle sessions it is dealing with. Now if the session becomes active that
changes to the shared server doing the work. And if the session connects via
dedicated server, from yesterday's thread, then it's as you know it today
without MTS.
Dick Goulet
____________________Reply Separator____________________
Author: [EMAIL PROTECTED]
Date: 5/17/2002 9:13 AM
Hey list,
It's been awhile since I've used MTS, and some questions have come
up regarding it.
The question revolves around sniped sessions, and the need to
remove these things automatically in some systems, since they
consume resources. Such as a DW where sessions may not
be created very frequently.
Doing this with dedicated servers is no problem.
Doing so with MTS is another matter. When I kill a sniped session, I
first kill the OS process ( or thread ) and then kill the session, if it
is
still around. I kill the OS process first due to an infamous problem with
Oracle. When you kill a session that is holding locks, there's a chance
that this session will never go away until the DB is bounced. And it
continues to hold the lock until the DB is bounced.
I've had this happen on multiple versions of Oracle, on Solaris, DG/UX
and Windoze NT.
The question is: What is the process that appears in V$PROCESS for
an idle session that is connected via MTS? I'm guessing it's the
dispatcher. I don't have anyway to check this however.
Any help in this would be greatly appreciated.
Thanks,
Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
