Re: Multi-Threaded Server Question

Lynda Sohl (lyndas_at_email.mot.com) wrote:
: I am currently testing a conversion of our databases to Oracle7 from V6. Our applications and databases reside on the same UNIX machine (HP-UX 9.04). I have read that in order to use the multi-threaded server option, you must connect to the database through SQL*NET V2 even if the application is on the same machine. I am wondering if anyone is using MTS in this way and if so, what benefits has it brought you and what problems has it caused. Thank you for any information you can provide.

: Lynda Sohl
: DBA
: Components Division, Motorola Inc.
: email: ccof50_at_email.mot.com

	It depends on the version of Oracle7 you have.  I know that on the
	Solaris 2.x platform, before Oracle 7.0.16, you had to connect 
	through Sql*Net to get MTS type connections; but starting from
	Oracle 7.0.16, the installation asks you if you want to configure
	the MTS, and if you answer Yes, it will configure MTS even for IPC
	connections (MTS for Sql*Net connections is always available).

	Arshad
	Arshad.Noor_at_mail.citicorp.com