Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Multi-threaded server
Kelly Young (young_at_maricopa.edu) wrote:
: East Asian Library wrote:
: From what I've been told, MTS should only be used "as a last resort". : In your situation, with >800 users consuming "lots of resource", I : would definitely consider using MTS.
-- MTS on Oracle versions previous to 7.3 can fragment your SGA severely. This might hurt performance. So test this thourogly. I've been told that this problem is fixed in 7.3 but I have not tested that as I'm currently working on a smaller project with no need for MTS. Rgds Steinar Heggelund ---------------------------------------------------------------------------- I'm employed in the Norwegian consulting company Opus One AS. I have 7 years experience with Oracle products, mainly the database. We are a small company which offers consulting services in design, implementation and tuning of databases and applications based on Oracle. My postings represent my opinions and they may be wrong.Received on Wed Apr 23 1997 - 00:00:00 CDT