Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is MTS reliable with Oracle?
You mentioned using Oracle objects for OLE, will this data access method work in an MTS transaction?
I have tried so many combinations that I can't remember the details of them all, however I was only successful in rolling back a transaction using the Microsoft Oracle driver, and the registry patches mentioned in the KB.
Also, I would appreciate some additional details on using MTS just as an object broker, I am not certain what this means.
I really appreciate your other advice. FYI, we will have approximately 1000 users, however I anticipate < 100 simultaneously.
Thanks
Faizul
Michael D. Long wrote in message ...
>
>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.)
>
>3.) Use Oracle Objects for OLE - the most stable and scalable sites
> are using this layer.
>
Received on Mon Mar 13 2000 - 00:00:00 CST