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
What is your
maximum MTS servers?
-Original Message-From: Bunyamin Karadeniz
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 26, 2002
9:49 AMTo: Multiple recipients of list ORACLE-LSubject:
MTS performance is too bad.
I have changed my 8.1.7.3.2 database to MTS
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
Change back to dedicated servers.
Jared
Bunyamin Karadeniz [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
06/26/2002 09:49 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:MTS performance is too bad
by: [EMAIL PROTECTED]
06/26/2002 09:49 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:MTS performance is too bad.
I have changed my 8.1.7.3.2 database to MTS on win2000. But performance is
too bad.
I have 800