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).
