Re: MTS performance is too bad.

Do consider setting large_pool_size. Here's a script to get you started. MTS has bugs under 8i where the dispatcher hangs, especially when connections use JDBC thin.

col name format a10
col network format a40
col status format a14

PROMPT *** MTS DISPATCHER STATISTICS *** select name,owned,status,

   (busy/(busy + idle)) * 100 "% busy"
from v$dispatcher
/

PROMPT *** MTS SHARED SERVER STATISTICS *** select name,status,requests,

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

PROMPT *** MTS QUEUE STATUS AND WAITS *** select paddr, type, queued, wait, totalq,

   decode(totalq,0,0,wait/totalq) "AVG WAIT" from v$queue
/

PROMPT *** CURRENT MTS CONNECTIONS ***
select s.username, c.dispatcher, c.server, c.status from v$circuit c, v$session s
where c.saddr = s.saddr
/

PROMPT *** MTS STATISTICS ***
select maximum_connections max_conn,

       servers_started, servers_terminated, servers_highwater from v$mts
/

> Bunyamin Karadeniz wrote:
>
> I have changed my 8.1.7.3.2 database to MTS on win2000. But
> performance is too bad.
> I have 800 MB of shared pool and not setted large_pool_size.
> 50 dispathers, 100 processes and 750 max processes.
>
> What can I do ? Have you got an idea. How can I check the mts
> performance?
>
> Bunyamin

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Suzy Vordos
  INET: lvordos_at_qwest.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).