Re: MTS tuning

On Wed, 15 May 2002 19:16:04 +0530, "Pinto" <ucanmailme_at_india.com> wrote:

>Hello All,
>Recently we started testing our application after changing our Database from
>dedicated sever mode to MTS.

Why did you decide to move from dedicated to MTS?

>
>
>my question is, why aren't all the server process equally busy? looks like,
>the first 5 server processs are very busy and the others are not. is there
>anyway where we can ensure that all the server process is equally loaded. or
>is this the expected behaviour?

Means pretty much that you only need 5 servers for most of the stuff. Servers aren't picked in round robin, afaik, if S000 isn't busy, it'll take the request, if not S001, and so on

>select maximum_connections "MAX CONN",servers_started "STARTED",
>servers_terminated "TERMINATED",servers_highwater "HIGHWATER" from v$mts
> MAX CONN STARTED TERMINATED HIGHWATER
> -------------- ----------- ----------------- ---------------
> 168 0 0
>20

this is good. means no server was 'forced' to be started b/c you were running out of 'power' (see utilization from previous query, if they were all close to 100% at least at certain part since the start of the DB, some servers might have been started, and later removed)

>
>we have also found that, after switching to MTS, our CPU usage has almost
>doubled! and certain applications have slowed down. is it expected or am i
>missing out something.

this is weird.. usually it only adds 5-10% extra overhead.

>also
>
> 1 select p.spid thread, s.username,
> 2 decode(nvl(p.background,0),1,bg.description, s.program )
>program,
> 3 ss.value/100 CPU,physical_reads disk_io from v$process p,
>v$session s,
> 4 v$sesstat ss, v$sess_io si, v$bgprocess bg where
>s.paddr=p.addr
> 5 and ss.sid=s.sid and ss.statistic#=12 and si.sid=s.sid
> 6* and bg.paddr(+)=p.addr order by ss.value desc
>20:25:50 SQL> /
>
>THREAD USERNAME PROGRAM CPU
>--------- ------------------------------ -------------------- ----------
> DISK_IO
>----------
>2028 NETMSQLUSERS ans.exe 69.51
> 16869
>
>2028 DBO Bctsched.exe 65.46
> 2008
>
>1512 DBO Bctsched.exe 60.47
> 163
>
>2028 DBO CVCache.exe 32.12
> 0

what do this applications do?
.......
We use Oracle 8.1.7.3 on Solaris 2.7 boxes remove NSPAM to email Received on Wed May 15 2002 - 15:52:48 CDT