We run pre-spawned processes for a Web application that issues many
connections. It works great !!!
Thomas Kyte wrote in message <356b5008.13892786_at_192.86.155.100>...
>A copy of this was sent to "Pierre" <proussin_at_tactik.com>
>(if that email address didn't require changing)
>On Thu, 21 May 1998 14:41:25 GMT, you wrote:
>
>>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).
>
>No, not really. This is one class of users who can use it but the other
class
>of users are OLTP type applications where any given statement the client
>application uses takes ones of seconds or less.
>
>MTS works like a multiplexer. Many users will share a single dedicated
server
>(a shared server process). The shared server is monopolized by a single
user at
>a time (hence the request that statements take ones of seconds or less).
If you
>have 100 users who each spend only 10% of their time in the database and
the
>other 90% is think time looking at data, you can get away with a very small
>number of shared servers to service all of their needs. Instead of 100
>dedicated servers, you might have 5 or 10 shared servers in this
environment.
>
>>It can't be used
>> with FORMS or REPORTS.
>
>No true at all. Forms can make excellent use of MTS due to the fact that
most
>forms SQL statements take a very short time to execute (mostly simple
SELECTs
>against 1 table, single row insert/update/deletes). Forms works very well
with
>MTS.
>
>Reports -- due to the fact that you probably have long running queries in
there,
>might not be as good a candidate for MTS but there is nothing saying that
it
>isn't either. It depends on how the application uses the database.
>
>>The whole idea of using MTS is to minimize
>>the CPU
>> activity produced by the forking of childs.
>
>Thats only part of it. That is what PRESPAWNING servers would do (sql*net
>option to prespawn servers, thats the only thing it does). MTS also
reduces the
>number of processes on the system at any point in time by sharing a single
>server with many users.
>
>> 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
>>
>
>
>Thomas Kyte
>tkyte_at_us.oracle.com
>Oracle Government
>Herndon VA
>
>http://govt.us.oracle.com/ -- downloadable utilities
>
>---------------------------------------------------------------------------
-
>Opinions are mine and do not necessarily reflect those of Oracle
Corporation
>
>Anti-Anti Spam Msg: if you want an answer emailed to you,
>you have to make it easy to get email to you. Any bounced
>email will be treated the same way i treat SPAM-- I delete it.
Received on Fri May 22 1998 - 10:05:41 CDT
