Re: Need help on MTS configuration

"NetComrade" <netcomradeNSPAM_at_bookexchange.net> a écrit dans le message de news:417963ca.959896898_at_localhost...
> 1) why are you migrating to MTS?

BNecause I expect some 1000 new users to connect to my database soon. Don't want 1000 more processes on my system

> 2) have you looked at v$session, to see if connections were actually
> made (where server='SHARED' or 'NONE')
All use dedicated servers, as my setup is not functional

> 3) have you looked at business of MTS processes, including dispatchers
> by looking @

The dispatcher is started but noone is able to connect to it. Si it's completely idle (0 requests).

>
> column name format a8
> column owned format 9999
> select name "NAME", substr(network,1,30) "PROTOCOL",
> status "STATUS", (busy/(busy + idle)) * 100 "%TIME BUSY",
> owned
> 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",status from v$shared_server;
>
> select maximum_connections "MAX CONN",
> servers_started "STARTED",
> servers_terminated "TERMINATED",
> servers_highwater "HIGHWATER" from v$mts;
>
> 4) have you looked at v$session_waits when the 'hang' occurs?
There were no session yet. The dispatcher would hang, that's all.

>
> For configuration issues, see metalink.
I have

Regards,

-- 
Syltrem

OpenVMS 7.3-1 + Oracle 8.1.7.4
http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
---zulu is not in my email address---