[comp.databases] Two-task architecture in ORACLE V6.

ZCTSLING@qut.edu.au (01/08/90)

I am planning to install Oracle V6.0.27.5 (with TPO and PL/SQL) 
on the VAX 8550 running VMS V5.1-1.  The Installation and User Guide 
says that if rdbms is installed with Two-Task Interface, the main 
advantage (which is our aim) is that user-written programs and oracle 
products need not be relinked when VMS is upgraded.  The main 
disadvantage is a degradation in performance of 2 to 5 percent.  
The questions I want to ask are:

1. Does Two-Task Interface work on VAX?  That is, can we see two 
   processes running for every program that uses Oracle and are we 
   truly freed from relinking rdbms, other oracle products and user 
   programs when VMS is relinked?   How much worse are the 
   performance figures for two-process jobs?  Any published docos?
   Does the second process has to be logged on and started every time 
   a program runs, or does it get reused?

2. How to archieve the Two-Task Interface?  Our installation procedure
   oracleins.com does not allow T (for two-task) in the link option
   for rdbms although the book (page 6-18, published August 1989) says so!
   Do we also have to link sqlreportwriter, sqlplus, sqlform and sqlgraph
   (as stated in the Addendum to Installation note) using T in
   the link option?  If so, then how come other products such as sqlmenu 
   do not have a link option?  It seems to me that those T for the link
   options are used not for creating two task programs, but for providing
   communication protocols when I type:
        SQLREP userid/password@T:CSVAX
   notwithstanding the fact that we have to specify 2, not T, in linking 
   sqlnet if we want to use two-task driver.

3. When T is used in linking rdbms and other products, do users have to
   specify T in linking their pro-language programs?  Can they still use S
   for single task linking?

From:	BUNYIP::root "System PRIVILEGED Account"  9-JAN-1990 01:52:29.88
To:	uqvax::newsmgr 
CC:	
Subj: