Re: Oracle Multi-Threaded Server

From: Pierre <proussin_at_tactik.com>
Date: Thu, 21 May 1998 14:41:25 GMT
Message-ID: <p2X81.904$bh7.728825@news21.bellglobal.com>

Hi,

        I've been using multi-thread for a while. There is no overhead on the system. In the

        contrary, it will alleviate the forks executed by sql*net everytime a user connects.

        Multi-thread is only good for short transactions with no idle time (CONNECT,

        EXECUTE TRANSACTION, DISCONNECT). It can't be used
        with FORMS or REPORTS. The whole idea of using MTS is to minimize
the CPU
        activity produced by the forking of childs.
        If some users are using FORMS and REPORTS they can still connect
through
            the same listener by setting a parameter in their tnsnames.ora

file (SERVER=DEDICATED)

        CIAO Pierre
yossiz_at_amdocs.com wrote in message <6k1495$q2q$1_at_nnrp1.dejanews.com>...
>Does any one have experience with Multi-Threaded Server of Oracle 7.3 or
>Oracle 8 on AIX?
>
>Any known problems?
>
>What are the overheads of this configuration?
>
>Thanks in advance.
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Thu May 21 1998 - 09:41:25 CDT