SQL*Net and Transparent Network Substrate

SQL*Net is the software provided by Oracle to establish connections between local Oracle database clients and the related Oracle database instance or between two different Oracle database instances via database link. It is based on the Transparent Network Substrate (TNS) protocol.

TNS is a generic logical protocol which could be executed on top of all common physical network protocols such as TCP/IP. It is based on individual logic packets which are mapped transparently to physical packets.

TNS must be able to handle the different Oracle database server connectivity scenarios:
- shared server database instance
- dedicated server database instance
- dedicated server bequeath connection
  (database client and database instance must be on the same hardware)

Visit the QueryAdvisor Knowledge Center to read more about the Transparent Network Substrate.

YouTube Channel now Online!

We have loaded new videos to our QueryAdvisor Channel at YouTube. It would be great if you have the time to browse through. Probably there is room for improvement...

QueryAdvisor now on Blogspot.com!

We have now our own blog at QueryAdvisor.blogspot.com. We will inform you there about new features and ideas. Your comments are highly welcomed! Come & See...