 |
|
Oracle SQL Net Connections Task
Oracle Tips by Burleson Consulting |
The Data Warehouse Development Life Cycle
Establishing SQL*Net Sessions
Wed Sep 14
Page 1
ram2db Database
Sessions for SQL*Net
SERVER Oracle user O/S User Machine Program
--------- ----------- ------ ------- ------------------------
DEDICATED SYS oracle ram2 sqlplus@ram2 (Pipe
Two-Task)
DEDICATED OPS$REDDY risdon ram2 runform30@ram2 (Pipe
Two-Task)
DEDICATED GLINT jones ram2 sqlplus@ram2 (Pipe
Two-Task)
DEDICATED OPS$ORACLE oracle clt2 sqlplus@clt2 (TNS
interface)
DEDICATED OPS$JOKE joke ram2 ? @ram2 (TCP
Two-Task)
DEDICATED OPS$WWRIGHT wwright ram2 runmenu50@ram2 (Pipe
Two-Task)
DEDICATED OPS$ORACLE oracle ensc sqlplus@ensc (TCP
Two-Task)
DEDICATED SECTION144 OraUser
C:\PB3\PBSYS030.DLL
DEDICATED OPS$ORACLE oracle ram2 sqlplus@ram2 (Pipe
Two-Task)
DEDICATED OPS$JSTARR jstarr ram2 sqlforms30@ram2 (Pipe
Two-Task)
DEDICATED OPS$WWRIGHT wwright ram2 RUN_USEX@ram2 (Pipe
Two-Task)
12 rows selected.
Here, we see each of the following four types of
SQL*Net connections:
* Pipe Two-task--Used for internal tasks (SQLPLUS
/).
* TNS Interface--Used when connection is
made with a v2 service name (SQLPLUS /@ram2)
* TCP Two-task--Used when connection is made
with a v1 connect string (SQLPLUS /@t:ram2:ram2db).
* PC Connection Task--Denoted by the PC DLL
name (c:\pb3\pbsys030.dll = initiated via PowerBuilder DLL).
This is an excerpt from "High Performance
Data Warehousing", copyright 1997.
 |
If you like Oracle tuning, you may enjoy the book
Oracle Tuning: The Definitive Reference , with over 900 pages of BC's favorite tuning
tips & scripts.
You can buy it directly from the publisher and save 30%, and get
instant access to the code depot of Oracle tuning scripts. |
| 
and include the URL for the page.
