Re: MTS server - reliability ?

We've got users all over the city - 160 sites and all are connected to our network.

I am not up on network configuration issues, and I honestly can't remember the exact setup of our "old" WAN network (which many sites are still on). But most sites using our Oracle-based School Management System have moved over to our Sonet ring.

We have had no problems with MTS. We have Oracle profiles set with limits, so inactive users get 'SNIPED' by Oracle. And when I kill a session manually, it's very quick. And which network they're on does not seem to matter. Our old WAN is slower, but connections seem to be just as good.

We just have the occasional lock problem once in a while, but we have not had any major locking problems since we put indexes on all parent columns for foreign keys.

Once in a while a user freezes up and I have to kill their session. This is currently happening less than once a day on average. It's really quick - no problems, just a few seconds and their sessions are killed. In the last two months, I have had perhaps two "kill sessions" take longer than 5 seconds.

Kent

>
>Hi Kent..
>
> Are ur users on WAN?
>We are facing huge problems with MTS on users on WAN!
>
> Particularly when connection drops and the user's session cannot be
>terminated
> within 15 minutes!! (alter system kill takes almost a couple of hrs )
>
> and if the user is not killed, he puts the same transaction and we find
>the object locked!!!
>
> Can you pls tell how u handle this!
>
>
>Works fine for us. We have used it on:
>
>Oracle 7.3.4 on HP-UX 10.20
>Oracle 7.3.4. on HP-UX 11.0
>Oracle 8.0.5 on HP-UX 11.0
>
>And we will shortly be testing it on Oracle 8.1.5 on HP-UX 11.0
>
>Our init.ora parameters are set to
>
>mts_dispatchers="tcp,4"
>mts_max_dispatchers=5
>mts_servers=70
>mts_max_servers=140
>
>We currently have about 2,000 users defined, and will grow to around 9,000.
>
>We usually have less than 500 connections at one time.
>
>
>Kent Wayson
>Milwaukee Public Schools
Received on Fri Jun 09 2000 - 08:32:20 CDT