Re: Doubts about MTS

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Tue, 01 Feb 2000 19:32:40 GMT
Message-ID: <38972bb4.432802948@news.earthlink.net>

Dispatchers make connections to servers, servers execute the SQL. You might have more then one service handler for different protocols, or if your dispatchers are too busy
You can use the following queries for statistics:

   select name "NAME", substr(network,1,15) "PROTOCOL",

      status "STATUS", (busy/(busy + idle)) * 100 "%TIME BUSY"

      from v$dispatcher;

 select paddr,type,queued,wait,totalq,                               
         decode(totalq,0,0,wait/totalq) "AVG WAIT" from v$queue;   

select name "NAME", paddr,requests,

 (busy/(busy + idle)) * 100 "%TIME BUSY" from v$shared_server;

select maximum_connections "MAX CONN",

 servers_started "STARTED",

 servers_terminated "TERMINATED",

 servers_highwater "HIGHWATER" from v$mts;

On Thu, 27 Jan 2000 14:00:03 +0100, Julio <julio.negueruela_at_si.unirioja.es> wrote:

>I've just implemented the multithread Server in one of our databases and after
>seeing how it work, I've got a few doubts about it:
>
> Before starting up an instance I've started the listener, having one service
>handler for my database. When I start it up I see that I've got two service
>handlers, just one for the dispatcher. Almost every user connects through
>sql*net to my database so:
>
> Why do we need one service handler appart from the dispatcher?
> If so, what determines a user to connect through the dispatcher or not?
> If I connect in local mode, will I do "throug" the dispatcher?
>
>I know some terms aren't totally corrects but my English isn't as good I'd like.
>:-(
>
>Thanks in advantage.
>--
>Julio Negueruela
>
>'Hay algunas cosas que son tan serias
>que solo puedes bromear con ellas.' (Bohr)

---

In case I forgot to mention:
We use Oracle 7.3.4 on Solaris 2.6, 2.7 boxes

---

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 750-3630
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email

Received on Tue Feb 01 2000 - 13:32:40 CST