Connecting to an Instance
Before a user can submit a SQL statement to an Oracle database, he must connect to an instance. The user starts a front-end tool, such as SQL*Plus, an alternative such as SQL Navigator or Toad, or runs an application developed to assist with database interaction.
Typically, the user connects and logs on to the Oracle Server. When this happens, a server process is created on the server running the Oracle Server.
This process is responsible for communicating with the Oracle instance on behalf of the user process running on the workstation or the client and for execution of the SQL statements on behalf of the user.
Connection
The connection is a communication pathway between the user process and the Oracle Server. This ...
Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
