Re: Is MTS reliable with Oracle?

Performance / stability tips:

1.) Simply use MTS as an object broker - do not use distributed

      transactions unless working with multiple databases, as this
      results in serialization. As any performance tuning specialist
      can tell you - serialization is bad. (Note: this advice holds true
      regardless of which DBMS you choose.)

2.) Build a server farm for your middle-tier. Depending on how
      you construct your objects and tune the Oracle server you will
      need up to 20 MTS servers to support 1000 users concurrently
      in call.

3.) Use Oracle Objects for OLE - the most stable and scalable sites
      are using this layer.

4.) Avoid OO-purism in your MTS components. I have observed an
      infrequent occurrences of ORA-02045 - roughly 1 in 20,000
      trace files contains this in a production environment. With my
      implementation (and religious object cleanup) this should not
      be possible. It appears that connection pooling is handing out
      new connections instead of using the one already enlisted in
      the distributed transaction.

      Note: after recoding to purge the Duwamish-style DAL this
      error has been totally eliminated.

5.) Avoid MDAC 2.5 at this time. My latest tests resulted in several
      thousands of ORA-02042 errors. You can bump up the param in
      your Oracle server init file to delay the start of the problem.

      Note: the ORA-02042 will only occur in a heavily utilized shop. If
      your application experiences only moderate usage, then the issue
      will not be observed.

6.) Create your tables with adequate freelists - working with Oracle
      Support we determined that 20 is a good number for tables that
      experience high contention.

You can make the MTS / Oracle solution work, but be prepared for a learning experience. Prototype and benchmark early.

Mike

Faizul Hamid wrote in message <8abfcs$hb3$1_at_news.gov.on.ca>...
>I am interested to hear from those that have Microsoft Transaction Server
>working with Oracle 7.3/8 in a production environment. I have followed
 the
>knowledge base articles and was successful in getting MTS to work with
>Oracle, and more importantly to roll back transactions.
>
>However the MTS/Oracle fix is kludgie at best; in addition I have read in
>the newsgroups of people with problems in a production environment
 including
>hanging problems. Oracle is our standard database, and we are forced to
 use
>it, else we would implement SQL Server and save ourselves the headache :)
>
>The application we are developing is a workflow and document management
>application, with over 1,000 users. Currently we are in the
>development/prototyping phase, utilizing ActiveX components in a web
>browser.
>
>So I would like to know how reliable the two products are together, and the
>specific configuration details including: Operating System, Oracle version
 +
>patches, Oracle parameter settings, type of application, number of users,
>etc.
>
>Note: for the flamers of this architecture, please suggest an alternative
 if
>criticising this one.
>
>Thanks
>
>faizul.hamid_at_moh.gov.on.ca
>
>
>
>
Received on Sat Mar 11 2000 - 00:00:00 CST