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

Scott wrote:
>
> 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 ?

   SELECT * FROM v$session
   WHERE server <> 'DEDICATED'

Valery Yourinsky

-- 
Oracle8 Certified DBA
Moscow, Russia