Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: MTS oracle 8.1.7

Re: MTS oracle 8.1.7

From: <kennethkoenraadt_at_no-spam.hotmail.com>
Date: Mon, 16 Sep 2002 18:30:29 GMT
Message-ID: <3d86227e.429717@news.mobilixnet.dk>

On Mon, 16 Sep 2002 18:26:52 +0100, "MT" <mtechera_at_wpmc.com> wrote:

>Thank you for the help Richard and Kenneth!
>
>I was able to confirm that MTS is on, as you suggested but
>unfortunately it is not clear if it is necessary or not
>for it to remain turned on
>(I am playing the role of an assistant here).
>
>
>One follow up question:
>
>Is there any way to determine if any of the current session are
>coming from the MTS dispatcher by looking at some of the
>DBA_ views? Or would this have to be done by looking at the OS processes?
>
>Thanks again!
>
>Mario

Hi Mario,

Try :

select sid,serial#,username,SERVER
from v$session
where username is not null

The SERVER column shows either "DEDICATED" or "SHARED", the last one indicates a MTS connection.

Received on Mon Sep 16 2002 - 13:30:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US