Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> interpret v$mts
Dick (if you're out there) or someone who understands
this mts stuff:
We're still having problems with slowness. I know you told me to just keep adding servers till the screaming stopped. I didn't listen too carefully. . .
I'm wondering if you can tell me if I'm interepreting this correctly. mts_servers is set to 30. At 10:09 this morning, my servers_highwater was 34. Here's select * from v$mts at 10:09
MAXIMUM_CONNECTIONS : 894 MAXIMUM_SESSIONS : 893 SERVERS_STARTED : 4 SERVERS_TERMINATED : 4 SERVERS_HIGHWATER : 34
-----------------
at 10:49, looked like this:
MAXIMUM_CONNECTIONS : 936 MAXIMUM_SESSIONS : 936 SERVERS_STARTED : 37 SERVERS_TERMINATED : 37 SERVERS_HIGHWATER : 52
-----------------
So does that mean that in 40 minutes, it started 33 servers? If so, isn't that, like, obscene??
I assume there's overhead associated with starting up these servers. Should I be setting mts_servers to something extremely high (like around 50)? It was within this 40 minutes that we saw extreme slowness. I don't know if I'm looking cause or effect, but it seems pretty strange to me that we needed an additional 30 servers in a 40 minute period.
Thanks for any advice on this one.
Barb
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlReceived on Fri May 28 2004 - 16:38:54 CDT
-----------------------------------------------------------------