Re: two-task

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 7 Apr 2004 18:18:09 -0700
Message-ID: <2687bb95.0404071718.7407f689@posting.google.com>

cupofjava1961_at_aol.com (Cupofjava1961) wrote in message news:<20040407142132.17909.00000914_at_mb-m03.aol.com>...
> Can someone tell me what two-task is and what is it's function?
>
> Thanks

There are at least two and perhaps three meanings of the term as it relates to Oracle. I used to know them.

On UNIX systems there is an environment variable TWO_TASK that provides the default ORANET connect string such that if you enter:

sqlplus scott

it is equilivent to sqplus scott_at_TWO_TASK where the value of TWO_TASK would be an alias, now service name, from your tnsnames.ora file for the database you want to connect to.

On the VMS platform the term was used to describe how the Oracle user session processes were constructed. If my memory is correct VMS had the ability to perform the front-end user session and the Oracle background user session within one process instead of spawing a separate user session background process to perform the Oracle work. I think with 7.3 they defaulted to using the separate front-end, back-end processes found in UNIX. This was also referred to as two task.

Right now I cannot remember the third use of the term.

HTH -- Mark D Powell -- Received on Wed Apr 07 2004 - 20:18:09 CDT