Re: How to know that my MTS configuration is working ?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 20 Sep 2001 00:37:33 -0700
Message-ID: <a20d28ee.0109192337.4fa84dc1_at_posting.google.com>

scott_tiger75_at_hotmail.com (Scott) wrote in message news:<53ad92d4.0109191317.798c4ba5_at_posting.google.com>...
> Greetings to all DBAs,
>
> I've configured MTS on my Oracle 8.1.6 database.
>
> But I'm not sure that it is using MTS to connect.
>
> How could I check that ?
>
> Could anyone help me on this one ?
>
> Many thanks.
> Cheers.
>
> Scott

check v$session. It will show in the server column either 'dedicated' (the default) or 'shared', which is MTS. You can also check v$session_connect_info and v$shared_server. As a basic check lsnrctl status should show you whether the dispatcher is actually running.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Thu Sep 20 2001 - 09:37:33 CEST

This message: [ Message body ]
Next message: godmann: "Re: character sets and varchar/nvarchar"
Previous message: Sybrand Bakker: "Re: Installing Oracle 8i with Developer 6 or 6i on WIndows 2000 Profesional Edition"
In reply to: Scott: "How to know that my MTS configuration is working ?"
In reply to Scott: "How to know that my MTS configuration is working ?"
Next in thread: godmann: "Re: character sets and varchar/nvarchar"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message