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: